What I think is happening here is that the sql is grouping by Week Number and the SQL Server starts ther week on Sunday and goes through Saturday.  so if you run the report to cover a Sunday, you'll automatically get a 2nd row. 
Consider the dates  2/10 and 2/17 are different week numbers so if I selected a begin/end period of 2/11 through 2/17, I'll get one row for the week of 2/10 and one row for the week of 2/17 (the sunday that falls in the next week. 
Try running your reports for dates that are encompased in a single week (Sunday to Saturday) and see if you still get 2 rows. 
I'm SO glad you're getting involved in reporting.  There are not enough people that know it!

I seem to remember an issue with this some time ago. Maybe it's in the bug toolkit (if that still exists) - sorry I couldn't help further!

Sent from my iPhone, please excuse brevity and mistakes.

On Feb 20, 2013, at 7:27 PM, "Cisco Developer Community Forums" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>> wrote:

Sarah Barnes has created a new message in the forum "Contact Center Reporting": -------------------------------------------------------------- I have tried it all ways, I have run the reportas an absolute week 2/10 - 2/16 and I still get the xtra day which is the 2/17!
That does make sense re the Week number on the absolute date range report . On the relative date report however, I think there may still be a problem..
I will try again and see if I can get it to work. :-)

--
To respond to this post, please click the following link: http://developer.cisco.com/web/ccr/community/-/message_boards/view_message/12191905 or simply reply to this email.

Hi Mike, I tried this and it did not work. 
This is only happening on the relative date report you helped us with. From what I understand with what paige has said. The relative date is running Monday to Sunday however there is conflict with underlying information is pulling across Week 7 & 8. What would be better was is we could have chane the relative date to SUnday to Saturday, so it mirrors the Information as Week 7 only.. 
I have been trying to Manipulate the Relative date SQl, however as you can imagine, I have not been succesful. 
Anything you can recommend would be welcome. 

Hi Paige, I am not sure what I am doing wrong, However I have tried what you advised and I still can't  get it to work.
here is the group by statement
GROUP BY
 Agent.SkillTargetID,
Person.LastName,
Person.FirstName,
 Media_Routing_Domain.EnterpriseName,
DATEPART(yy, ASGHH.DateTime) ,
DATEPART(mm, ASGHH.DateTime) ,
DATEPART(ww, ASGHH.DateTime) ,
dateadd(week, datediff(week,0, ASGHH.DateTime), -1)
However further up in the query I have
FROM     (SELECT
Media_Routing_Domain.EnterpriseName AS Media, dateadd(week, datediff(week,0, ASGHH.DateTime), -1) AS Interval,
DATEPART(yy, ASGHH.DateTime) AS Year,
DATEPART(mm, ASGHH.DateTime) AS Month,
DATEPART(ww, ASGHH.DateTime) AS Week,
If i take out the group by, then it errors and I have to take out the From piece, whatever happend the annoymous block doesn't create!
This is the relative date sql that Mike created and inserted into the report.
DECLARE @dtStartDateTime DATETIME, @dtEndDateTime DATETIME
SET @dtStartDateTime = CASE :relative_date
 WHEN 1 THEN dateadd(day, datediff(day, 0, getdate()), 0)
 WHEN 2 THEN dateadd(day, datediff(day, 0, getdate()) - 1, 0)
 WHEN 3 THEN dateadd(week, datediff(week, 0, getdate()), 0)
 WHEN 4 THEN dateadd(week, datediff(week, 0, getdate()) - 1, 0)
 WHEN 5 THEN dateadd(month, datediff(month, 0, getdate()), 0)
 WHEN 6 THEN dateadd(month, datediff(month, 0, getdate()) - 1, 0)
 WHEN 7 THEN dateadd(year,datediff(year, 0, getdate()), 0)
 WHEN 8 THEN dateadd(year,datediff(year, 0, getdate()) - 1, 0)
END
SET @dtEndDateTime =  CASE :relative_date
 WHEN 1 THEN dateadd(day, datediff(day, 0, getdate()) - 1, 0)
 WHEN 2 THEN dateadd(day, datediff(day, 0, getdate()) , 0)
 WHEN 3 THEN dateadd(day, datediff(day, 0, getdate()) - 1, 0)
 WHEN 4 THEN dateadd(week, datediff(week, 0, getdate()), 0)
 WHEN 5 THEN dateadd(day, datediff(day, 0, getdate()) - 1, 0)
 WHEN 6 THEN dateadd(month, datediff(month, 0, getdate()), 0)
 WHEN 7 THEN dateadd(day, datediff(day, 0, getdate()) - 1, 0)
 WHEN 8 THEN dateadd(year,datediff(year, 0, getdate()), 0)
END
Hope this helps  :-)
 
 
 
 

Hopefully When he comes online it will be sorted.
Thanks for your Advice on the Hold Question, Everything is Adding up correctly, as far as i  can see... waiting to hear back from the customer.
Take Care.
:-)