Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Code lookup
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00809576
Message ID:
00809591
Views:
30
This message has been marked as the solution to the initial question of the thread.
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform