Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying cross tab data?
Message
From
27/07/2007 15:28:19
 
 
To
27/07/2007 13:49:01
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01243774
Message ID:
01244236
Views:
21
Gotcha!

Thanks for the clarification.

>The idea is that, as with a spreadsheet, you have multiple pages across as well as down. So the calculation I showed is to figure out how many pages _wide_ the report is and the complex expression for each field lets you run the report multiple times, but get different results depending on the value of the nPage variable.
>
>Say your user picks 87 columns and you've design the report with 10 columns. If you use the mechanism from Nancy's article, the nPages variable will be 9 and the REPORT FORM will run 9 times. The first time, it'll report on fields 1-10; the second time, fields 11-20, and so forth, until the last time through the loop, it does fields 81-87.
>
>Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform