Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing in one report
Message
From
21/10/2002 13:35:11
 
 
To
21/10/2002 10:13:17
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00713501
Message ID:
00713581
Views:
16
>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
Map
View

Click here to load this message in the networking platform