Bunch's Blog

One day I'll have a catchy subtitle, one day
posts - 87 , comments - 120 , trackbacks - 0

SSRS

There are 4 entries for the tag SSRS
SSRS – Passing Nulls and Blanks
Passing nulls and blank values to SSRS via an URL requires a very little bit of work. For a null value you first need to call up the Report Properties (in the Layout tab select the entire report and click on Properties on the right) in SSRS and click on the button in ReportParameters. Once the Report Parameters window has opened you can set the parameter to allow nulls by checking the ‘Allow null value’ box. Then from the application that runs the report use Parameter:isNull=True in your URL if you ......

Posted On Thursday, July 16, 2009 4:59 AM | Comments (0) |

Conditional SSRS Formatting
Expressions are something I have found to be very handy when using SSRS. A report I needed to setup had to list when a user had last visited a site. Since they needed to make a visit every three years the report listed the last visit date and the date three years out (this was all done is the stored procedure). Sometimes folks may get behind and I wanted to highlight the sites that were past due. The report needed to be able to be sorted by a date, town or county so I could not just list the sites ......

Posted On Thursday, December 4, 2008 1:49 PM | Comments (0) |

Alternating Table Row Colors in SSRS (The Easy Way!)
A lot of the applications I work with utilize SQL Server Reporting Services (SSRS) for reporting. I was shown a way by the previous owner of an app to make a table show up in green bar (alternating colors). I added a function to the XML code for the .rdl to determine if the row is odd or even. Then I would add a <BackgroundColor> entry to each item in the table (again in the XML). It never took too long but was a bit of a pain to setup. I recently found a MUCH easier way. All you have to do ......

Posted On Friday, March 7, 2008 12:31 PM | Comments (6) |

Data into a SSRS Header
This was an issue for me a while back. I was making a report using SQL Server Reporting Services (SSRS) in SQL 2005 and I needed to put data into a textbox in the header. After searching the internet fairly thoroughly I found many posts and articles that pointed me in the right direction but they just didn’t work for me. The solution I used was to place a textbox on the body of the report and make it hidden. In the textbox I would add in the data I needed (i.e. =Fields or =Countrows). I would then ......

Posted On Wednesday, March 5, 2008 10:01 AM | Comments (19) |

Powered by: