Updating a Variable via Record Data
Posted on 2006-06-14
Okay, I'm an intermediate Crystal Reports user, so I may need some hand holding on this. Here is what I'm trying to do.
I have an activity log that is being stored in a SQL database. I want to use CR to pull a report out of that data and group it. I have data that (simplified) looks something like:
01>Import file CUST1.MAP
02>Beginning data read
04>Creating transaction #001
05>Creating transaction #002
06>Document verification complete
07>Import file CUST2.MAP
08>Beginning data read
10>Creating transaction #001
11>Document verification complete
12>Import file CUST3.MAP
and so on...
The above is the message status record. There are other records I pull as well (process no., process type, time/date, etc.). I would also like a record on the report that lists the customer that the above fields apply to. By reading the right chars of the field, I've been able to get it to recognize the customer when it hits those lines that open the import file (CUST.MAP), but what I want to do is carry that down to all the rows beneath it until it hits the next customer. For instance, lines 01-06 should have a field that reads CUST1, lines 07-11 should have one that reads CUST2, etc.
I've tried using a global variable, and updating it when that change occurs, but that is not working for me. Is this even possible?
And let me know if I haven't explained this properly, and I'll go a bit more in depth.
Thanks for any help you can provide.