Re: REPORT Server

From: AR <aura_at_novo.dk>
Date: Fri, 30 Oct 1998 10:29:44 +0100
Message-ID: <36398708.9A4DB3B1_at_novo.dk>

Andrea Cannaos wrote:

> We need to use REPORT SERVER in our existing applications developed in
> DEV2000 v2.1 : our reports now are launched with RUN_PRODUCT and have
> parameter forms and DESTYPE often setted to SCREEN/PREVIEW.. so what we
> have to do to obtain the same results ?
>
> Please answer with e-mail
>
> THANK'S IN advance.
>
> --
> \\\\////
> &( oo )&
> ========oOO==(__)==OOo========
> | |
> |Andrea.Cannaos_at_deagostini.it|
> | |
> ==============================
> || ||
> (__) (__)

Hi,

I know this is an old message, but anyway : Run_Product dosn't work with paramforms (OAS 3) use SHOW_DOCUMENT instead.

eg :

PROCEDURE run_web_rep (rep_name varchar2) IS   server_str varchar2(40) := 'http://www.abc.com/';   rep_server_str varchar2(40) := 'r30ows?server=repserver.world';

  rep_str              varchar2(40)  := '+report='||rep_name;
  user_str             varchar2(40)  :=

'+userid='||get_application_property(username)||'/'||get_application_property(password)||'_at_sbs';

  rep_param_str varchar2(100) :=
'+destype=cache+desformat=html+paramform=yes';   web_url varchar2(200);
BEGIN
  web_url := server_str||rep_server_str||rep_str||user_str||rep_param_str;   web.show_document(web_url,'_BLANK');
END; hope this help.

Anders Rasmussen Received on Fri Oct 30 1998 - 10:29:44 CET