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

Posted in SSRS | Tagged | Leave a comment

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 | 4 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

Posted in SSRS | Tagged | 2 Comments