Focal Point
Style sheet column reference. Relative vs absolute

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/628107824

April 27, 2010, 06:41 AM
Dave
Style sheet column reference. Relative vs absolute
Hi all,

Question...

While making a report with the Report Painter the style sheet refers to columns with a number. Like:
TYPE=DATA,
    COLUMN=N10,
    BACKCOLOR=RGB(255 255 153),
$


But in the forum, and elsewhere, I sometimes see:
TYPE=DATA,
    COLUMN=SALES,
    BACKCOLOR=RGB(255 255 153),
$


e.g. Refering to 'SALES' in stead of 'N10'.

I prefer the last one because when you shuffle the columns manually ( outside the report painter ) all lay-out gets scr3w3d up! Including drill-downs.

Especially adding an extra BY field is annoying because everything shifts +1.
( also when making a report with a dynamic number of BY-fields )

Is there a setting or configuration to make the report painter use the 'absolute' reference in stead of the 'relative' ones?

If not... IBI... that would be a nice new feature.

Greets, Dave


_____________________
WF: 8.0.0.9 > going 8.2.0.5
April 27, 2010, 10:34 AM
GamP
Dave,

If you create and maintain your reports using DS then you will not have the problem of shifting columns because DS will keep a correct track of things.
If you do it manually, then also this is not a problem, since you keep track of things yourself.
The problem only arises when you go mixed mode.

To my knowledge there is no such setting. DS will do these things by column numbering.
So, if you want to make it a NFR - go ahead - there may be other people that also find this a thing to be improved.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988