1

I'm working on building a couple reports for our company in SSRS in which we are looking to setup a date range between two dates with either a fixed time range set to the single date or to be able to define the time range for the single date. Does anyone know if this is possible at all and/or how it can be setup if it is?

We currently have a date range setup where we can append a time to it (i.e. 11/11/19 8:00:00 AM to 11/15/19 5:00:00 PM), but we are looking to be able to define the time range on the single date, i.e.:

Results between:

11/11/19 8:00:00 AM to 5:00:00 PM

to

11/15/19 8:00:00 AM to 5:00:00 PM

To give a visual representation:

Date/Time Parameter idea screenshot

I feel like this isn't a terribly far fetched idea but all I've been able to find online is singular date/time ranges but not the ability to define a time-range to a single date. Unless this can be achieved via a filter that would potentially work as the time range in our scenario could be fixed, but would be a catalyst to be able to define the time range as well.

Any help or links, ideas, guidance would be greatly appreciated!

Kevin
  • 11
  • 1
  • You could just set up the report to have 4 parameters - 1) `StartDate`, 2) `EndDate`, 3) `TimeRangeStart`, 4) `TimeRangeEnd`. This way, you can tweak your query to fetch the correct data from the correct time range on each day. – Steve-o169 Nov 15 '19 at 17:08
  • That's essentially what I'm looking to accomplish but I do not know how to setup a time-range parameter. The parameter selection would look something like: Start Date: Time Range Start: End Date: Time Range End: The Time Range Start parameter would be bound to the Start Date and the Time Range End parameter would be bound to the End date. – Kevin Nov 19 '19 at 18:11
  • Anybody have any ideas on how to accomplish this? – Kevin Nov 22 '19 at 17:22

0 Answers0