Group one way, graph another?
I can't believe I haven't run into this before! So I feel like a bit of a n00b asking, even though it seems so simple.
I want to be able to:
Group my data, many layers thick: Region -> country -> account manager -> company
AND at the top of the report, I want to show a running total of (for ease of argument let's say) sales grouped by the date that the sale happend in a line chart, for trending purposes.
Can I group my data one way, but graph it another? Or do I have to create a sub-report, and pull the whole dataset twice?
I suspect I know the answer, but I'd love to be pleasantly surprised!
Where exactly you want to place the chart in the report in group headers or in report header?
If you are placing in group header then it is better to go with subreport if you want to group on seperate field.
if you are placing it in report header then you can change the fields in advanced tab and create the chart.