SSRS stop report generation on 0 records

Posted by AmiT on Stack Overflow See other posts from Stack Overflow or by AmiT
Published on 2010-03-18T12:48:33Z Indexed on 2010/03/18 12:51 UTC
Read the original article Hit count: 409

Filed under:

ssrs-2008

|

datadriven

Hi All,

I am creating a report from ssrs, and storing at local shared folder(MyReports) in excel format using data-driven subscription.

It generates a report on scheduled time. But, I don't wanna create a report with zero records.

How to stop SSRS to generate a report if no. of records is zero.

Pls F1 me ... !

Related posts about ssrs-2008

How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More
iPhone - Open excel from SSRS 2008

as seen on Server Fault - Search for 'Server Fault'
We're currently having a problem with our 2008 SSRS server sending excel reports to users with iPhones. They get the email with no problems, but when the XLS file is opened on the phone, it returns an error of: Invalid format. Everyone else can open the report with no problems (email/blackberry) The… >>> More
SSRS 2008 Report Manager Error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just installed SQL Server 2008 including Reporting Services on Windows Server 2003. I'm having a problem though accessing the Report Manager. When the Reporting Service is first started I can access it fine but after maybe an hour when I try and access it I get an error saying: Unable to… >>> More
How to disable SSRS 2008 manager

as seen on Stack Overflow - Search for 'Stack Overflow'
Can you disable the SSRS 2008 manager (http://mydomain/reports), while leaving the report server working (http://mydomain/reportserver)? EDIT: Got it! This is how you do it in SSRS: Turn off Report Manager >>> More
Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More

Developer IT

SSRS stop report generation on 0 records - Developer IT

SSRS stop report generation on 0 records

ssrs-2008

datadriven

Related posts about ssrs-2008

How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

iPhone - Open excel from SSRS 2008

SSRS 2008 Report Manager Error

How to disable SSRS 2008 manager

Force SSRS 2008 to use SSRS 2005 CSV rendering

Related posts about datadriven

How to RowTest with MSTest ?

SSRS stop report generation on 0 records

CodePlex Daily Summary for Wednesday, March 28, 2012

Categories cloud