Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Report Layouts In One Form
Message
From
26/01/2002 01:41:32
 
 
To
26/01/2002 01:05:06
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00610987
Message ID:
00610991
Views:
19
>I need to print a report that includes a cover page, a table of contents, tabular data with a graphic, and cross tabs. I have an app that prints this report, but it uses 4 different report forms, which means that to preview, you have to preview it in 4 pieces.
>
>So, I made a data file with the data for all 4 reports, and added a PAGETYPE (1,2,3, or 4) to the table. Then I put all the objects from the 4 report forms into one form and used a WHEN clause for every object (print when PAGETYPE=1 or 2 or 3 or 4.
>
>I thought I was there but then this: The 4 different layouts require different heights of header, detail and footer bands. Is it possible to change these heights on the fly?

You've done the usual report tricks. Your next step is probably to hack the .FRX:

- copy the original .FRX/.FRT out to another name
- open the copy as a table and hack it

John Koziol wrote a FoxTalk article referenced below that would probably help.

http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~?2,41,17,579414#579417

Failing that you might have to try something like Crystal Reports, which I understand is more powerful but may not be able to do what you want to do here.

>Also, I need a utility that creates a pie or bar chart from tabular data which I can distribute. Any ideas?

You might automate Excel (or some other charting program) and create a chart, then print to a .PDF with the Adobe Acrobat Distiller.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform