View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
Creating a tabbed report in SSRS will be same as creating good UI report using HTML, JQuery etc.
Even with countless properties of SSRS there is no direct way to create a tabbed report architecture containing 3-4 reports based on different tabs. I just found an example while browsing images. Requirement for such type of report are:
I tried to build a report combining different reports as desired using SSRS.
If you look for this problem on WWW, you might get only solution as using TOGGLE properties of TextBoxes (used as Tab in report) and based on Expand and Collapse it will show and hide different reports for different Tabs.
But believe me it doesn’t look good (added Expand/ Collapse symbol on tab and No way to highlight Active tab), and at least didn’t solve my problem (Show and Hide didn’t work properly).
I used Action property to solve my problem and really it worked well, as per expectations.
Steps followed to create Tabbed SSRS report:
That’s it, these are few simple steps to create tabbed report in SSRS and hence you can see flexible and cool running report with dynamic tabs.
Note: If you need zipped code solution please mention your e-mail address in comments.