SEO

#1 (**permalink**) 04-10-2008, 12:10 AM

I'm using Report Builder v9.1D. Once a week I run a report which
exports data to a CSV file which is used by some other software. Is
there any way I can automate this process? I'm thinking using Windows
scheduled tasks to run a batch file containing the reports name and
the name of the file I want it exported to. If so what would the
command line parameters look like? Currently I'm opening the report
in RB and exporting it manually. I've downloaded the RB manual but
there doesn't seem to be any indication in there on how to do it, or
have I missed something?

Thanks

#2 (**permalink**) 04-10-2008, 12:10 AM

On 16 Oct, 12:09, Steve <stephenal...@hotmail.com> wrote:
> I'm using Report Builder v9.1D. Once a week I run a report which
> exports data to a CSV file which is used by some other software. Is
> there any way I can automate this process? I'm thinking using Windows
> scheduled tasks to run a batch file containing the reports name and
> the name of the file I want it exported to. If so what would the
> command line parameters look like? Currently I'm opening the report
> in RB and exporting it manually. I've downloaded the RB manual but
> there doesn't seem to be any indication in there on how to do it, or
> have I missed something?
>
> Thanks

Hi Steve
Have a look in help for aderb\_printrb
This is a built-in progress procedure that you can pass loads of
parameters to
such as the library name, report name, destination etc etc

You can call this from procedure editor with a query something like

RUN aderb\_printrb
(param1,
param2,
...........).

if you need help on how to create a scheduled task to run a procedure
like this then let me know
and I will forward details

Roy
roy.casey@gmail.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Automating Report Builder