Problem with Formula Field

[Sarav]

Hi folks,

I am using a formula field (@age) to calculate age in my report,

Datediff("yyyy",{vwPat.Pat_DOB},CurrentDate)

which gives me age properly in the preview of the report,
BUT,
When i call the same report from my Visual Basic Application
it throws an error saying..

*-----------------------------------------------------------
Error in formula <age>
'Datediff(&quot;yyyy&quot;,{vwPat.Pat_DOB},CurrentDate)
'
The remaining text does not appear to be part of the formula
*-----------------------------------------------------------

I tried changing the report from &quot;crystal syntax&quot; to &quot;basic syntax&quot; also....but still I dont find any solution....please help me in this regard....Thanks in advance......

 

[jjames]

I believe you need to change the double quotes around yyyy to single quotes. Can you post the code where you actually pass the formula?

 

[Sarav]

I tried with single Quote also but it gives the same error.....

anyway here is the code i am using to call the report from my VB Application

crpPrintRP.ReportFileName = &quot;C:\MyApp\MyReport.rpt&quot;
crpPrintRP.Destination = crptToWindow
crpPrintRP.SelectionFormula = &quot; {vwPat.Pat_Seq} = &quot; & Val(lvwPatient.ListItems(intI).SubItems(5))
crpPrintRP.Action = True
crpPrintRP.Reset

age is the formula field i have in the report ....when i delete the age-formula field it works fine......problem comes only when i insert the formula field.....

where am i going wrong.???.....

waiting for ur reply.....

Thanks

 

[bburnell]

This is just a suggestion, but have you tried putting the string...
&quot; {vwPat.Pat_Seq} = &quot; & Val(lvwPatient.ListItems(intI).SubItems(5))

in a string variable and then passing it? Just a thought.
Brett (smsforce) Please visit my websites!

http://www.smsforce.com

http://geocities.com/emushoppe