Everybody who’s online these days uses tabs (even Internet Explorer users!). Yet SQL Server Reporting Services doesn’t natively support tabs for its reports. It does, however, support all the building blocks necessary to create tabs yourself. In this post, we’ll post show you one way to do it.
So when would you want to use tabs? Let’s say you have multiple companies within your organization. Perhaps you’d like the first tab to show consolidated results for the company and then subsequent tabs to show results for each subsequent company. Or perhaps you’d like different tabs for each line of business or sales person?
In our example, we use data from Lawson GL where company is a legal entity and Acct Unit is a profit center.
Let’s use a simple report created by the SSRS report wizard to illustrate: