Hi,
I'm trying to build a crosstab report i ReportStudio against an Powercube. The report will be drillable in the rows (not drillthrough to another report, just through the dimension.) For example: I start with ProductLine in the rows, and click an row to drilldown to the ProductType level and so on.
On the lowest level I need ta apply zerosupression, (for exampleÃ, ProductName), but I dont get it to work.
If I place a summary filter in the query, (meassaure<>0), I need to set a scope for the filter. Since I don't have ProductName in my original report I can't set the scope to it, and therefor the summary filter wont work.
If I add the ProductName level to the query and then set the scope to it, I'm no longer able to drilldown in the report, because you only can drill on the lowest-level-querysubject in the query...
Any suggestions how to solve this?
???
Regards.
Have you tried putting the filter at the detail level?
What about using a slicer filter?
A detailed filter wont suppress the rows. A slicer don't suppress the other rows either, it just hide the figures for the "unsliced" categories...
/Iceman