Mac1986 (12/22/2012)
All I want is a filter in the report, where users can choose their date, then when they push the ViewReport option they should see all the 58 sessions of that one particular day.
Create a begin and end date parameter in your report and add to your WHERE clause like:
WHERE WorkQueueStartWorkDate BETWEEN @StartDate AND @EndDate
HTH,
Rob