animated405
asked on
MS reporting services toggling
Hello,
I have a report that drills down purchase information by region, then the different types of products purchased in that region, then further into the different products themselves with the counts and revenue totals for each
here's the dilema: some of the types illustrated are freight and tax that account for some of the revenues, but since this level is expandable, it just expands into one more level deep with the repeated information, for example:
+televisions 27 42,000
plasma tv 3 10,000
HDTV 1 20,000
old tv 23 12,000
+frieght 27 400
freight 27 400
how can some formatting to the toggle to only expand those rows that aren't freight??
thanks in advance!!
ASKER
I figured as much that's good to know. that's going to confuse my users so I'm just going to leave it as is.
What if I wanted to ignore those rows alltogether? What would I put in the expression to do that? I know how to manipulate the data by checking the values, but haven't seen anything for ignoring a row all together
thanks
To ignore the rows, its probably best to filter them out at the dataset level. You could use a filter, but its a bit slower.
ASKER
thanks. the requirements I've been given wil not permit me to pull them out at the dataset level. Since I do not want to show the toggle I was thinking that I could show one group minus these rows with the toggle then another group immediately below it without the toggle. do you know of a good tutorial somewhere to show me how to filter these rows?
thanks again
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
On the Detail Row, set the Visibility->Hidden property to the expression =IIF( Count(Fields!MYFIELD.Value
This will hide your freight 27 400
Although the toggle will still display, it won't do anything.