Skip to Content
0
Dec 12, 2022 at 07:41 AM

Crystal report Configure Hana Db

158 Views

Hi Team

When I am Running two Reports in Sap Sales performance Home Site, But Only i can see last Running Reports, example (First Am Selected test1 report and test 2 report, Next Start Report the pipeline Will executed but Result only Showing Last Reports Name)

This is my ODS Report Config File -Report Proc

Proc Code:

create procedure EXT.SP_ALL_REPORT_RUN_PROC (

IN periodSeq BIGINT

)

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

DEFAULT SCHEMA EXT

AS

BEGIN

DECLARE V_Callreportname VARCHAR(2000):='';

select runparameters into V_Callreportname

from tcmp.cs_plrun m inner join tcmp.cs_stagetype d on m.stagetypeseq =d.stagetypeseq

where name = 'ODSReportsGeneration' and m.periodseq=periodSeq

and m.reporttypename='Crystal' --and m.status='Successful'

and m.starttime =(

select max(m.starttime) from tcmp.cs_plrun m inner join tcmp.cs_stagetype d on m.stagetypeseq =d.stagetypeseq

where name = 'ODSReportsGeneration' and m.periodseq=periodSeq and m.reporttypename='Crystal' --and m.status='Successful'

) ;

if INSTR(V_Callreportname,'Mob_B2B_Account_Owner')<> 0 then

call EXT.MOB_B2BEXT_SP_ACCOUNT_OWNERS_REPORT_WRITE (periodSeq);

END IF ;

if INSTR(V_Callreportname,'Mob_B2B_Product_Target')<> 0 then

call EXT.MOB_B2BEXT_SP_PRODUCTTARGETS_REPORT_WRITE (periodSeq);

END IF ;

end