Solved

SSRS Report Builder DB2 date parameters

Posted on 2013-01-03
5
1,049 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
[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
  • 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
finding tables 2 79
Shell Script on AIX 7 178
SSRS  - Dropdown with Null 3 37
Show RTF format in an SSRS report 3 72
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

751 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