n-up & visible expression

[bendep]

when you make a new dw, style n-up, and use a visible expression to show/hide a column based on the value of a another column, the first control's visible expression is used for all the following columns on that level. eg: when rows_per_detail is 3 and the first visible expression results in true, the 2nd & 3rd row_per_detail will also be shown, regardless of their corresponding value for the visible
expression.

Can somebody confirm me that this is a bug? Or else, what am i overlooking in the documentation?

Thanks,

Ben

 

[bendep]

Guys (and girls),

i cannot believe this.. i found a solution but it's really weird.. haven't found anything about it in the docs. thank god for google..

in short: using an expression with n-up does not work in the usual way.

suppose you have 2 columns:
- col1 = long
- editcol1 = string(20)

setting an expression on e.g. editcol1.visible will result in the expression being evaluated once (value for first row per detail) for all rows_per_detail, regardless of their different values for that column.

Solution (thanks to

http://www.bcarter.com/tip023.htm):

It turns out that you need to treat the repeated columns as zero-based arrays.

the expression would become:

"If(col1[0] = 1, 1, 0)" --> for the first detail_per_row
"If(col1[1] = 1, 1, 0)" --> for the second detail_per_row
"If(col1[2] = 1, 1, 0)" --> for the third detail_per_row
...

Note that the index of the first element is 0, while powerbuilder arrays start with index 1! (smells like C++ spirit, doesn't it?)

Talk about consistency!! (maybe that would be a nice topic for futures discussion)