Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vary object position programmatically in report?
Message
From
25/05/2006 19:43:58
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Vary object position programmatically in report?
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01125119
Message ID:
01125119
Views:
49
In the old days, before the report writer, I would hand code my reports with @say, I could vary column positions by defining them in variable.

Now I have a sales report, with data as follows:
M1,M2,M3,Q1,M4,M5,M6,Q2,M7,M8,M9,Q3,M10,M11,M12,Q4
laid out horizontally in landscape mode in one frx.

Sometimes the customer may want to see only quarter 1 data, other times
q1+q2, other times q2 + q3, or q2+q3+q4

If for example the customer wants to just see q2 or q2 and beyond, I could have when clauses in the print when that let me suppress q1. But then the data will appear offset to the right, for m4,m5,m6,q2 and beyond, when really it should be left justified.

Right now the only way I can think of to do this is to have 4 frx's:
2)all, m4,m5,m6 and beyond, 3)m7,m8,m9 and beyond, 4, m10,m11,m12 and beyond

Can I vary the output column position at report runtime? This would allow me to only have one frx. I'm guessing that I could programmatically manipulate the frx at runtime, or a copy of it and then run it. But I don't know the frx internals. And besides this seems tedious.

Any suggestions appreciated.

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform