Re: How can you automate SQR reports to run say at Month-End Using ma ybe the AT Windows command and how do you pass parameters to the report.

[Franck Masson <franck.masson@BRIO.COM>]

create a bat file
sqrw reportname.sqr user/password@tnsname -XCB -Fc:\temp -printer:ps
parameter1 parameter2 @file.dat
print c:\tmp\reportname.lis
del c:\tmp\reportname.lis


In this example, parameter1 and parameter2 are passed to SQR, followed
by the file file.dat. Each line in file.dat has an additional argument.


Blodgett, Greg wrote:
>
> Visual SQRIBE 5.0 SQR Server 4.0.3
> Windows NT 4.0 Service Pack 5
> Oracle DB 7.3.2.2
> PSDI Maximo 4.02
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper at Premcor. for the presence of computer viruses.
>         Please contact administrator@premcorinc.com for information or
> assistance.
>
> www.mimesweeper.com
> **********************************************************************
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard