>Have a report that is basically using the input from a single cursor. The cursor was created in a program with several SQL calls. I want the report to have the description of the code, and not just the code. There is an array already built that I can use. Wondering where in the report designer can I put an array lookup for a field in the detail group. I could lookup the description in my program, but curious about if it can be done in the report designer.
>
>Brenda
You could put a field in the detail band whose value is actually a user-defined function call. You can then create a report variable that counts each record printed or sums a field. Pass the value of that variable in the function call. Alternatively, you can pass the value of some field that is currently being printed in the detail band. Your function can then use that value to determine what array element value to return to the report.
Mark McCasland
Midlothian, TX USA