Geek Answers Handbook

SQL Server Reporting Services 2005 - How to handle blank reports

I was wondering if you can not attach the Excel sheet, if it is empty, and perhaps write another comment in the letter if it is empty.

When I go to report delivery options, there is no such configuration.

Change . I am running SQL Server 2005 Reporting Services.

Some possible workarounds are as follows:

MSDN: Reporting Services Extensions

NoRows and NoRowsMessage Properties

I have to learn these things.

+5
source share
4 answers

, - , , . , RS.

+1

, , . "NoRows" , , . , , excel, .

+1

- ...

, - . :

  • .

  • (.. , ) , . , .

  • SQL Management Studio, SQL ( : EXEC ReportServer.dbo.AddEvent @EventType = 'TimedSubscription', @EventData = '1c2d9808-aa22-4597-6191-f152d7503fff')

  • SQL - :

IF EXISTS ( ...)

EXEC ReportServer.dbo.AddEvent @EventType =... ..

+1

, , , :

SELECT * FROM REPORT_SUBSCRIBERS WHERE EXISTS (SELECT QUERY_FROM_YOUR_REPORT)

, .
, .

" " "".
, , , :

SELECT 'person1@domain.com; person2@domain.com' AS RECIPIENTS,
CASE WHEN EXISTS (REPORT_QUERY) THEN 'TRUE' ELSE 'FALSE' END AS INCLUDE_REPORT,
CASE WHEN EXISTS (REPORT_QUERY) THEN 'The report is attached' ELSE 'There was no data in this report' END AS COMMENT

.

0

More articles:


All Articles