I am using Crystal Reports 10 and am using a stored procedure to return data to a line graph. The stored procedure returns 1 record for each second for what is typically a 20 minute cycle resulting in approximately 1200 rows or so and each row is plotted on the graph.
My issue is that I would like to show the client 60 second intervals along the X axis. When I try to plot out all 1200 seconds, the x axis looks (predictably) awful. Another detail is each row returned by the stored procedure is used to plot 4 lines on the same graph for the exact same second (do not know if this is contributing to my troubles).