Calculated Fields in a Crystal Reports Graph
Posted on 2010-08-17
For this example I have a table called "Results" with three columns Call, Status and Result
I will have input some dummy rows of data
CALL Status Date
123 1 01/08/10
124 1 01/08/10
125 2 01/08/10
126 2 02/08/10
127 1 02/08/10
128 2 02/08/10
129 2 02/08/10
In a graph in crystal reports (bar chart), I want to show the total number of calls per day and also the number of calls with the different status's.
therefore the first bar on the 01/08/10 should show the total calls (3) and then 2 further bars for the two status's showing (2 for status 1) and (1 for status 2)
on the 02/08/10 the first bar should show 4 calls and then 2 further bars again for the two status's showing 1 call and 3 calls respectively
My question is how do I get the values of the different status's on each day, so that I can show them in the graph.