We help IT Professionals succeed at work.

Default Date Parameter "Error During Processing"

382 Views
Last Modified: 2012-05-10
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?
Comment
Watch Question

use getDate() instead of Today()

Author

Commented:
It doesn't recognize getDate.   I get the squiggly lines underneath it.  
Be sure to include the open and close parentheses.  GETDATE()

Author

Commented:
I did.  Still no luck.  

Author

Commented:
This is exactly how it appears in the default value box: =DateAdd("dd",-60, getDate())
Drop the = and see if that doesn't help. ;-)

Author

Commented:
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."
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Changing "dd" to "d" worked like a charm.  
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.