Information générale
Catégorie:
Gestionnaire de rapports & Rapports
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement