General information
Category:
Reports & Report designer
Title:
Vary object position programmatically in report?
Environment versions
Network:
Windows 2000 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only