Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Printing in one report
Message
De
21/10/2002 13:35:11
 
 
À
21/10/2002 10:13:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00713501
Message ID:
00713581
Vues:
17
>I have a table composed of four field
>field 1 Student Name
>Field 2 Mathematic, Chemistry ,Biology
>Field 3 Physic Mathematics Economic
>Field 4 Biology chemistry Mathematic
>
>how can I print in one report the same subject only.
>example "only the mathematics students appear"
>or if I want to print only student with chemistry subject"
>it seems I am turning in a deep loop
>
>I guess it's complicated
>
>Any help

While data normalization is the best answer, sometimes its necessary to provide support in situations where restructuring data isn't an option.

You can get the report result you want by processing your information into a properly structured cursor or table and run the report against that data.

It appears that you want to end up with a report that shows students for whom "mathematics" appears in field 2 or field 3 or field 4.
Look at the atc()function.

NOTE: Based on your example you may end up with duplicates and will need to get a distinct set.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform