Bar graph in a group footer for a single value? (using group totals)

akk2

<p>I have a report with group footers with multiple totals.  I've managed to get this working on each detail row, but in the group footer, it keeps adding bars for each details!  So even if it's in the footer, and I use totals (aggregations), I'll get multiple bars, all with the same value.  It's like it behaves as if it was in details instead of a group footer... </p><p> </p><p>So for the report footer, it's like I'd need to introduce a sort of 'distinct' or group by, but the graph's group by does not seem to work... Confusing!</p><p> </p><p>So Ex:</p><p>grp header: </p><p>detail1:   1, 2 -> graph has 1 bar, ok</p><p>detail2:   3, 4      -> graph has 1 bar, ok</p><p>grp footer: total1, total2   -> graph has two bars, not ok!  Even if based on data of the footer...</p><p> </p><p>I can't seem to figure this one out...  Thanks!</p>

Hans_vd

<p>Hi,</p><p> </p><p>There is a blogpost that describes how to <a data-ipb='nomediaparse' href='http://enterprisesmartapps.wordpress.com/2012/01/16/birt-generate-a-separate-chart-for-each-group-value/'>build a graph in a group header</a>.  </p><p>I think the key part is this:</p><p> </p><p>[color=rgb(85,85,85);font-family:Georgia, 'Times New Roman', Times, serif;font-size:11.818181991577148px;]On the Select Data tab, make sure to choose “use Data from dsOrders”, instead of the default selection which is “Inherit data from container”[/color]</p><p> </p><p>Hope it helps</p>