In Part One I gave an overview of why and how you might implement tab strips in SSRS reports using tables in your database to manage the strips and formatting. In Part Two I gave you the necessary SQL. There is now just a little bit more hard work to do in this final step to get the required SSRS report template set up in BIDS/Visual Studio. We will create a single report to test the effect of what we've set up and then turn this into a template for all future work. At the end of Part One I made
In Part One I described one approach to creating tab strips in SSRS. In this part I will go over the necessary table design in the database. Nothing hinges on the fact that I use SQL Server, so the following T-SQL code should be adaptable for other DBMSs.
We need two tables and one view to set up our tab strips. I've given some code towards the end that will populate these tables with some sample data that we will use in Part Three.
Tab Strips Table
A tab strip, in this context, is a gr
Reports created in SSRS don't have an out-of-the-box tab strip control, so report designers have to find ways to work around this. Here is one possible workaround.[1] Is it the best or even an advisable approach? I withhold judgement on that, but I make a couple of comments on this right at the end, along with suggestions as to how to build upon this technique to create other effects.
In Part One of this blog post, I will describe the motivation for coming up with this solution and give an ov
