>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.