roberthagan
Technical User
I'm another frustrated Crystal user, tring to figure out things that are easy there, and not obvious in RS.
I have many situations where I need to find a value in a set of rows based on some condition and pass it for display on a group.
Example, in a set of client statuses, find the status just before a closing status. On the detail row, use the Previous function:
Iif (Fields!STATUS.value = "C", Previous(Fields!STATUS.Value),"")
In Crystal just declare a variable: lastStatusBeforeClose :="" on the group header, Put another lastStatusBeforeClose variable on the group footer to display the value. There doesn't seem to be anything comparable in RS. I've tried referencing the detail textbox from the group, but discovered that you can't reference objects between groups. I've tried doing a function and gotten an error about declaring a non shared object... etc. Is there a solution?
I have many situations where I need to find a value in a set of rows based on some condition and pass it for display on a group.
Example, in a set of client statuses, find the status just before a closing status. On the detail row, use the Previous function:
Iif (Fields!STATUS.value = "C", Previous(Fields!STATUS.Value),"")
In Crystal just declare a variable: lastStatusBeforeClose :="" on the group header, Put another lastStatusBeforeClose variable on the group footer to display the value. There doesn't seem to be anything comparable in RS. I've tried referencing the detail textbox from the group, but discovered that you can't reference objects between groups. I've tried doing a function and gotten an error about declaring a non shared object... etc. Is there a solution?