Link to home
Create AccountLog in
Avatar of itsupport1199
itsupport1199

asked on

Default Date Parameter "Error During Processing"

I'm having a problem with a DateAdd function in SQL Server Reporting Services as default value for a parameter.  I've entered the expression "=DateAdd("dd",-60,Today())" as the default value and it doesn't show any errors in the expression builder.  But, when I go to preview the report I get the error "An error occurred during local report processing.  Error during processing of 'ActivityFrom' report parameter."

Any thoughts?
Avatar of ghayasurrehman
ghayasurrehman
Flag of Pakistan image

use getDate() instead of Today()
Avatar of itsupport1199
itsupport1199

ASKER

It doesn't recognize getDate.   I get the squiggly lines underneath it.  
Be sure to include the open and close parentheses.  GETDATE()
I did.  Still no luck.  
This is exactly how it appears in the default value box: =DateAdd("dd",-60, getDate())
Drop the = and see if that doesn't help. ;-)
No luck there, either.  When I drop "=" the whole expression gets squigglied in the expression builder and I get the error "The definition of the report '/Member Activities by Chapter' is invalid.  The property 'DefaultValue' or report parameter 'ActivityFrom' doesn't have the expected type."
ASKER CERTIFIED SOLUTION
Avatar of itcouple
itcouple
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Changing "dd" to "d" worked like a charm.