Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Default Date Parameter "Error During Processing"

Posted on 2010-09-09
10
Medium Priority
?
357 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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 500 total points
ID: 33641989
=DateAdd("d",-60, Today())
0
 
LVL 10

Assisted Solution

by:itcouple
itcouple earned 500 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

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!

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

610 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