link the report with Package

[maas]

Hello All,

I am having a ready made package which is retrieving the correct data.
The package has a procedure to fetch the data as the user runs the report:

PROCEDURE P_Get_Asset_Liab (T_Cursor IN OUT T_ASSETS)
IS
BEGIN
--
OPEN T_Cursor FOR
SELECT SLNO , ccy,altype,ALDESC , AMT
FROM
(SELECT 14 slno ,br.ccy,DECODE(sign(sum(br.AMOUNT)),-1,'Assets',0,'Liability',1,'Liability') altype,'Asset_Type' Aldesc , ABS(sum(br.AMOUNT)) amt
FROM acc br , CURRENCY C, secure s,counter cp1,counter cp2, acc_is ba1
WHERE RPTNO =( select max(rptno) from acrpt )
AND br.ccy = c.ccy
and br.secure = S.THEKEY
and br.counter = cp1.thekey
and br.buck = acc_is.thekey
AND br.ccy='USD' and ba2.acc_name in ('GROUPs')
AND br.amount <> 0
group by br.CCY
END P_Get_Assets;
END K_ASSETs;

Can I add it to my report in crystal and fetch the data from it?
Once I have added it, it is referring to verify the database and whenever I tried to verify the database. It is showing that it is not there and crystal will remove it from the list.

 

[IanWaterman]

Don't think you can use a package.

You will need to have procedure as stand alone.

Ian