Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
5 dates for 5 reports
Message
From
19/08/2004 18:11:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
19/08/2004 13:46:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00934586
Message ID:
00934693
Views:
22
You can use data grouping - from the report menu - to group by date. Use the date field as your variable.

Then, in the group header, or group footer, put anything you want to put when the date changes. To make it look like your example, you would just put an empty line.

If you want data for each date on a separate page, you don't need a separate report for each date; you can handle this with data grouping, too.

>Hello,
>
>I want to produce 5 different reports based on 5 different dates from mytable.dbf
>
>mytable.dbf
>
>sname cdate
>
>aaaa 08/01/2004
>bbbb 08/01/2004
>
>cccc 08/02/2004
>dddd 08/02/2004
>
>eeee 08/03/2004
>ffff 08/03/2004
>
>gggg 08/04/2004
>hhhh 08/04/2004
>
>iiii 08/04/2004
>jjjj 08/04/2004
>
>myreport1 contains only :
>aaaa 08/01/2004
>bbbb 08/01/2004
>
>and next myreport2 with the same UDF to group by date on the same day.
>
>Tia
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform