September 19, 2008 at 10:42 am
I have a number of reports that I'd like to automate running within a script utility. I've seen some some sites discussing the RS.EXE tool, but noticed that I'd have to create a VB program to utilize it. I'm looking for any GUI tool that will allow me to select a set of reports, order them, and specify parameters and output needs (e.g. text file, excel, output to printer).
Does anything exist or do I need to have a programmer build a wrapper program to run these?
September 19, 2008 at 11:25 am
if you don't wish to use rs.exe have you taken a look at subscriptions? Basically, you can set up a report to be generated and sent to you via email or the results of the report can be placed on a network share.
You can set it up on a schedule and if you're creative with how you default your parameters for the reports you should be able to just run them with the defaults i.e. if you want a weekly sales report, have your defaults set to programatically be last week's dates etc.
Is that the functionality you're looking for?
September 19, 2008 at 11:44 am
thank you, but no. Below is a scenario I'd like to accomplish as an example:
Run report1.rdl (this would output an SQL file)
Run report2.rdl (this would utilize the file that was created above and output a text file)
Run report3.rdl (this would create an Excel file that needs the other 2 reports to run first)
My thinking is to batch these into some sort of 'autoexec.bat' type of file, but in a GUI Scripting tool.
Make more sense?
September 19, 2008 at 12:04 pm
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply