Monday, January 3, 2011

Difference Between ReportServer Database Vs ReportServerTempDB


1. It Stores information about the report schema, report property, data sources, parameters, stores the folder hierarchy, report Execution log.
2. It always exists until changes on the RDL Schema
3. It helps to access the structure.
4. Data always exists during SSRS service restarts


1. It stores only the cached copy of the report data.
2. It expires based Expiry settings.
3. It helps to improve the performance of report execution as it is loading data from cache.
4. Services restarts will clear the Temp Data

Saturday, October 31, 2009

For Formatting Numbers and Dates

To format the numbers and date in SSRS use the following piece of code

For Numbers:-
This will also round up the number upto 2 digits.

For Dates:-
=Format(Cdate(Date field),"dd/MM/yyyy")
You can specify any date format For eg:US/UK in the string.The MM in this string has to be in Capital Letters otherwise the code wont work.

Wednesday, October 14, 2009

Reduce spaces between subreports and subreport alignment

While developing a master report I came across a problem.There was a lot of space between two subreports in the master report if there was no data for that particular report.To avoid this do the following steps:-
  1. Put the visibility condition =iif (countrows()=0,true,false) on all the subreports under visibility in property tab.This condition is for hiding the report if there is no data for that report.
  2. Keep page header and footer in master report only.
  3. Minimize the space between the cells of the table.
This should help in reducing the space between the subreports.

Thursday, October 8, 2009

Changing Alternate Colors of the Row in the table

For Changing alternate colors of the rows in the table add the following code to your background color expression of your row.
=iif(RowNumber("tablename") Mod 2==0,"Blue","Gray")