Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Toggle MS Reporting Service groups

Posted on 2005-04-11
Medium Priority
Last Modified: 2012-08-13

Hello, I'm having an issue with a report where I have information on product sales, grouped by the shipping location, then type of product with each product shipped for each type listed within the second group. I want to toggle the groups so that initially the top level groups of shiping location is ony shown, then when expanding the shipping location to show the summary of types of products shipped, then expanding that to show the individuals products for each type beneath that. Right now, when I toggle the top level shipping location, the details of the products hide and come back but the other groups do not dissapear along with it.

This is difficult to explain without being able to show the report. How do you set up the groups so that they toggle other groups??

thanks in advance!!
Question by:animated405
LVL 14

Accepted Solution

simon_kirk earned 2000 total points
ID: 13751643
Guess this is the drilldown you are after:

+ Shipping Location
         + Product Type
                  Product Details

Select the Product Details row, goto Properties, and set the Visibility Toggle Item to be the Product Type textbox, and set Hidden as True
Select the Product Type row, goto Properties, and set the Visibility Toggle Item to be the Shipping Location textbox, and set Hidden as True

Should work, though depends slighlty on whether your using a Matrix or Table, and how you've got your groups setup in terms of thier header/footers etc.

Author Comment

ID: 13751698

thanks for the quick response, turns out I just needed to get away from my computer for a minute cause I figured it out right away when i got back. points for speedy response


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month11 days, 22 hours left to enroll

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question