Did you figure it out? Can you post how you did the value list for the relative dates?

Thanks

could you post a couple of sample rows from your relative dates table?
I get the part about the value list but how would the table look like? what columns, etc.

thanks

I have attached a report that you can import and check the relative dates.
Note that once you import the report you need to add the collections to relativedates value list with this month,this year etc.

Then go to the parameters and uncheck required in date time field.
And allow null values.
Note that Relative dates is a Decimal field.

Regards

Avinash Bhagwan
Contact Center Engineer
CDW
120 S Riverside Plaza Floor 9 | Chicago, IL 60606
Mobile: 847.271.9661
Email: avinash.bhagwan@cdw.com<mailto:scott.thomas@cdw.com>

[https://webmail.ogilvypr.com/exchange/Macy.Boehm/Inbox/Fw:%20CDW%20Sig.EML/1_multipart_xF8FF_2_CDW-Email-Sig.png/C58EA28C-18C0-4a97-9AF2-036E93DDAFB3/CDW-Email-Sig.png?attach=1]

From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Tuesday, September 27, 2011 5:04 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Ramprasad Rathod in Contact Center Reporting (CCR) - Contact Center Reporting: RE: New Message from Avinash Bhagwan in Contact Center Reporting (CCR) - Co

Ramprasad Rathod has created a new message in the forum "Contact Center Reporting":

--------------------------------------------------------------
Hi Avinash

Could you please send me a sample report defention with relative dates for Perskg26

I tried ur steps.. dot get the results when I run with this option

Thanks
Ram

From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Tuesday, September 27, 2011 2:56 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Avinash Bhagwan in Contact Center Reporting (CCR) - Contact Center Reporting: RE: Relative Dates for Anonymous Blocks

Avinash Bhagwan has created a new message in the forum "Contact Center Reporting":

--------------------------------------------------------------
The way you use the Relative Dates is you create the value list with Collections of the Relative Dates.
Then you associate this value list in your query.
The key is if you use relative dates and fixed dates which is what i tend to use then you need to go to the parameters tab in your Report definition and uncheck the required option and select the option to pass null values for empty strings. you need to do this for your fixed dates components i.e start and end date as well as relative dates.

Then it should work.

I have done quite a few reports and gotten relative dates in pretty much all the reports functional.

Regards
Avinash


Note: If you have imported a report then you still need to go to the parameters and set the values for empty strings and required check boxes.
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/4537788>

or simply reply to this email.
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/4540752>

or simply reply to this email.

Attachments:

Hi Ram,

I've tried setting this up and when I run the query against the AWDB directly and substitute some values in for :start, :end and :relativedate it all works fine. I've checked the values in the value list for my 'Dates' value list and they look ok as well but when I try to run the report, I select the relevant parameters then click run and I just that errors on webpage icon on the bottom left of Internet Explorer which when I expand out says:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E)
Timestamp: Thu, 15 Dec 2011 07:31:29 UTC


Message: 'dojo.byId(...).value' is null or not an object
Line: 42
Char: 2
Code: 0
URI: http://10.53.109.141:8081/cuic/scripts/ReportFilter.js


Any thoughts?

Cheers,
Nathan

Hi Avinash,

Thanks for that. I actually had the start and end parameters set as DATE instead of DATETIME which was causing an issue so after changing that it started working.

Thanks again for that, great idea using a value list for relative dates!

Cheers,
Nathan

I've designed to Select Date Range thru query, In below mention query you can select 'M' for Monthly, 'W' for weekly, 'D' for Daily and 'C' for Custom Date Range.
In report filtering criteria you will have First criteria is Enter (M or D or W or C). If you select M or D or W then you dont need to set start date and end date. but if you select C .i.e Custom Date Range then you need to select start date and end date.
Make sure Start Date and End date should not be checked as Required check box in Report Definition ---> parameter Tab.
 
BEGIN 
 
DECLARE 
@dtStartDateTime DATETIME, 
@dtEndDateTime DATETIME, 
@sDateRange AS CHAR(1) 
 
 
SET @sDateRange = :daterange 
 
DECLARE @TodaysDate DATETIME 
SET @TodaysDate = GETDATE() 
 
IF @sDateRange = 'D' --DAILY 
BEGIN 
SET @dtStartDateTime = CONVERT(DATETIME, CONVERT(VARCHAR(10),@TodaysDate, 101)) 
SET @dtEndDateTime = CONVERT(DATETIME, CONVERT(VARCHAR(10),@TodaysDate + 1, 101)) 
END 
 
ELSE IF @sDateRange = 'M' -- MONTHLY 
BEGIN 
SET @dtStartDateTime = CONVERT(DATETIME, CONVERT(VARCHAR(2), DATEPART(MM,@TodaysDate)) + '/1/' + CONVERT(VARCHAR(4), DATEPART(YY,@TodaysDate))) 
SET @dtEndDateTime = CONVERT(DATETIME, CONVERT(VARCHAR(10),@TodaysDate + 1, 101)) 
END 
 
ELSE IF @sDateRange = 'C' -- CUSTOM DATE RANGE 
BEGIN 
SET @dtStartDateTime =  :startdate
SET @dtEndDateTime = :enddate  
END 
 
ELSE -- WEEKLY (IF User specified anyother value than these 4 than also Weekly will execute.) 
 
BEGIN 
SET @dtStartDateTime = DATEADD(D, -1 * ((CASE (DATEPART(DW, @TodaysDate) - 2) WHEN -1 THEN 6 ELSE (DATEPART(DW, @TodaysDate) - 2) END)), @TodaysDate) 
SET @dtEndDateTime = CONVERT(DATETIME, CONVERT(VARCHAR(10),@TodaysDate + 1, 101)) 
END 
SELECT * FROM Termination_Call_Detail
Where DateTime BETWEEN @dtStartDateTime AND @dtEndDateTime
END