Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I create five detail bands in a report
Message
From
03/09/2001 07:38:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00551520
Message ID:
00551768
Views:
28
>dear hilmar
>table 1 has field1,field2,fiedl3
>table 2 has field4,field5
>table 3 has field6,7,8,9,10
>table 4 has fiel11,12,13,14
>table 5 has field15,16
>thank you

Sure. I sent just an example.

In the example you give, you have to create field1..field16 for each of the five tables, same structure for each, and combine the results with a UNION. Add an additional field, "table", that says from which of the 5 tables the data comes. This allows you to print conditionally - for instance, the first sub-report is only printed for the condition "table = 1".

HTH! Hilmar.
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
Next
Reply
Map
View

Click here to load this message in the networking platform