Joined: 10 Oct 2011
Online Status: Offline
Posts: 47
Topic: New to charts and need to drill down Posted: 15 Jan 2013 at 4:59am
I am new to using charts in Crystal. I havent used any charts for years.
I created a chart from a Command that I pasted a query into. The chart looks fine for the first step.
Now I need to drill down into the data displayed on the chart. This is where I am stuck. How do I go about drilling down?
I have the chart in the report header right now. I moved it to a group section as I read in a book. However, that divided my single chart into individual charts, which I dont want.
How do I successfully drill down in the chart I created?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 15 Jan 2013 at 5:08am
the structure of the report has to support the the way the chart is organized and the summarizations need to be based on the group level sumamrizatrions.
basically you have have to set up your groups in the report, then sum or count in the group.
then in the chart design on data use the group option and then the available items that appear for you to use are based on the the group and group summarizations you created in the rest of the report set up/design.
Joined: 10 Oct 2011
Online Status: Offline
Posts: 47
Posted: 15 Jan 2013 at 5:23am
I created a group on Manager. I also put a count of part numbers in the group header. The rest of the fields are in details.
When I add the chart in the group section, it divides the single chart into an individual one for each Manager.
I understand why it gets divided. What I dont understand is how can I make this work to where I can drill down into the data in a single chart for all managers listed in the data.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum