Pass date parameter

[suntanme]

I am trying to pass a date parameter to Crystal Reports 8.0 from VC. It works great for strings and numbers but crashes on dates. I assuming that my syntax is incorrect. Does anyone have a suggestion? Thanks in advance.


m_Report->ParameterFields->GetItem(1)->SetCurrentValue((_bstr_t)"@TheDateParameter;& Date(2000,01,01) &;

 

[suntanme]

Found the solution ... you can't send parameter dates when using RDC. They have to passed as formulas.

 

[chelseatech]

I'm using the RDC in VB and passing date parameters.

You can pass parameters of any type (including multiple values and ranges) using the ParameterFields collection.
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[suntanme]

Yes, I see that CR8 will now allow you to pass dates. Sorry for any confusion.

http://support.crystaldecisions.com/library/kbase/articles/c2002680.asp

 

[financeguy]

I am having trouble passing a date parameter to a web report using J#. Here are the details:
-Displaying a Crystal Report v9.0 on an ASP .NET Web Form using the Crystal Web Viewer
-data retrieved from a SLQ Server 2000 Stored Procedure using an OLE DB (ADO) data source
-Application is developed using J#
-Code:
System.DateTime dtVar;
dtVar = new System.DateTime(2003,1,03);
pdvStartDate = new CrystalDecisions.Shared.ParameterDiscreteValue();
pdvStartDate.set_Value(dtVar);
pvStartDate = new CrystalDecisions.Shared.ParameterValues();
pvStartDate.Add(pdvStartDate);
reportDocument1.get_DataDefinition().get_ParameterFields().get_Item("@iStartDate&quot.ApplyCurrentValues(pvStartDate);

-Error Message:
[Exception: Exception of type System.Exception was thrown.]
CrystalDecisions.Web.ReportAgent.v(Boolean `)
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()

-if I comment out this code and set a default value in the report, the report displays successfully

Look forward to hearing about the simple fix I am missing!