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...
2011-07-14
3,837 reads
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...
2011-06-24
1,481 reads
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...
2011-06-15
4,485 reads
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...
2011-05-26
5,300 reads
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...
2011-04-29
20,038 reads
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....
2011-04-12
2,870 reads
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....
2011-03-15
2,646 reads
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...
2011-02-21
644 reads
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....
2011-01-07
2,809 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Smile and Wave Boys
Comments posted to this topic are about the item Smile and Wave Boys
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers