SSRS: Column Duplication (Fixed Columns) on Printouts

This blog post covers implementing something like the "fixed columns" in excel which allow you to have a column (or columns) repeat on multiple pages. This only happens whey you view the report in a non-interactive way (i.e. not when viewing online).This  blog post was put together using SQL Server 2008R2 and Report Builder 3 but it might be applicable to other versions.Open your report in Report Builder (I'm using 3.0) and add in your...

Read More

SSRS: Scheduling Reports Using SQL Server Reporting Services 2008

This blog post gives detailed step-by-step instructions on how to schedule reports to run using SQL Server Reporting Services 2008 Standard Edition. Additional features are available in the Enterprise Edition and these will be covered separately.PrerequisitesThe example Reporting Services project used throughout this guide (put together using Bussiness Intelliegnece Development Studio) is available for download here. You might want to download and...

Read More

SSRS: Working With Multiple Value Parameters

It is generally a good idea when writing reports to provide some space on the report to display the parameter values the user is using to run the report. It makes it a lot easier to deal with helpdesk requests along the lines of "Why's it doing this?" accompanied by a screen shot or a saved report - if you include the parameter values in the report then it should be fairly easy to duplicate it.The problem comes when you're dealing with Multiple Value Parameters. For example if I look at the General Ledger Accounts we have setup in our ERP System...

Read More

SSRS: Commonly Used Date/Time Functions

The list below is a few simple functions which I've come across for generating various dates based on the current date/time (using the Now() function).Hopefully they'll prove useful and as new ones come up I'll update this post;Last day of the current year,=DateSerial(Year(Now()), 12, 31)Last day of previous month=DateAdd(""d"", -1, DateSerial(Year(Now()), Month(Now()), 1))First date of previous month=DateAdd(""m"", -1, DateSerial(Year(Now()), Month(Now()),...

Read More

SSRS: Common Issues with #Error and IIF

Is there anything more frustrating then seeing this non-error message and wondering what of massively complicated function you've just entered is causing the problem (let's not forget that the Expression editor in Report Builder 3 doesn't allow you to do multi-line statements - just to make it easier!). Drives me wild.Having worked with other people to debug functions the one thing that seemed to really help people was giving them a better understanding of how IIF worked (oddly IIF was the cause of *most* of the problems!).The IIF function...

Read More