Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reporting on values within an array
Message
From
04/06/2001 01:48:19
 
 
To
04/06/2001 01:44:35
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00514419
Message ID:
00514421
Views:
13
This message has been marked as the solution to the initial question of the thread.
>Hi all,
>
>I have a sloppy way of performing a report print and was wondering if someone had a slicker way of doing it. I have
>a Master Table with a dependent table. The dependent table contains classifications. The user can request
>to print out people who have any one of the many possible classifications. For example, out of a possible 40 classifications,
>they select 20 to report on. These 20 are loaded into an array and compared against the values in a field in the dependent
>table.
>
>I don't want to say REPORT FORM report1 FOR dependent.classification = ARRAY(1,1) or ARRAY(2,1) or ARRAY(3,1)
>20 times. It would be simplest if there were a REPORT FORM option to see if a field value matched any of the entries
>in an array, but I don't see that as an option.
>
>I would like to do this as cleanly as possible, without creating a cursor table if possible. However, I'll go with whatever
>works best.
>
>Any thoughts or suggestions?
>
>Thanks in advance.
>
>Fred E. Beaulieu

What's wrong with the cursor? That's really the best solution for that kind of situation. REPORT ... FOR has a bug in it, that even if you did get the report you wanted and were doing a PREVIEW, you'd still get all the records if you then printed it from within the PREVIEW.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform