Category Archives: Uncategorized

SSRS export to Excel converts DateTime Column to Text Column

Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was formatted using the FORMAT function as “MM-dd-yyyy HH:mm:ss” (24 hrs format). However when this report was exported to Excel, this … Continue reading

Posted in Uncategorized | Leave a 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

Review of my blog posts in 2011

The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 26,000 times in 2011. If it were a … Continue reading

Posted in Uncategorized | Leave a comment

Data Driven Subscription failed with timeout error

One fine day, one of our data driven subscription which was running fine, failed with timeout error. library!WindowsService_118!eb4!12/20/2011-07:30:01:: i INFO: Handling data-driven subscription 1b850434-fe69-47e5-a227-219d1b2e040c to report /External Reports/Report1, owner: domain\user, delivery extension: Report Server Email. library!WindowsService_118!1288!12/20/2011-07:30:01:: i INFO: Initializing EnableExecutionLogging … Continue reading

Posted in Uncategorized | Leave a comment

Send SSRS subscription files to (Secured FTP) SFTP

We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the customer requested us to upload the reports in secured FTP instead of sending it thru mail. We had to look … Continue reading

Posted in Uncategorized | 1 Comment

SSRS Error: Cannot read the next data row for dataset Dataset1

This error , Cannot read the next data row for dataset Dataset1, is thrown for many reasons, at leastĀ I have seen it on two occasions. First, when the dataset timed out (underlying connection closed) and the another one is when … Continue reading

Posted in Uncategorized | Leave a comment

SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported

Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it. It had lot of datasets and the datasets contains huge T-SQL commands. When I tried to modify one dataset I … Continue reading

Posted in Uncategorized | 2 Comments