Banding - loop report over possible values in field
This banding feature is good but I have one issue. My "dimensional attribute" that I am "looping" over has members/rows that have no data for my current selection. This in itself is fine and "correct" but I dont want those dimensional members/rows printed on the report. In the properties of the table/chart that I have in my report i have:
1) under dimensions -> suppress value when is null and
2) under presenetation -> suppress zero value in all columns
The second option i suspect only works if there is zero values, for a row, in all measures but i have not tested it. Anyway, neither option suppresses banded rows that do not have associated data. Because i dont see these values in my table with current selections, I assumed the report would not print them either but such does not appear to be the case.
Nice Rob. I will try this because it seems like i might be able to create a more generic row condition test with this method. What i did was create a variable and a document trigger that populates the variable with an expression. I retrieve the value of that variable in the script and do a test to see if I can print or not (much like your test). Problem with my method is that the "on change" document trigger requires you to specify the dimension that when changed, updates the expression. It works but I have to create all these extra triggers for each possible dimension that i want to use as a filter.
