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

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 around for options to achieve this as SSRS does not… Read more

0 comments, 1,319 reads

Posted in What I Learnt @ Work on 14 July 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, 678 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, 973 reads

Posted in What I Learnt @ Work on 15 June 2011

SSRS Error: Unable to connect to remote server error

One fine day when I tried to connect to one of my staging report server I got the

“Unable to connect to remote server error”

I checked the report services & sql server (to which SSRS is mapped) services and both of them were running. I tried to connect to… Read more

0 comments, 1,356 reads

Posted in What I Learnt @ Work on 26 May 2011

SSRS Error: A connection to the database is required for all requests and processing

This error

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

occurs when the SQL SERVER instance, to which SSRS is pointed to, is down or a very silly mistake, the SSRS is not… Read more

1 comments, 5,536 reads

Posted in What I Learnt @ Work on 29 April 2011

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 got an error

Bit surprised because the report was working… Read more

0 comments, 614 reads

Posted in What I Learnt @ Work on 12 April 2011

SSRS: Empty dataset and Tablix Control

The behaviour of the tablix is that whenever the associated dataset is empty, it will not show any detail row. But there are requirements wherein you need to show 0 when the data set is empty. Refer the below screenshot

The best way to achieve this is to prepare 1… Read more

0 comments, 693 reads

Posted in What I Learnt @ Work on 15 March 2011

Data Driven Subscriptions for SSRS Report with Parameters from multiple data sources

Just to give the context of the problem I faced recently.. our application is very data intensive, GB of data received from the customer every day and hundreds of customers. Hence we have kept each customer data in individual database. So the reports, based on the customer selection, has to… Read more

0 comments, 392 reads

Posted in What I Learnt @ Work on 21 February 2011

Troubleshooting SSRS subscription failures

Of-late one of our SSRS 2005 report subscriptions started to fail regularly with the error message

Failure sending mail: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

That report was pretty simple and if run on demand, it used to… Read more

0 comments, 518 reads

Posted in What I Learnt @ Work on 7 January 2011

Newer posts