Tabbed Reports in SSRS

Question

Tabbed Reports in SSRS

sarran.achari

SSCrazy

Points: 2226
More actions
December 22, 2008 at 6:21 am

#197492

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.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

mRainey Right there with Babe Points: 796 More actions · Answer 1

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.

sarran.achari SSCrazy Points: 2226 More actions · Answer 2

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

Mike Mattix SSC Journeyman Points: 96 More actions · Answer 3

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

mRainey Right there with Babe Points: 796 More actions · Answer 4

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.

WFBETC Old Hand Points: 325 More actions · Answer 5

WFBETC

Old Hand

Points: 325

February 2, 2009 at 2:54 pm

#936764

Does this port to Excel?

Amit Raut SSCrazy Points: 2613 More actions · Answer 6

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?

mjbriggs03 SSC Eights! Points: 958 More actions · Answer 7

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

Gunther Van Loco SSC Veteran Points: 254 More actions · Answer 8

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

Steven.Howes SSCertifiable Points: 6230 More actions · Answer 9

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 😉 )...