Re: reporting 2.5/3.0
From: Paul Dorsey <pdorsey.dulcian_at_worldnet.att.net>
Date: 23 Sep 1998 01:11:15 GMT
Message-ID: <6u9hrj$kok_at_bgtnsc02.worldnet.att.net>
Date: 23 Sep 1998 01:11:15 GMT
Message-ID: <6u9hrj$kok_at_bgtnsc02.worldnet.att.net>
The obvious answer is to use a formula column. However, you performance will be not so hot (if you have a real DB). The best way to do this is to build a function to do what you want and to embed it in a view.
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Sandeep Sodhi wrote in message <36066EAA.904A289_at_icon.com>...Received on Wed Sep 23 1998 - 03:11:15 CEST
>Hi Everybody!!
>
> Have a simple question in reports..I want to design reports using the
> oracle reports 3.0 which is almost similar to 2.5.
>
> Now I already have the standalone stored procedure whcih produces
>the an ascii report .The logic is as follows
>
> {
> make column headings
> open a cursor
> iterate cursor
> compute and print value on each row
> close cursor..
> }
> The iteration is necessaty as column values are checked for some
>conditions before computin
>
> How do I put the above logic in the reporting tool..
>
> thanks in advance..
> If you want I could send you the code
>
> I am not a oracle guy...work on java.
> sandeep
>
>
>