February 7, 2009 at 4:02 pm
Hi,
We are looking for an easy way to automate population excel reports from a SQL database.
Here are some details:
1- Reports are used to collect server and DB level info to be emailed for verification to individual server and application owners
2- All data is stored and available in a central SQL database
3- The excel spreadsheet with the required fields and formatting has already been created
4- Task is to populate the excell cells with corresponding data from the SQL DB,generate excel report.
We need to generate reports for atleast 100 servers.
What is the effecient way to automate this.
Not very knowledgeable in vb scripts,excel macros etc
Looking to do this mainly using SSIS or DTS. or if there is any good freeware or shareware ?
Any inputs are appreciated!
TIA
February 7, 2009 at 4:19 pm
Two quick ways:
1. Use Excel query and save the spreadsheet with the query contained in it (along with the data source). Have it refresh on open. Lots of help in Excel to accomplish this.
2. Use reporting services, RS. The report generator is simple and you can distribute the reports pretty easy from there as well and they can be exported via excel. You can also send the reports from RS as well.
Since you have the information compiled you are most of the way done.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 7, 2009 at 4:35 pm
Thanks David!
excel query sounds like a feasible solution and something we can defn look into.
If we used excel query, we would have to do it for each spreadsheet correct?
We need to generate 100 such spreadsheets atleast, for each of the 100 servers.
If we could automate it using a package or any mehod, to generate all of them in 1 go, that would be great
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply