Tag | SSRS Posts

As I have been working on SQL Server Reporting Services reports the last couple of weeks I ran into a scenario where I needed to present a parent-child data layout. It is rare that I have seen a report that was a simple tabular or matrix format and this report continued that trend. I found that the processes for developing complex SSRS reports aren’t as commonly described as I would have thought. Below I will layout the process that I went through to create a solution. I started with a List control ...
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 ...
Recently I am working little bit more on SSRS. Last week, we migrated from SSRS 2005 to SSRS 2008. The migration was smooth except few gotchas in Line charts. The way we handle empty points (null values) is improved. for more information, look at: http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... ------- Coming to some tips regarding formatting date time, text etc. 1) How do you persist the date format when you export the report to Excel? ...
While http://en.wikipedia.org/wik... outlines some limitations of SQL Server Express, there are some specifics that are missing for Reporting Services. One such example is what I discovered today while at a client that uses DB2 for its RDBMS. SSRS that comes with the Express Edition only supports creating reports against the local SQL Server data source. Be aware of this when considering SQL Server Express in your system design. http://www.microsoft.com/te... ...
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 ...
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 ...
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 ...
I have spent quite some time latetly creating two SQL Server Reporting Services reports that read data from a Web services. Given that I had to solve a couple of non-trivial issues and that I did not find much documentation, I have written a few tips in this article. Tip 1: How to specify the value of the WS complex type parameter? Tip 3: How to pass another dataset as XML to the Web service? Tip 2: How to read XML from a database without truncation of the results? Technorati tags: SQL Server, SSRS, ...