Eclipse Community Forums: BIRT » Multiple charts on single report

Home

Home » Archived » BIRT » Multiple charts on single report - data-driven?

Multiple charts on single report - data-driven? [message #651312]

Fri, 28 January 2011 16:40

Eclipse User

I am new to BIRT, but an experienced Java developer. I have a data set that looks like this:

group  date     usage
----- -------- ------
  1   20110101   17
  1   20110102    6
  1   20110103    5
     ..... etc
  2   20110101    9
  2   20110102    5
    ..... etc
  3   20110101   19

I want to create a report consisting of a variable number of bar graphs, one per group. I don't know in advance how many different groups are in the data set. Can this be defined using the BIRT tools in Eclipse (BIRT 2.6.1)?

Re: Multiple charts on single report - data-driven? [message #651572 is a reply to message #651312]

Mon, 31 January 2011 11:43

Eclipse User

Yes. You can add a table and group it and then put the chart design in
the group footer. You do not have to put any data in the detail row,
but you can.

Jason

On 1/28/2011 4:40 PM, Jim Garrison wrote:
> I am new to BIRT, but an experienced Java developer. I have a data set
> that looks like this:
>
>
> group date usage
> ----- -------- ------
> 1 20110101 17
> 1 20110102 6
> 1 20110103 5
> ..... etc
> 2 20110101 9
> 2 20110102 5
> ..... etc
> 3 20110101 19
>
>
> I want to create a report consisting of a variable number of bar graphs,
> one per group. I don't know in advance how many different groups are in
> the data set. Can this be defined using the BIRT tools in Eclipse (BIRT
> 2.6.1)?

Re: Multiple charts on single report - data-driven? [message #651596 is a reply to message #651572]

Mon, 31 January 2011 14:41

Eclipse User

I tried this but the chart contains only one bar, using the last value for the group.

I also tried putting the chart into the detail section, but then I get one chart for each detail value as a single bar, not all the detail values for the group as bars in a single chart.

To be clear for this data:

group  date     usage
----- -------- ------
  1   20110101   17
  1   20110102    6
  1   20110103    5
  2   20110101    9
  2   20110102    5
  2   20110103    7
  3   20110101   19
  3   20110102   12
  3   20110103   11

I want a report with three charts, each of which has three bars, as in:

Group 1

    +
    |
    |
    |     17
    |   +---+
    |   |   |
    |   |   |      6
    |   |   |   +---+      5
    |   |   |   |   |   +---+
    |   |   |   |   |   |   |
    +--------------------------------
        01-01   01-02   01-03


Group 2

    +
    |
    |
    |   
    |     9
    |   +---+
    |   |   |              7
    |   |   |      5    +---+    
    |   |   |   +---+   |   |    
    |   |   |   |   |   |   |    
    +--------------------------------
        01-01   01-02   01-03


Group 3

    +
    |
    |
    |     19
    |   +---+
    |   |   |     12
    |   |   |   +---+     11
    |   |   |   |   |   +---+
    |   |   |   |   |   |   |
    |   |   |   |   |   |   |
    |   |   |   |   |   |   |
    +--------------------------------
        01-01   01-02   01-03

[Updated on: Mon, 31 January 2011 14:42] by Moderator

Re: Multiple charts on single report - data-driven? [message #651610 is a reply to message #651596]

Mon, 31 January 2011 16:20

Eclipse User

I started over again from a blank report, and this time placing the chart in the group footer seems to work.

I guess the BIRT designer gets confused if you move stuff around too much....

Re: Multiple charts on single report - data-driven? [message #651821 is a reply to message #651610]

Tue, 01 February 2011 12:25

Eclipse User

Jim,

On every table a set of bindings gets created that maps between the
dataset and the table. You can look at these in the binding tab on the
properties view for the table. When you copy/paste the table does not
remove the binding which will still get evaluated. You can always
remove them manually in the binding tab though. Maybe this is the issue
you had. If you can email me the report you had issues with I can tell
you what the issue was. My email address is jasonweathersby at
windstream dot net.

Jason

On 1/31/2011 4:20 PM, Jim Garrison wrote:
> I started over again from a blank report, and this time placing the
> chart in the group footer seems to work.
> I guess the BIRT designer gets confused if you move stuff around too
> much....

Previous Topic:	Best practices to compute a rate from absolute data
Next Topic:	BIRT update site referencing missing version of org.eclipse.emf.common?

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 01:06:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter