Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reporting on values within an array
Message
From
04/06/2001 01:44:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Reporting on values within an array
Miscellaneous
Thread ID:
00514419
Message ID:
00514419
Views:
46
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
"Sometimes, the agony of not knowing can be more cruel than the truth" - The Fatman Detective Agency
Next
Reply
Map
View

Click here to load this message in the networking platform