Solved

SSRS Report Builder DB2 date parameters

Posted on 2013-01-03
5
1,043 Views
Last Modified: 2013-01-08
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
Comment
Question by:saved4use
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:daveslash
ID: 38742260
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
 

Author Comment

by:saved4use
ID: 38742276
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
 
LVL 18

Expert Comment

by:daveslash
ID: 38742332
What error is being thrown?
0
 

Accepted Solution

by:
saved4use earned 0 total points
ID: 38742379
0
 

Author Closing Comment

by:saved4use
ID: 38754119
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

685 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