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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-20 : 08:33:30
|
| Sakheb writes "Server software:Windows NT 4.0SQL Server 2000 (no service packs)Is there a way to have the DTS create formatted Excel reports without writing a script to format the report. Because, writing a script requires that Excel be installed on the server. I know how to create regular simple Excel reports, but don't know how to format the report." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-20 : 09:00:53
|
| No. To be automated there must be some kind of scripting.Someone else posted a similar question recently:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15926It seems that he basically pasted the VB code that did the formatting operations into an ActiveX script task. It will need some modification to work in VBScript, but it's possible.The easiest way to generate the script is to use Record Macro while you perform the formatting. This will generate the VB code that does all the work. If you do it in small steps and examine the code, you'll be surprised how quickly you'll pick it up...it's really not that hard. Keep adding smaller steps to the process until the entire job is done. If you're not a heavy VB programmer, see if anyone around can help you. |
 |
|
|
|
|
|
Formatted Excel reports as output of DTS