Monthly Archives: February 2012

Converting SQL SERVER DateTime? Test it thoroughly….

Today one of my user complained that a report was missing one particular ticket from the output. The report in question is very simple, it accepts start date & end date and filters on the ticket creation date time column … Continue reading

Posted in T-SQL | 10 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

SSRS 2008 Error – The report definition is not valid

Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and everything looked good. However when I tried to upload the file in the Report Manager got a strange error The … Continue reading

Posted in SSMS | 1 Comment

Dundas Dashboard – My observations

Dundas Data Visualization¬†Inc, is well-known to SSRS developers. Microsoft had earlier acquired their SSRS controls (Charts, Gauges & Map) and integrated them into SSRS 2008 & R2. These controls adds rich visualization to SSRS reports. However one of the feature … Continue reading

Posted in Uncategorized | 4 Comments