Chart Data base on Group Band or Grouped Data
I had searched the forum by "Chart" and read the 4 pages result without getting answer so I asked here.
I had masterdataband which is grouped by several levels of Group Header / Footer which work fine without chat.
Adding chart to last level group footer is also easy and it show only the records in the group.
However, adding chart in other levels or report summary level is not good. It show all individual records within range rather then aggregated data in the last level grouping.
The simplest sample is as below
Type, Item, Value
Fruit,Apple,10
Fruit,Orange,15
Stationary,Pen,22
Stationary,Pencil,8
Let say we group the report by Type and in the Group Footer, the pie chart (label=Item Field, Pie=Value Field) show well the item and value in group.
In Report Summary field the pie chart (label = Type Field, Pie = Value Field) show 4 records, Fruit 10, Fruit 15, Stationary 22, Stationary 8 instead of 2 records Fruit 25, Stationary 30.
I know that I can use fix data and generate the source1, source2 in group footer events.
However, as I had to add chart support to hundreds of reports and the actual reports are much much more levels and complicated that I would like to ask if some setting in the chart components / series component that can achieve the required result.
Please let me know even if using script is the only solution so that I can give up finding the correct setting. Thanks in advance.
I had masterdataband which is grouped by several levels of Group Header / Footer which work fine without chat.
Adding chart to last level group footer is also easy and it show only the records in the group.
However, adding chart in other levels or report summary level is not good. It show all individual records within range rather then aggregated data in the last level grouping.
The simplest sample is as below
Type, Item, Value
Fruit,Apple,10
Fruit,Orange,15
Stationary,Pen,22
Stationary,Pencil,8
Let say we group the report by Type and in the Group Footer, the pie chart (label=Item Field, Pie=Value Field) show well the item and value in group.
In Report Summary field the pie chart (label = Type Field, Pie = Value Field) show 4 records, Fruit 10, Fruit 15, Stationary 22, Stationary 8 instead of 2 records Fruit 25, Stationary 30.
I know that I can use fix data and generate the source1, source2 in group footer events.
However, as I had to add chart support to hundreds of reports and the actual reports are much much more levels and complicated that I would like to ask if some setting in the chart components / series component that can achieve the required result.
Please let me know even if using script is the only solution so that I can give up finding the correct setting. Thanks in advance.
Comments
It seems one cannot get a reply in the forum recently if
1. asking for anticipated release date of FR5
2. the question take more than 1 line to answer.
I hope the reason is they are busy preparing the FR5 release.