Tabbed Reports in SSRS

  • 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.

  • 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.

  • 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

  • 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

  • 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.

  • Does this port to Excel?

  • 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?

  • 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

  • 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

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

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

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