|
| I have designed a crystal report(Ver 9) with Oracle(9) stored procedure
which takes 4 parameters. I verified the stored procedure in SQL Plus
and saved crystal report (save data with report option is taken out).
In my .net web form the code is like the following..
ReportDocument rpt =3D new ReportDocument();
rpt.Load(reportFilePath);
ParaMeterFieldDefinitions pfDefs =3D
rpt.DataDefinition.ParameterFields;
//parameter 1
ParameterDataDefinition pfDef =3D pfDefs[0];
ParameterValues pVals =3D pfDef.CurrentValues;
ParameterDiscreteValue disVal =3D new ParameterDiscreteValue();
disVal =3D 0;
pVals.Add(disVal);
pfDef.ApplyCurrentValues(pVals);
//parameter 2
ParameterDataDefinition pfDef =3D pfDefs[1];
ParameterValues pVals =3D pfDef.CurrentValues;
ParameterDiscreteValue disVal =3D new ParameterDiscreteValue();
disVal =3D 0;
pVals.Add(disVal);
pfDef.ApplyCurrentValues(pVals);
//parameter 3
ParameterDataDefinition pfDef =3D pfDefs[2];
ParameterValues pVals =3D pfDef.CurrentValues;
ParameterDiscreteValue disVal =3D new ParameterDiscreteValue();
disVal =3D "03/04/2005";
pVals.Add(disVal);
pfDef.ApplyCurrentValues(pVals);
//parameter 4
ParameterDataDefinition pfDef =3D pfDefs[3];
ParameterValues pVals =3D pfDef.CurrentValues;
ParameterDiscreteValue disVal =3D new ParameterDiscreteValue();
disVal =3D "03/04/2006";
pVals.Add(disVal);
pfDef.ApplyCurrentValues(pVals);
CrystalReportViewer1.ReportSource =3D rpt;
when I ran my web form to display the report I am getting the the
following error....
DataSourceException: Query Engine Error: 'C:\Dummy
Reports\myDummyreport.rpt']
.F(String , EngineExceptionErrorID
)
.A(Int16 , Int32 )
.@(Int16 =7F)
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestCont=
ext
reqContext)
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestCont=
ext
pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain()
Any help would be greatly appreciated.
thanks in advance
--RK
|
|