Solved

Default Date Parameter "Error During Processing"

Posted on 2010-09-09
10
351 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?
0
Comment
Question by:itsupport1199
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 3

Expert Comment

by:ghayasurrehman
ID: 33640990
use getDate() instead of Today()
0
 

Author Comment

by:itsupport1199
ID: 33641022
It doesn't recognize getDate.   I get the squiggly lines underneath it.  
0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 33641116
Be sure to include the open and close parentheses.  GETDATE()
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:itsupport1199
ID: 33641181
I did.  Still no luck.  
0
 

Author Comment

by:itsupport1199
ID: 33641233
This is exactly how it appears in the default value box: =DateAdd("dd",-60, getDate())
0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 33641514
Drop the = and see if that doesn't help. ;-)
0
 

Author Comment

by:itsupport1199
ID: 33641564
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
 
LVL 10

Accepted Solution

by:
itcouple earned 125 total points
ID: 33641989
=DateAdd("d",-60, Today())
0
 
LVL 10

Assisted Solution

by:itcouple
itcouple earned 125 total points
ID: 33642011
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
 

Author Comment

by:itsupport1199
ID: 33642075
Changing "dd" to "d" worked like a charm.  
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question