Link to home
Start Free TrialLog in
Avatar of animated405
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!!
Avatar of simon_kirk
simon_kirk
Flag of United Kingdom of Great Britain and Northern Ireland image

As far as I know you can't manipulate the toggle control for one row/grouping, it's either view all the toggle controls or view none.  You could surpress detail rows being shown by using something similar to:

On the Detail Row, set the Visibility->Hidden property to the expression =IIF( Count(Fields!MYFIELD.Value)>1,FALSE,TRUE)

This will hide your      freight               27   400

Although the toggle will still display, it won't do anything.
Avatar of animated405
animated405

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.

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
Avatar of simon_kirk
simon_kirk
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial