Skip to Content
0
Former Member
Mar 03, 2009 at 07:57 PM

Hiding Structure Elements when the query executes

194 Views

Hello All,

Question about structures in Query Designer.

Is there any way to hide structure elements at run-time (or pre run-time) depending on a variable?

In other words,

We have defined a structure with 20 columns - each will represent a certain year. Each column is a shell, driven by a 0fiscyear variable.

For example, if the user does not have the data for 20 columns, but only 15, is there any way to hide the other 5 blank structure columns at run-time?

We need to keep structures, because some formulas are cell specific.

Any help would be much appreciated,

Dmitriy