Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some thoughts ...
Message
From
22/07/1999 03:45:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Some thoughts ...
Miscellaneous
Thread ID:
00244578
Message ID:
00244578
Views:
40
Sometimes I bump into 2 limits (I think) with the FP reportdesigner :
1. the reportdesigner is recordbased
2. the reportdesigner is based on only one recordset

Let me explain what I mean :

1. recordbased : you need at least one record before the report wants to print or in other words, the detail band prints for each records, so no records, no detail band, and no detail band no header, no title, no footer no nothing. If you want to print a form that isn't based on a table/view/cursor/ etc you must invent some tricks before you can do. Example : I want to print a page when an error occurs in the program, that the user can fax, so I can examine the error. I first have to put the data I want to print in a cursor before I can print ...

2. based on only one recordset : suppose you need to print a report with some records of table 1, some records of table 2, and finally some records of table 3. The 3 tables aren't related to each other in any way. Before in FP dos I knew some tricks to do this, and for one case I found a trick in VFP, but there's no generic solutioin for this problem afaik. Example : an invoice which contains products with diff. VAT rates. At the end of the invoice, you have to print for each VAT rate a totalline. For this I found a workaround with arrays built in the pre and post processing for a band, but this works only for a limited number of lines ; if the number of VAT rates would be unlimited and/or unknown, this wouldn't be a solution.

How do you solve these problems ? Comments ? I thought I read here on UT, for microsoft, the reportdesigner isn't a priority as a reportdesigner doesn't fit into the position where MS wants to situate VFP ...
Next
Reply
Map
View

Click here to load this message in the networking platform