Skip to Content
Former Member
Jul 18, 2007 at 05:46 PM

Can we define a variable in WAD like QD?


hi gurus

we have this report that is using a WAD template. now we have 2 seperate hierarchies, i am using a Hierarchical Filter Selection in the template, for the user to be able to navigate in a hierarchy with in the report.

now the problem is can i have 2 Hier i want the user to pick one of those to run by based on the user input. is that possible ? in WAD you can define only one Hier to run the report from. cant there be a selection.

i already tried defining a variable in Query Deigner, but that conflicts with the hier selection in WAD. and i get a error when i run the report. the "Hierarchical Filter Selection" block on the template doesnot work.

is there any other way i can solve this issue ?