Connecting Tech Pros Worldwide Forums | Help | Site Map

"field name is not known" error in crystal report

Newbie
 
Join Date: Sep 2008
Posts: 4
#1: Sep 25 '08
i am using a formula in my subreport which goes like this:

'datediff("h",{VEHICLE.jo_datetime_created},{VEHIC LE.jo_datetime_released})

but when i try to run the system it has a run time error which goes like this:

This field name is not known. Error in File C:\DOCUME~1\AMALIN~1\LOCALS~1\Temp\VehicleEfficien cyByVehicleTypeWithBusinessGroup {2A589B55-85CD-4DBE-B90B-AF181A380C8C}.rpt: Error in formula . 'datediff("h",{VEHICLE.jo_datetime_created},{VEHIC LE.jo_datetime_released}) ' This field name is not known.


i am using the same formula in my other subreports, just a different data field, but it seem to work, why can't this work?

what could be wrong with this? I checked the database values for such fields and they seemed okay.

any help, please????

MrMancunian's Avatar
Expert
 
Join Date: Jul 2008
Location: Utrecht, The Netherlands
Posts: 281
#2: Sep 26 '08

re: "field name is not known" error in crystal report


Did you notice the white space between datetim and e_released???

Expand|Select|Wrap|Line Numbers
  1. 'datediff("h",{VEHICLE.jo_datetime_created},{VEHICLE.jo_datetim e_released})
Reply