How to Pass parameters using Activex to Crystal Reports from Forms

[MishenkovKS]

I can not pass parameters to crystal report (activex)

< sample code >
Declare
uid Varchar2(50);
pwd Varchar2(50);
par Varchar2(2000);
return_err number;
reportfile varchar2(100);
a_value_chosen BOOLEAN;
formula varchar2(2000);
dd ole2.obj_type;
dummy_var NUMBER;
begin
dd := ole2.create_obj('Crystal.CrystalReport');
Crystal_CrystalCtrl.reportfilename(dd,'c:\report\otr1.rpt');
Crystal_CrystalCtrl.ole_Connect(dd,'DSN=ora;UID=master;PWD=super');
Crystal_CrystalCtrl.DiscardSavedData(dd,1);
Crystal_CrystalCtrl.Destination(dd, 0);
--CRYSTAL_CRYSTALCTRL.SelectionFormula(dd, '{OWEN_SOTR.SOT_KOD}=''68''');
Crystal_CrystalCtrl.ParameterFields(dd,0,'pname;111;True');
CRYSTAL_CRYSTALCTRL.Action(dd, 1);
--return_err:= Crystal_CrystalCtrl.PrintReport(dd);
end;

Crystal_CrystalCtrl.ParameterFields - return error
< An ole error accurred: 0x80020003 >
But SelectionFormula work good!!!!!!

Help me please !!!!

 

[Guest_imported]

Hi....
I saw your code.....
I hope you have got the answer for your query by this time.
I am also facing the problem when I run the Crystal report from the Forms 6i. I am not able to access the activex control in my PL/SQL code. So I can not run the code given by you.
Can you please help me in running this code.

 

[Guest_imported]

Hi....
I saw your code.....
I hope you have got the answer for your query by this time.
I am also facing the problem when I run the Crystal report from the Forms 6i. I am not able to access the activex control in my PL/SQL code. So I can not run the code given by you.
Can you please help me in running this code.

 

[snakeTds]

Hi MishenkovKS,

I'm currently using CrystalReport ActiveX in Oracle Forms6i...As expected, I encountered the same error!
Did you find any workaround or solution?
I tried modidying the Crystal Report packages, upgrading my Oracle Forms6i with appropriated patches...but no one correct the error.

Can U give me a hand please?

Regards,
Tang.

 

[yovette]

Has anyone found a solution for pass parameters to crystal report (activex) from Oracle forms 6i?

 

[Nawaz70]

Plase Send me this forms file

Thanks