December 8, 2008 at 6:35 am
HI,
We have set subscriptions (email) for the report which generates invoices for the dealers in the database. We do the invoicing once in a week. I want to suppress the dealers which has no invoices that week and see that a blank email will not be sent to that dealer who does not do any business that week. i.e. the emails should be sent to the dealers who does business. We are not using data driven subcriptions but. Can any one help?
December 8, 2008 at 6:40 am
I would probably create a view by joining dealer list and last weeks transactions (use distinct or subquery to avoid duplicate entries) and use this view as a source for data driven subscription
December 8, 2008 at 8:23 am
If you are not using data driven subscription then it would be bit difficult to handle. U need to use data driven subscription which u can set up so that it will not set up email if you dont have any record.
December 8, 2008 at 12:40 pm
dva2007 (12/8/2008)
If you are not using data driven subscription then it would be bit difficult to handle. U need to use data driven subscription which u can set up so that it will not set up email if you dont have any record.
And Data Driven subscription is only available in the SQL 2005/2008 Enterprise edition
I would filter out (either in SSRS or in Dataset) ones that have no invoice (say InvoiceCount=0)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply