General information
Category:
Reports & Report designer
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only