Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing variables to report form
Message
From
25/07/2002 19:34:15
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Passing variables to report form
Miscellaneous
Thread ID:
00682832
Message ID:
00682832
Views:
54
Hi All,

I'm currently working on customising a 3rd party VFP6.0 application. The customisation involves among other things creating reports from complex selection screens. I'm using SQL in most cases to create a cursor which I use as the driving table for the reports. A number of the reports need to print the selection parameters from the selection screens at the top of each report. E.g. if I selected customers 1 to 100, transactions posted 1st July to 31st July and revenue in the range $1,000.00 to $2,000.00 I want to print these parameters at the top of the report. I decided to create another cursor which has 1 record and contains the selection parameters and in the report I would place these cursor fields at the top of the report. Does anyone see anything wrong or inefficient with this approach? Would using variables that are set just before the report is printed (e.g cCustomerFrom = ThisForm.txtCustomerFrom.Value ) and referring to these variables in the report be a better approach?

All suggestions welcomed.

Thanks,
Gavin...
Next
Reply
Map
View

Click here to load this message in the networking platform