Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1171
  • Last Modified:

SSRS Report Builder DB2 date parameters

I have built a report through Report Builder and created date parameters (StartDate and EndDate)

WHERE
activity_dt between :StartDate and :EndDate

Why am I getting an error? How can make this work using the date parameters that users can self-select?
Thanks.
0
saved4use
Asked:
saved4use
  • 3
  • 2
1 Solution
 
Dave FordSoftware Developer / Database AdministratorCommented:
In order to diagnose your problem, let's start with some questions.

What's the date-format you're using in the DB2 connection?  (e.g. USA, ISO, EUR, JIS,
JUL, etc.)

Also, what are the specific values of StartDate and EndDate?

-- DaveSlash
0
 
saved4useAuthor Commented:
Date format = USA 10/01/2012
No specific value for StartDate and EndDate - it's going to be whatever date range the user enters.

**I use 'between :StartDate and :EndDate' in SSRS for an Oracle db rpt and it works perfectly. Just not sure why DB2 is throwing errors.
0
 
Dave FordSoftware Developer / Database AdministratorCommented:
What error is being thrown?
0
 
saved4useAuthor Commented:
0
 
saved4useAuthor Commented:
Figured it out through a Google search. Link to correct answer attached.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/6c2a412d-f040-40eb-832d-4c4c9aafa6d8/
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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