Report problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Crystal - 12 Dec 2005 18:37 GMT

This question deals with the report and the underlying table. I am entering
information in by Grid ID (ex. A25, A26, B5, C10). So, the report prompts
you for a Grid ID and everything about that grid shows up in the report.

My question is that in the Grid ID column, if I entered in "A25, A26, B10,
E5", how to I tell the report to pull just the information from A25 or A26.
How does it read the entire string of numbers and know I only want 1 part of
the information?

Reply to this Message

Rick B - 12 Dec 2005 18:55 GMT

To find a string in a field, you'd use...

Like "*" & [Enter desired grid] &"*"

But, the bigger issue here is that your data seems flawed. A field in a
record should contain exactly one piece of information. If you have three
"grid id's" then you should have three records - one for each grid id.

Signature

Rick B

> This question deals with the report and the underlying table. I am
> entering
[quoted text clipped - 7 lines]
> of
> the information?

Reply to this Message

Crystal - 12 Dec 2005 19:01 GMT

Rick

Thanks for the help. All the grids were collected together so the rest of
the information in the report deals with all those grids collected.

Where would I put the Like "*" & [Enter desired grid] &"*"....Does it go in
the query that the report is built off of?

> To find a string in a field, you'd use...
>
[quoted text clipped - 15 lines]
> > of
> > the information?

Reply to this Message

Rick B - 12 Dec 2005 21:54 GMT

Yes. In the query.

Signature

Rick B

> Rick
>
[quoted text clipped - 29 lines]
>> > of
>> > the information?

Reply to this Message

Crystal - 13 Dec 2005 16:19 GMT

Rick-

Maybe you can help with my next problem! The Like clause works but in ther
report under Grid ID, the report lists the entire string. So when I enter
B5, the report shows "A5, B5, B6, C6". Is there a way to have the B5
highlighted or in a different font color?

> Yes. In the query.
>
[quoted text clipped - 31 lines]
> >> > of
> >> > the information?

Reply to this Message

Rick B - 13 Dec 2005 16:29 GMT

Probably, but I am not sure how. I guess you could simply put your user's
prompt there on the report instead of the data field.

Again, if it were me, I'd create one record for each, even if it means you
have to run some code to fix your existing records.

Signature

Rick B

> Rick-
>
[quoted text clipped - 44 lines]
>> >> > of
>> >> > the information?

Reply to this Message