Re: Webdb multi-part reports, PL/SQL parameters?
From: SyonOCPAD <syonNOsySPAM_at_perigee.net.invalid>
Date: Wed, 19 Apr 2000 10:26:35 -0700
Message-ID: <05006397.13a52aca_at_usw-ex0102-084.remarq.com>
OPEN CURSOR 2(c_deptno);
Htp.tableopen(PARAMETERS);
LOOP
htp.tablerecordopen;
FETCH CURSOR 2 into RECORD;
END LOOP;
CLOSE CURSOR 2;
htp.tableclose;
htp.br;
END LOOP;
CLOSE CURSOR 1; In article <pW=9OJ7zix23Zj2sSPZSkFpSFrGA_at_4ax.com>, Kirmo Uusitalo <kirmo.uusitalo.NO.SPAM_at_iki.fi> wrote:
>Hi,
>Hello Oracle Gurus,
>
>Is there a way to create a multi-part report in webdb, i.e. a
report
>that would display the results of several queries?
>
>For instance, the results of the following queries should be
>displayed in "single page" as the report is run:
>
>SQL> select * from dept where deptno=30;
>
> DEPTNO DNAME LOC
>--------- -------------- -------------
> 30 SALES CHICAGO
>
>SQL> select * from emp where deptno=30;)
>
> EMPNO ENAME JOB MGR HIREDATE
SAL COMM
>--------- ---------- --------- --------- --------- --------- ---
> DEPTNO
>---------
> 1 John Manager 27-NOV-99
>
>As far as I know, the standard reports created with webdb only
produce
>one single "table". There is a possibility to add advanced
PL/SQL
>code to the report, but so far I have not been able to pass the
>parameters (such as deptno in the above example) to the PL/SQL
>code. If that would be possible I believe it should be quite
easy to
>call the dept_emp report from the dept report. Or even better,
the
>dept report could be produced by a PL/SQL procedure.
>
>I believe this is not a unique wish, so there must be a way to
>fullfill it. Any suggestions? I think one workaround to do
this
>would be to use frames (launch the dept report on top frame and
the
>other to the bottom fram), but I'd rather not use frames as the
report
>should be easily printable as well.
>
>So far I have been using webdb 2.0.5 on NT, but will soon
upgrade to
>2.2.
>
>Thanks in advance,
>
>Kirmo Uusitalo
>If you reply via email, please use my real email address:
>kirmo.uusitalo[at]iki.fi
>
>
Date: Wed, 19 Apr 2000 10:26:35 -0700
Message-ID: <05006397.13a52aca_at_usw-ex0102-084.remarq.com>
Yes, Create two explicit cursors.
Return the value of the first cursor to a record (of cur%
ROWTYPE).
Pass the second cursor the variable from the first.
PSEUDO-CODE!
OPEN CURSOR 1;
LOOP
Htp.tableopen(PARAMETERS);
htp.tablerecordopen;
FETCH CURSOR 1 into RECORD;
htp.tabledata(PARAMETERS); htp.tabledata(PARAMETERS); htp.tablerowclose; htp.tableclose; htp.br;
OPEN CURSOR 2(c_deptno);
Htp.tableopen(PARAMETERS);
LOOP
htp.tablerecordopen;
FETCH CURSOR 2 into RECORD;
htp.tabledata(PARAMETERS); htp.tabledata(PARAMETERS); htp.tablerowclose;
END LOOP;
CLOSE CURSOR 2;
htp.tableclose;
htp.br;
END LOOP;
CLOSE CURSOR 1; In article <pW=9OJ7zix23Zj2sSPZSkFpSFrGA_at_4ax.com>, Kirmo Uusitalo <kirmo.uusitalo.NO.SPAM_at_iki.fi> wrote:
>Hi,
>Hello Oracle Gurus,
>
>Is there a way to create a multi-part report in webdb, i.e. a
report
>that would display the results of several queries?
>
>For instance, the results of the following queries should be
>displayed in "single page" as the report is run:
>
>SQL> select * from dept where deptno=30;
>
> DEPTNO DNAME LOC
>--------- -------------- -------------
> 30 SALES CHICAGO
>
>SQL> select * from emp where deptno=30;)
>
> EMPNO ENAME JOB MGR HIREDATE
SAL COMM
>--------- ---------- --------- --------- --------- --------- ---
> DEPTNO
>---------
> 1 John Manager 27-NOV-99
20 0>
> 30
> 2 Kirmo Worker 28-NOV-99
40 0
> 30
>
>As far as I know, the standard reports created with webdb only
produce
>one single "table". There is a possibility to add advanced
PL/SQL
>code to the report, but so far I have not been able to pass the
>parameters (such as deptno in the above example) to the PL/SQL
>code. If that would be possible I believe it should be quite
easy to
>call the dept_emp report from the dept report. Or even better,
the
>dept report could be produced by a PL/SQL procedure.
>
>I believe this is not a unique wish, so there must be a way to
>fullfill it. Any suggestions? I think one workaround to do
this
>would be to use frames (launch the dept report on top frame and
the
>other to the bottom fram), but I'd rather not use frames as the
report
>should be easily printable as well.
>
>So far I have been using webdb 2.0.5 on NT, but will soon
upgrade to
>2.2.
>
>Thanks in advance,
>
>Kirmo Uusitalo
>If you reply via email, please use my real email address:
>kirmo.uusitalo[at]iki.fi
>
>
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!