Hi,
Is it possible to create Expand/Collapse functionality for the grouped data in Table and Matrix data regions? Essentially, the idea is for the user to be able to see the group/subgroup data if she wishes to by clicking on (+/-) symbols, as is usually the case in Tree View style data grid control in web apps. Any ideas how to accomplish the same in reporting services?
Thanks.
Never mind... I found it in the Tutorials How-To topics under grouping data regions section.What you explain as your goal is the behavior I see in RS 2005. If I assign a Toggle Item to a table column, columns to the right of it move left when the column is hidden.
Are you sure you're assigning the Toggle Item to the Table Column instead of the individual table cells within the column?
-Chris
|||Hi Chris, thanks for hte response. I tried what you suggest, and that is select an entire column and assign a textbox to control the visibility, but whenever I did that, I get the following error:"The definition of the report '/ForecastReport' is invalid. The table 'table1' has 'textbox37' as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and caonnot be contained within the current report item unless current grouping scope has a Parent"
One interesting thing about this error that I just noticed is, in the report designer, I have tripled checked to make sure I've got the desired COLUMN selected, not 'table1'.|||Perhaps more telling, when I select an entire column in the designer and then go to the "visibility" section, the "ToggleItem" drop down is completely empty of available choices.|||
Did you ever found a solution to this. I do have the same problem.
yours sincerely
Johan
What you explain as your goal is the behavior I see in RS 2005. If I assign a Toggle Item to a table column, columns to the right of it move left when the column is hidden.
Are you sure you're assigning the Toggle Item to the Table Column instead of the individual table cells within the column?
-Chris
|||Hi Chris, thanks for hte response. I tried what you suggest, and that is select an entire column and assign a textbox to control the visibility, but whenever I did that, I get the following error:"The definition of the report '/ForecastReport' is invalid. The table 'table1' has 'textbox37' as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and caonnot be contained within the current report item unless current grouping scope has a Parent"
One interesting thing about this error that I just noticed is, in the report designer, I have tripled checked to make sure I've got the desired COLUMN selected, not 'table1'.|||Perhaps more telling, when I select an entire column in the designer and then go to the "visibility" section, the "ToggleItem" drop down is completely empty of available choices.|||
Did you ever found a solution to this. I do have the same problem.
yours sincerely
Johan
I am working with SQL reporting services, I am getting the data dispalyed...
the only problem is that I am not able to collapse, ie (+) button next to the row header and the cloum header.
Can any one let me know, how to get that....
Thnks in adv.
Hi,
i don′t know how familiar you are with Reporting Services, but this is the function accessible through the Hidden property. Select e.g. a group in your table (clicking on the row left next to the table) and choose the property Hidden = True, then specify a toggle item (up the hierarchy of the group could be a textbox in the table) which should display the +/- signs:
http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Hello,
I have a report that contains a single group for customers. Each customer order is placed as a detail record under the group. I have the group header setup to toggle the detail records (so if a user clicks the plus sign image, the details are shown, if the user clicks the minus image, the details are hidden). By default when the report opens up the details are shown.
Rather than having the user click through each customer row to collapse all the details, is it possible to place a "collapse all" image or control somewhere on the report that will handle the collapsing of all the detail rows for each customer record? I assume if there is a way, there is something similar for expanding all as well?
Thanks!
The "initial state" of toggles on groups can be determined by expressions. You could add e.g. a boolean report parameter and then set the initial toggle state of all toggles to be based on the report parameter value.
-- Robert
Hello,
I have a table in the report.
the table contain group and details
the details are hide by default and the groups have a toggled to collapse the details
so in order to see all details for all group user need to open every group.
is there any option to collapse all ?
Also I have several tables in the reports that hide by default and user have a toggled to view the table.
any option for one click to collapse all tables ?
Thanks
Idan
Hi,
no, there is no collapse all switch. You can use a report parameter and check this one in every hideable table / object.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
