Reporting on Specific hours of the day

Hi,

It can be done using the Filter Results tab:

...then do the same with Day of Week.  Thank you very much.

I am using the following code for business hours:

DECLARE     @ReportPeriod int,
        @BHstart int,
        @BHend int,
        @BWstart int,
        @BWend int     
    Set @ReportPeriod=1
    Set @BHstart=8    -- Start time business hours
    Set @BHend=18    -- End Time Business hours
    Set DATEFIRST 1    -- First Day of Week is a Monday, default is Sunday
    Set @BWstart=1    -- Starting WeekDay Business Week
    Set @BWend=5    -- End WeekDay of Business Week
SELECT *
WHERE
        -- Business Hours
(DATEPART(weekday,DateTime)
    Between @BWstart AND @BWend) AND
(DATEPART(hour,DateTime)
    Between @BHstart-Nodes AND @BHend)

Thanks for sharing this. Note that the Weekday order will not be the same depending of the Country you are:

http://msdn.microsoft.com/en-us/library/ms174420.aspx