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.
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.
Last Comment
ASKER
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.
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.
What error is being thrown?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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/
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/6c2a412d-f040-40eb-832d-4c4c9aafa6d8/
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.
10K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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