Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS Report Builder DB2 date parameters

Posted on 2013-01-03
5
Medium Priority
?
1,138 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:Dave Ford
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:Dave Ford
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

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…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

963 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