Date Range filter

Summary

Search a date period between two dates but only display times on output between a set time.

Content

Hi hope you can help.

I have set up a cross tab report which groups the data I need by day and hour and displays the data by day and hour. This displays perfect if my date range search is set for a particular day between the hours I want it to display which is between 9am - 6pm.

If I expand my search date range to more than 1 day my output displays the times outside of the above hours. Is there a way of not showing these times in my output as there will never be any data outside of 9am and 6pm to present?