Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Need scheduled report to create a Word document for each record, without using Data Driven Subscription Expand / Collapse
Posted Friday, August 8, 2014 10:49 PM


Group: General Forum Members
Last Login: Friday, November 13, 2015 11:19 AM
Points: 10, Visits: 141
My company wants to start automating some of our customer communications.

As a first step, I need to use a daily subscription that will create a form letter for each client based on sales for that day. I have created the report and am able to get a single Word document with one page per sale record. What I need to do though is create individual files instead of the single file.

I have done a bit of research and everything is pointing me to using Data Driven subscriptions. That would be great, except for the cost of Enterprise edition, which is more that we're willing to spend.

Any advise or experience with this would be greatly appreciated.
Post #1601366
Posted Saturday, August 9, 2014 12:53 AM


Group: General Forum Members
Last Login: Yesterday @ 9:59 PM
Points: 2,134, Visits: 12,262
Jason Selburg wrote something that does that:
Post #1601372
Posted Saturday, August 9, 2014 5:36 AM



Group: General Forum Members
Last Login: Yesterday @ 4:50 PM
Points: 23,515, Visits: 37,731
pietlinden (8/9/2014)
Jason Selburg wrote something that does that:

Let's make this easier for others:

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1601390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse