March 9, 2009 at 2:33 pm
A newbie question:
I have several reports that were used to build a macro in MS Access 2007 that I am trying to recreate in my upsized database version in SQL Server 2005 Express. I've been able to make all the individual reports, but what can I do to run them all at once and have them written to, say a Word doc, like they do from the Macro in Access? Any and all help is appreciated.
~Al
March 10, 2009 at 6:01 am
Assuming you are using SSRS to do this, you can create a Master report that contains each of the other reports as a sub report and then run the master report and export to Word/pdf. If you want this to be scheduled then you can use subscriptions to schedule the master report.
Also, if none of the reports will ever be run on its own, you could just have multiple datasets on a single report that each populate their own controls.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2009 at 6:28 am
Thanks for your help, I figured it out. Its a lot easier than it appears at first. 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply