Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, August 8, 2014 10:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 8, 2014 1:18 PM
Points: 10, Visits: 131
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:31 PM
Points: 809, Visits: 5,137
Jason Selburg wrote something that does that:
http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html
Post #1601372
Posted Saturday, August 9, 2014 5:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 20,696, Visits: 32,330
pietlinden (8/9/2014)
Jason Selburg wrote something that does that:
http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html


Let's make this easier for others:

http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html



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