Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tabbed Reports in SSRS Expand / Collapse
Author
Message
Posted Monday, December 22, 2008 6:21 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 7:34 AM
Points: 1,475, Visits: 108
Gurus,
I have a requirement where in the client is asking for Multi - tabbed reports in single report. For Example, In a report named "XYZ", there can be multiple tabs like"Employee","Sales","Countries" etc. On clicking on the Corresponding tab, corresponding data should be displayed. Is there any way to achieve this functionality. I am using SSRS 2008. Any pointers would really help.

I tried having text boxes and had multiple Tablix controls and controlled their visiblity by the text box toggling. but i need to click on the same textbox to hide and click on the next textbox to make that visible.
Post #623899
Posted Tuesday, December 23, 2008 12:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 11, 2011 11:56 AM
Points: 172, Visits: 113
I have done this using a parameter to show/hide subreports on a single report. My parameter was a multi-select parameter, allowing the user to show as many of the reports as he or she liked.

It sounds like you are interested in showing only 1 report at a time and having each 'tab' control showing the corresponding report and hiding all others, correct?

Michael R.
Post #624940
Posted Tuesday, December 23, 2008 9:02 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 7:34 AM
Points: 1,475, Visits: 108
Yeah. Need to have multiple tabs in one report. I read a round about solution in another forum. Have text boxes on the top with Tab like back ground image and have the tables for each of the text boxes and have collapse or expand the tables based on the text box.

Any more thoughts would really help
Post #625159
Posted Thursday, December 25, 2008 8:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 8, 2010 9:45 AM
Points: 6, Visits: 96
Not knowing more about your situation anything I recommend could be totally unusable or work like a charm.

How tied are you to Report Manager? How much control of the computer systems hitting the application do you have?

I am beginning just such a report. I will be using ASP.NET AJAX to collect parameter info and the Tab from the AJAX Toolkit to display different panels. I plan on putting an iFrame in each panel and launching the Report via a web call and display it in the frame. The CSS folk would probably like to string me up but since the application for our local plant and we only allow IE6 as the browser this will work just fine for what I need. It might work in your case also.

Regards,

Mike
Post #625710
Posted Monday, January 5, 2009 12:52 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 11, 2011 11:56 AM
Points: 172, Visits: 113
Here is another workaround that may be helpful:

http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Use a hidden parameter and drillthrough links back to the same report. The hidden parameter will be used in the visibility of each item to show/hide based on a formula.

Hope this helps!

Michael R.
Post #630074
Posted Monday, February 2, 2009 2:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 26, 2013 10:41 AM
Points: 9, Visits: 22
Does this port to Excel?
Post #648410
Posted Wednesday, February 5, 2014 11:23 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 6:12 PM
Points: 827, Visits: 342
Michael R (1/5/2009)
Here is another workaround that may be helpful:

http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Use a hidden parameter and drillthrough links back to the same report. The hidden parameter will be used in the visibility of each item to show/hide based on a formula.

Hope this helps!

Michael R.


The link is dead. Does anybody have a sample of tabbed report which exports each tab in a separate excel sheet of a workbook?
Post #1538308
Posted Tuesday, March 25, 2014 5:22 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:16 AM
Points: 60, Visits: 98
Hi Amit,

I too am also trying to figure out how to make tabbed reports in SSRS, but I'm using 2005, it's probably a lost cause. ANYWAY, I'm writing to tell you that even if you can't get the tabbed reports in ssrs to work properly, you can export to multiple tabs in excel. Simply have all of your report tables/matrices in the layout tab (its the layout tab in 2005, not sure about 2008) and insert page breaks before each table (start the page breaks on the second table in the layout, the first table will automatically export to the first tab in excel).

I know this doesnt get you where you need to be, but it could buy you some more time as a temporary solution.

Mike
Post #1554379
Posted Thursday, March 27, 2014 7:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 1:03 PM
Points: 23, Visits: 51
Hi,

Have you tried the standard option DocumentMapLabel ?
That way no page breaks or extra boxes or other weird stuff on the report.

See example on https://www.youtube.com/watch?v=sYLN96l8kqo
Post #1555422
Posted Friday, March 28, 2014 8:03 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 1:11 PM
Points: 612, Visits: 2,145
I've done tabbed reports with the cells of the table containing images of the "tabs". The images used the "jump to report" to simulate the tab switching. I had two tabs images each a separate colour, the could would change as you changed tabs (your basic active/inactive tabs.

I even had the reports pass the parameters back and forth. It was cool, but a total Pain in the *** to maintain. It was just something I had wanted to do not a requirement, so I eventually ditched it. I was going to to write it up and post it here, but I never had the time to do it properly. If you want I can have a look to see if I can find it (just no comments about the bad writing ;) )...
Post #1555926
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse