Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi pages report
Message
From
14/09/2005 02:01:32
 
 
To
13/09/2005 22:55:48
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01049296
Message ID:
01049314
Views:
14
Hi John,
If these are only totals that you hv to show scattered on 4 pages
then you can prepare 4 record cursor with all fields/totals you need to show, and then simply make frx with grouping on recno() / start each group on new page. Cursor can be completely denormalised having different fields for each page if necessary. Then you hv to play with prinwhen till you get it right.

If you hv to show some line by line detail data on each page, then you hv to make another cursor related to the first one (one to many relation) and show it in detail band.

Now, if you are XFRX user you could also accomplish that
by composing report in code using amazing XFRX-11 script commands.

Also there is possibility to produce all this via nicely designed
excel template and then simply fill up predefined cells with totals from yr system. If you decide to do somthing like this then you can have look at my
'rep2excel' tool for writing to excel here in downloads.
You can also chk 'CodeRep' for writing OOP reports in code to excel and some other formats.

Hope this will help u solve yr problem.

Rgds++
Sergio










>Hi,
>How could I create a multi pages report?
>Actually, it is a 4 pages formal letter. It contains summary details such as total shares and etc.
>
>Any ideas? Should I use "PRINT WHEN" expression?
>
>Thank you
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform