charlesdu101
New member
- Local time
- Today, 14:31
- Joined
- Oct 23, 2006
- Messages
- 3
Can someone please help
Im passing 3 parameters using the following syntax in Access 2002.
CrystalReport.ReportFileName = filename & ".rpt"
CrystalReport.parameterfields(0) = "StartDate;" & Format(dStart, "yyyy/mm/dd") & ";TRUE"
CrystalReport.parameterfields(1) = "EndDate;" & Format(dEnd, "yyyy/mm/dd") & ";TRUE"
I have done a msgbox in Access CrystalReport.parameterfields(0) for troubleshooting and the following is passed to crystal startdate;12/12/2006;TRUE
Within the Crystal report i have a simple formula field
called startdate which gets the values passed from Access and converts it into a date using the below function
DTStoDate(?startdate)
This report has been working fine and now on a different XP machine I get the error message
Error in formula <enddate>.
'DTStodate({?enddate})
'
The remaining text does not appear to be part of the formula.
I have then modified the Crystal report and taken out the DTStodate(?startdate) and DTS(?enddate) formula fields and the report works. So somehow Crystal is not understanding this function. However I need these parameter fields.
I have checked the reference libraries and none are reported missing, also i have registered the following DLLs
o Crystl32.ocx
o Mscomct2.ocx
o Comcat.dll
o Crpaig.dll
o Crpe32.dll
o Implode.dll
o Olepro32.dll
o P2bdao.dll
o Crviewer.dll
Does anyone know what is missing as it is working fine on alot off machines. Only thing that has changed recently is I upgraded the Reports interface from 97 to 2002, however other machines are working perfectly on 2002. Iam using Crystal 7.0.
thanks
Im passing 3 parameters using the following syntax in Access 2002.
CrystalReport.ReportFileName = filename & ".rpt"
CrystalReport.parameterfields(0) = "StartDate;" & Format(dStart, "yyyy/mm/dd") & ";TRUE"
CrystalReport.parameterfields(1) = "EndDate;" & Format(dEnd, "yyyy/mm/dd") & ";TRUE"
I have done a msgbox in Access CrystalReport.parameterfields(0) for troubleshooting and the following is passed to crystal startdate;12/12/2006;TRUE
Within the Crystal report i have a simple formula field
called startdate which gets the values passed from Access and converts it into a date using the below function
DTStoDate(?startdate)
This report has been working fine and now on a different XP machine I get the error message
Error in formula <enddate>.
'DTStodate({?enddate})
'
The remaining text does not appear to be part of the formula.
I have then modified the Crystal report and taken out the DTStodate(?startdate) and DTS(?enddate) formula fields and the report works. So somehow Crystal is not understanding this function. However I need these parameter fields.
I have checked the reference libraries and none are reported missing, also i have registered the following DLLs
o Crystl32.ocx
o Mscomct2.ocx
o Comcat.dll
o Crpaig.dll
o Crpe32.dll
o Implode.dll
o Olepro32.dll
o P2bdao.dll
o Crviewer.dll
Does anyone know what is missing as it is working fine on alot off machines. Only thing that has changed recently is I upgraded the Reports interface from 97 to 2002, however other machines are working perfectly on 2002. Iam using Crystal 7.0.
thanks