Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Multiple charts on single report - data-driven?
Multiple charts on single report - data-driven? [message #651312] Fri, 28 January 2011 21:40 Go to next message
Jim Garrison is currently offline Jim Garrison
Messages: 57
Registered: July 2009
Member
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 16:43 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 19:41 Go to previous messageGo to next message
Jim Garrison is currently offline Jim Garrison
Messages: 57
Registered: July 2009
Member
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 19:42]

Report message to a moderator

Re: Multiple charts on single report - data-driven? [message #651610 is a reply to message #651596] Mon, 31 January 2011 21:20 Go to previous messageGo to next message
Jim Garrison is currently offline Jim Garrison
Messages: 57
Registered: July 2009
Member
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 17:25 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Tue Sep 16 15:32:39 GMT 2014

Powered by FUDForum. Page generated in 0.01651 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software