Skip to Content
0
Feb 05, 2023 at 06:47 AM

Crystal Report 2020 - Line Chart multiple series

87 Views

Hi, my data set looks like this...

Product, DateTime, Value
P1, 2023-02-01 12:00, 1
P1, 2023-02-01 13:00, 1.5
P1, 2023-02-01 14:00, 1.8
P1, 2023-02-01 15:00, 1.3
P1, 2023-02-01 16:00, 2
P2, 2023-02-01 13:00, 4
P2, 2023-02-01 14:00, 4.5
P2, 2023-02-01 15:00, 6
P2, 2023-02-01 16:00, 6.3
P2, 2023-02-01 17:00, 3

I want to create a line chart that shows P1, P2, P3 on the same chart but can't get it done properly. The chart seems a bit weird. I tested the same thing using SSRS and Excel, no problem to get it automatically populated. Some how Crystal Report a bit different behaviour.

Y axis = value

X axis = time

Anybody having success doing it ?