• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

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?
0
itsupport1199
Asked:
itsupport1199
  • 5
  • 2
  • 2
  • +1
2 Solutions
 
ghayasurrehmanCommented:
use getDate() instead of Today()
0
 
itsupport1199Author Commented:
It doesn't recognize getDate.   I get the squiggly lines underneath it.  
0
 
8080_DiverCommented:
Be sure to include the open and close parentheses.  GETDATE()
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
itsupport1199Author Commented:
I did.  Still no luck.  
0
 
itsupport1199Author Commented:
This is exactly how it appears in the default value box: =DateAdd("dd",-60, getDate())
0
 
8080_DiverCommented:
Drop the = and see if that doesn't help. ;-)
0
 
itsupport1199Author 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."
0
 
itcoupleCommented:
=DateAdd("d",-60, Today())
0
 
itcoupleCommented:
GetDate works fine but in SQL Server ;) in SSRS you are right using Today()

The parameter you want to use is d, dd doesn't exist.

Regards
Emil
0
 
itsupport1199Author Commented:
Changing "dd" to "d" worked like a charm.  
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now