Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
michaelb
Yak Posting Veteran
69 Posts |
 Posted - 2008-09-14 : 19:50:04
|
| Hi,I am setting up schedules for a report which has a parameter passed to it, but if the report contains no data, it still emails a blank PDF. Is there any way to stop it sending anything if the report is blank?Thanks,Michael |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-09-15 : 19:42:01
|
| As per my knowledge there is no such option at presenthey |
 |
|
|
hanavan
Starting Member
25 Posts |
Posted - 2008-09-17 : 16:26:49
|
If you are using the enterprise version, you can use a select statement.Here you will find some solutions:quote:
http://blogs.msdn.com/bimusings/archive/2005/07/29/445080.aspx
In my solution I couldn't use the enterprise edition, and what I did was create a stored procedure that will callthe reports parameter (customer) from a table which contains only the customerid if they have data in the report.So to fill that table:select yourparameterfrom (select yourparameter from customerdata) a inner join (select yourparameter from reportdata) b inner join on a.yourparameter = b.yourparameter |
|
|
|
|
|
|
Schedule for report with no data