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

["Blodgett, Greg" <Greg.Blodgett@PREMCORINC.COM>]

I hate to ask but...
What if you wanted the parameters to come from a file or another database
table to make it to where the end-user can change say a date in one location
and not have to touch the batch file?

Greg

-----Original Message-----
From: Franck Masson [mailto:franck.masson@BRIO.COM]
Sent: Thursday, September 14, 2000 5:06 PM
To: SQR-USERS@list.iex.net
Subject: 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.


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
> **********************************************************************
**********************************************************************
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
**********************************************************************