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 ?