Re: Calling an SQR from the WEB

["Wanko, Christopher G, CFCTRCFFIN" <apollo@ATT.COM>]

> We purchased PeopleSoft and with it SQR3.  We have an Oracle
> database version 7.3.  We have set up WEB pages for users to input
usernames,
> passwords, and parameters in order to get reports from the database (these

> pages were set up to read Sybase databases before we had PeopleSoft).  Can
we use
> our WEB front concept to get access to the Oracle database and provide
> parameters to an SQR report?
>
> Our WEB person says that the SQR would have to run from a
> command line.  We are running on an WindowsNT server.

Okay, key question: do the reports run from the Web/ application server or
the client machine?
If it runs off the application server, the Web guy is right; you need to
pass those parameters captured by your Web interface to the SQR program.
This is not very hard at all (it's trivial, in fact).

If it runs off the client machine, then you would simply associate the
report extension with SQRWT.EXE, and code the default parameters in the
client's WIN.INI file.  You could even code the username/ password in the
WIN.INI, so the mere act of clicking on a report would spawn a client-side
instance of it, running locally, with all the parameters passed to it by
default.

-Chris