Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simulating 2 detail bands
Message
From
31/12/1999 15:48:54
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00308778
Message ID:
00311023
Views:
20
I am looking for a solution myself. In the top of my form I faked running a "Short" detail for one sql selected table and just added all records into a variable using scan/endscan and let the field-box's "Stretch" feature of the rpt-wrtr do the word wrapping using Courier-New, a fixed-cpi font. This is limited in size unless this info is put into a memo-field. I still have the problem of outputting 2-lines per record (some blank to be filled with SPACE()).
I will try The "Union-Print-when" strategy below.

>>Is it possible with the foxpro native report writer Nest detail bands, or create 2 detail bands?
>
>The best you can do is to simulate 2 or more detail bands using some condition for the "print when". You would need to "combine" the data for the multiple detail bands into one cursor for the report, identifying the different "detail bands" in the cursor.
>
>Table1 has field1 & field2
>Table2 has field3 & field4
>
>
>SELECT '1' AS BAND, ;
>       field1, ;
>       field2, ;
>       field3 AS SPACE(whatever), ;
>       field4 AS SPACE(whatever) ;
>       FROM table1 ;
>       UNION (SELECT '2' AS BAND ;
>                     field1 AS SPACE(whatever), ;
>                     field2 AS SPACE(whatever), ;
>                     field3, ;
>                     field4 ;
>                     FROM table2) ;
>       INTO CURSOR reportdata
>
>
>Now use the cursor field BAND in the "print when" conditions.
Previous
Reply
Map
View

Click here to load this message in the networking platform