Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reporting on values within an array
Message
De
04/06/2001 01:48:19
 
 
À
04/06/2001 01:44:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00514419
Message ID:
00514421
Vues:
14
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform