-
Recent Posts
Archives
- July 2013
- November 2012
- May 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
Categories
Meta
Category Archives: SSRS
Mirrored Database as SSRS Data Source
Recently one of our report started to fail with error like Unable to Connect to Database error. Then only we came to know that the said database is in a mirror setup. In the mirrored environment, we have to always … Continue reading
SSRS: FORMAT option for milliseconds
Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a change in the internal website which required us to send the a particular Date as a parameter. The page was … Continue reading
Posted in SSRS
5 Comments
Passing BIGINT data to SSRS Sub Report
Few days back one of my team mate complained to me that one particular sub report is failing randomly with Error: Subreport could not be shown The particular sub report was called from another report’s tablix control column. It accepts … Continue reading
Posted in SQL SERVER, SSRS
1 Comment
Silly issues with SSRS
Recently I was troubleshooting a report issue where in one of the column was empty in the report. I started by checking the report body to ensure that the corresponding column was called appropriately, then looked into the dataset fields to … Continue reading
Posted in SSRS
3 Comments
Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two date parameters , a data set displayed in a tablix, NoRowsMessage was enabled on the tablix to display a message … Continue reading
Posted in SSRS
4 Comments
This field is missing from the returned result set from the data source.
This warning The dataset ‘dataset1’ contains a definition for the Field ‘column1’. This field is missing from the returned result set from the data source. is very common error and reason behind it is really simple. The report object is … Continue reading
Posted in SSRS
3 Comments
SSRS 2008 R2: Object reference not set to an instance of an object
We have a report in SSRS 2008 which calls multiple sub-reports. One of the sub-reports contains a data region (tablix) in which one of the column is populated by another sub-report i.e. the sub-report will render for each row of the … Continue reading
SSRS 2005 Error: The Item “/” cannot be found
Couple of months back, one of our SSRS 2005 staging server became inaccessible. When we opened the report manager, it had thrown a message The item “/” cannot be found After repeated attempts, the report server opened up. But when … Continue reading
SSRS 2008 R2: Report Server crashing intermittently
One of our report server which is SSRS 2008 R2 (10.50.1720.0) started to crash intermittently. The IE failed with Internet Explorer cannot display the webpage. The report server log files didn’t contain any other information. After few mins (~2 mins), … Continue reading
Impact of manipulating SSRS parameter inside dataset
Recently I had to convert a report’s dataset, which was using Stored Procedure, into inline T-SQL commands. The dataset had 4 parameters , which it was passing to a stored procedure. I had to add two more parameters and since this … Continue reading
Posted in SSRS
Leave a comment