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
This blog has been sorely neglected since I got caught up with our school's switch between MIS providers. So, in an effort to rescue it from the hordes of one-post blogs on the web, here, for no good reason at all, are some of the text editors I have known:
Notepad
Yes, we all have to start somewhere…
Wordpad
Has a better time with Linux/Unix new line breaks than Notepad, but it's a rich text editor >_<
Pico
Just about the simplest text editor I have ever used. I used it
Long term users of Excel VBA will be familiar with slow processing of page set up if code like the following is used:
With ActiveWorksheet.PageSetup
.CenterHeader = "Title of the Worksheet"
.LeftFooter = "Today's Date"
.RightFooter = "Page &P of &N"
.PrintArea = "$A$1:$H$28"
End With
The problem with the code is that, despite the use of the With statement, each line requires a call to the printer driver, rather than the whole statement being sent once. The most commo
