I've been trying to get this to work for days now and am running out of patience. I downloaded the DynamicPages.qvw file and I thought I understood how it all works -- it does exactly what I want, which is to provide a set of buttons to hide or show one or more tab sheets in my document.
I created a series of text objects which set a variable called vSheetGroup. Each button sets a variable letter from A to G.
I created the CROSSTABLE just as the example does passing a SheetName and SheetAllowed variables as well as the OSUser, then initialize the table with a LOAD * INLINE which appears to be working, I can see all the values being set correctly.
Each tab page then has a condition variable set which uses the SheetName and the OSUser to hide or show the sheet:
=sum({<SheetName={'Sheet 6'},OSUser={'$(vOSUser)'}>}if(index(vSheetGroup,'B') > 0,SheetAllowed, 0)) > 0
The only difference is I use different sheet names, but they are all just strings. Each page has an index value of A thru G, selecting Show All sets the vSheetGroup to ABCDEFG. The Sheet Security buttons set the variable vSheetSecurity to either 1 for on or 0 for off.
Lastly I defined a variable OSUser as
=if(vSheetSecurity = 1, OSUser(), '*')
But regardless of all this, clicking the buttons on my menu page does nothing (other than set the value of the vSheetGroup variable, which I can see in the Variable Overview)
I must be missing something. I have all the same variables and condition variables, the only differences are the names of the sheets. How can I figure out what is going wrong? I also tried removing the OSUser column since I don't really need it but that made no difference
Thanks for any suggestions.
Gary
