Eclipse Community Forums: BIRT » Chart with GROUPING KEY and INCOMPLETE data

Home » Archived » BIRT » Chart with GROUPING KEY and INCOMPLETE data

Chart with GROUPING KEY and INCOMPLETE data [message #77417]

Wed, 28 September 2005 03:34

Eclipse User

Hi
I would like to render a bar chart like it is explained in
section "Creating a basic chart" of the manual.

Unfortunately my data isn't as complete as in the example.
In the example the following data is used:

Year City Population
1980 Los Angeles 3485398
1980 Chicago 2783726
1980 New York 7322564
1990 Los Angeles 4694820
1990 Chicago 3196016
1990 New York 8008278

But the data in my database would look like this (last row missing):

Year City Population
1980 Los Angeles 3485398
1980 Chicago 2783726
1980 New York 7322564
1990 Los Angeles 4694820
1990 Chicago 3196016

So when I try to create the report I get the following error message:

There are errors on the report page:
+ There are error(s) in Chart:null
Error0 : Error.ExtendedItemRenderingError(1 time)
detail: There are problems(s) rendering Chart extended item .
$NO-RB$ Mismatch (7!=8) in dataset count found in stacked runtime series
Mismatch (7!=8) in dataset count found in stacked runtime series

I don't know how I could change my sql query to return more complete data.
Is there a solution for this? It woul be really nice if the chart
renderer or the data source could add missingg lines with a default value.

For example it could add the row:
1990 New York 0

Cheers, michael

(I'm using BIRT RPC Report Designer, Version 1.0.1 on Windows XP)

Re: Chart with GROUPING KEY and INCOMPLETE data [message #77435 is a reply to message #77417]

Wed, 28 September 2005 08:59

Eclipse User

Hi Michael,

There is already a bugzilla entry for this problem:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=109641

Feel free to add your scenario in the bugzilla entry and add your email in
the CC field to be notified when it gets fixed.

Thanks,

David

"Michael Meyer" <michael.meyer@hplus.ch> wrote in message
news:dhdh2f$5on$1@news.eclipse.org...
> Hi
> I would like to render a bar chart like it is explained in
> section "Creating a basic chart" of the manual.
>
> Unfortunately my data isn't as complete as in the example.
> In the example the following data is used:
>
> Year City Population
> 1980 Los Angeles 3485398
> 1980 Chicago 2783726
> 1980 New York 7322564
> 1990 Los Angeles 4694820
> 1990 Chicago 3196016
> 1990 New York 8008278
>
> But the data in my database would look like this (last row missing):
>
> Year City Population
> 1980 Los Angeles 3485398
> 1980 Chicago 2783726
> 1980 New York 7322564
> 1990 Los Angeles 4694820
> 1990 Chicago 3196016
>
> So when I try to create the report I get the following error message:
>
> There are errors on the report page:
> + There are error(s) in Chart:null
> Error0 : Error.ExtendedItemRenderingError(1 time)
> detail: There are problems(s) rendering Chart extended item .
> $NO-RB$ Mismatch (7!=8) in dataset count found in stacked runtime series
> Mismatch (7!=8) in dataset count found in stacked runtime series
>
>
> I don't know how I could change my sql query to return more complete data.
> Is there a solution for this? It woul be really nice if the chart renderer
> or the data source could add missingg lines with a default value.
>
> For example it could add the row:
> 1990 New York 0
>
> Cheers, michael
>
> (I'm using BIRT RPC Report Designer, Version 1.0.1 on Windows XP)

Previous Topic:	Bug: Queries being executed twice.
Next Topic:	Obtain Script var to pass a java var

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 01:02:36 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter