Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2011

SSRS 2005 Data Driven Subscription and Temporary table

Few days back I was setting up data driven subscription for a SSRS 2005 report. The command / query which populates the parameters was bit complex. I normally create the script in the SSMS and once it works just used to copy paster it in the data driven subscription. This… Read more

0 comments, 601 reads

Posted in What I Learnt @ Work on 24 June 2011

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 the datetime field was casted as character. Here… Read more

0 comments, 855 reads

Posted in What I Learnt @ Work on 15 June 2011