Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Tabbed Reports in SSRS


Tabbed Reports in SSRS

Author
Message
sarran.achari
sarran.achari
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1475 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.
mRainey
mRainey
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 117
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
sarran.achari
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1475 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
Mike Mattix
Mike Mattix
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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
mRainey
mRainey
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 117
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
WFBETC
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 22
Does this port to Excel?
Amit Raut
Amit Raut
SSC Eights!
SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)SSC Eights! (827 reputation)

Group: General Forum Members
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?
mjbriggs03
mjbriggs03
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 102
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
Gunther Van Loco
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 95
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
Steven.Howes
SSChasing Mays
SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)

Group: General Forum Members
Points: 652 Visits: 2328
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 Wink )...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search