Crystal Reports VS2012 This field name is not known error

[Former Member]

Hi,

I have problem when trying to set parameter values from the code. When I start the report without setting parameter values but leave the report with parameters set already in report designer the report opens correctly. When I try to change the CurrentValues to new ones from code there is immediately FormulaException and an error saying that the field name is not known am.

Record Formula is

{TDATE} >= {?FromDate} and {TDATE} < {?ToDate}+1

and here is how I'm setting the parameters in code:

rd.SetParameterValue("FromDate", strFromDate);
rd.SetParameterValue("ToDate", strToDate);

My version of CrystalDecisions.CrystalReports.Engine is 13.0.2000.

I tryed different things and also read in several forums but nothing helped.

I will appriciate any advice.

Thank you.

[former_member183750]

See if KBA "1214110 - How to pass a Date/Time parameter to a report at runtime using VB .NET" will help:

http://search.sap.com/notes?id=0001214110&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...

Also, use the search string 'crystal net parameter date' in the search box at the top right corner for more help.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces