0

I need to create a report for a process that spans from time t1 to t2.
In the report I need to have number of graphs, one for every 4 hours of the process, for example if t1=9:30 and t2=20:17 I need three graphs in total, one from 9:30 to 13:30, one from 13:30 to 17:30 and the last one from 17:30 to 20:17.
The timespan, and thus the number of graphs, is theoretically limitless.

How can I do that?

Im using visual studio community 2019, and my data is from an sql server 15.0.2 that I can change freely.

ubs
  • 1
  • 2
  • 1
    You'd want to create a time segment field in your data to indicate which 4-hour period it is (eg. DateDiff(HOUR, @T1, TIME_FIELD) ). Then in SSRS use a LIST grouped by this time segment field and put chart in Detail cell. The list will create a separate cell for each time segment and the chart will display whatever data you have for that period. – Hannover Fist Feb 14 '23 at 18:00

0 Answers0