Re: How to run SQR from web ?

[George Jansen <GJANSEN@AFLCIO.ORG>]

FYI, it is fairly straightforward to set up a Perl module to run SQR,
should it be that you're running Apache.

>>> franck.masson@BRIO.COM 07/08/02 06:00AM >>>
it is quit easy

you have to setup a CGI/ASP/servlet that will launch sqr and return
the
output execution.
then after you just have to design an html page ( html form) to collect
the
parameters and send it to your cgi/asp/servlet.

there is a chapter/documentation with the 2 books that is provided with
SQR
server

Franck,
-----Original Message-----
From: Esther Chin [mailto:esther_chin@CONGRUENT.COM.SG]
Sent: lundi 8 juillet 2002 11:16
To: SQR-USERS@list.iex.net
Subject: Re: How to run SQR from web ?


Hi jyoti,

Thanks for your explaination. But what i mentioned is not in
peoplesoft. My
concern is how to run the sqr report from the normal web site? Let say,
is
it possible to use html or javascript to call up the sqr program and
run it
from the web? if yes, may i know how to do that ? please advise.

Best regards,
Esther

----- Original Message -----
From: "Nandi, Jyotirmoy (Cognizant)" <NJyotirm@CAL.COGNIZANT.COM>
To: <SQR-USERS@list.iex.net>
Sent: Monday, July 08, 2002 4:58 PM
Subject: Re: How to run SQR from web ?


> hi esther,
>
> 1. first of all create a run-control page or select one from the
given
> run-control pages. include that run-control page in a component and
the
> component in turn to a menu.
>
> 2. give security to the run-control page by going to the menu Go ->
> PeopleTools -> Maintain Security -> use. choose one of  the roles to
which
> your user-profile has access. then choose one of the permission
lists
which
> are associated with that role. in the chosen permission list include
the
> run-control page.
>
> 3. create a process-definition for your SQR by going to the menu Go
->
> PeopleTools -> Process Scheduler Manager -> use -> process
definitions.
>
>         after all the above are done u can navigate to the page you
have
> created thru the webmode. after that in that page press the RUN
button.
you
> will be directed to a process request page. therein select ur own SQR
and
> press OK. the SQR should run and the results can be seen in the
Process
> Monitor link on that page. if the SQR has errors a status of Error
will be
> shown otherwise a status of Success will come up.
>
> regards,
> jyoti
>
> -----Original Message-----
> From: Esther Chin [mailto:esther_chin@CONGRUENT.COM.SG]
> Sent: Monday, July 08, 2002 1:40 PM
> To: SQR-USERS@list.iex.net
> Subject: How to run SQR from web ?
>
>
> Hi there,
>
> I have just subcribed to sqr-users. Anybody can tell me how to run
the sqr
> program from the web ?
>
> Best regards,
> Esther
>