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 |
|
noquintic
Starting Member
10 Posts |
 Posted - 2008-11-25 : 16:01:17
|
| I have 6 reports filtered by about 325 customerIDs that need to be sent to 125 contacts at various times. I think that SSRS data driven subscriptions are the solution but am not sure of the best strategy. I have a table containing 'custonerID','Contact First Name','Contact Last Name','Contact Email','CC Email','Report Name','Frequency'1. How should I value the Frequency column; some contacts want their reports every Monday while some want their reports on the 15th and last day of the month. I am not sure how to program the Frequency into the subscription to be sure I generate and send the report on the correct day.2. The data source for the reports are stored procedures requiring a customerID as a parameter. How can I pass in a string containing multiple customerIDs like @customer in ('1234','2345','3456')? Thanks, |
|
|
|
|
|
subscription strategy