Link to home
Start Free TrialLog in
Avatar of valmatic
valmaticFlag for United States of America

asked on

Crystal Report String required in calc

Hi.  I created a report using Crystal Reports Developer v.11.5 over a SQL database.  I recently swiched servers and am getting an error on one of my report calcs.  both servers are Windows Server 2008 R2 and are running SQL 2012.    
Calc is: {VMI_WC_PRIO.START_DT}<= CurrentDate + 30     error is:  A string is required here.

Error is in the command.  Is this currentdate formula no longer valid?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of valmatic
valmatic
Flag of United States of America image

ASKER

HI.  I verified and it came up with a map window so I unchecked "same type" and I was able to map my report field to the database field in the map window.  The database verified and said it was fixed but then took me to the formula window and said "A String is Required Here".  The "CurrentDate + 30"  portion of my formula is highlighted when this msgbox appears.   thanks
Avatar of Mike McCracken
Mike McCracken
What type does Crystal think the date field is?  

You may have to remove the test to run the command.

When you are in the Crystal editor you can see what type the field is in the field explorer.

mlmcc
Avatar of valmatic
valmatic
Flag of United States of America image

ASKER

Thanks.  I decided to go a different route on this though and just rebuilt the SQL view with my calc in it.  Solved my issue anyway..  Enjoy the points but keep me in mind if you see my name.  I'm fairly new to both SQL server and Crystal so I'm sure I'll have other questions..  cheers.