i have written a report that i can schedule to be emailed on a monthly basis. I can also manually export the report to Excel. Question is... can i export the report to Excel on a scheduled basis?
I have logged a call with supoprt who say there is no functionality to do it, has anyone developed a script, or some other method, that does it?? Cheers
You should be able to build a dts package or use the export wizard on your SQL server to do that. If you are not sure how to do this, you may want to tap one of your DBA's on the shoulder...