Eclipse Community Forums: BIRT » Exception in a Lib with a Table using group & aggregation

Home » Archived » BIRT » Exception in a Lib with a Table using group & aggregation

Exception in a Lib with a Table using group & aggregation [message #640599]

Mon, 22 November 2010 10:23

Eclipse User

Hello,

On a report I made table with a group (bases on a data set computed column). In group Header of my table i make an aggregation Sum on a colomn of my data Set.

Birt 2.6 (Actuate 11)

when I put this on a libarie it does not work anymore. I have an exception saying the group I defined does not exist. I do not understand because it works when it's in the report and not in a library.

ERROR :
Group "groupSreadCommRate" used in column Aggr-Sum-SpreadCommRate-Notional does not exist.

Re: Exception in a Lib with a Table using group & aggregation [message #640679 is a reply to message #640599]

Mon, 22 November 2010 13:57

Eclipse User

Is the dataset in a library?

On 11/22/2010 10:23 AM, Anthony S wrote:
> Hello,
>
> On a report I made table with a group (bases on a data set computed
> column). In group Header of my table i make an aggregation Sum on a
> colomn of my data Set.
> Birt 2.6 (Actuate 11)
>
> when I put this on a libarie it does not work anymore. I have an
> exception saying the group I defined does not exist. I do not understand
> because it works when it's in the report and not in a library.
>
> ERROR : Group "groupSreadCommRate" used in column
> Aggr-Sum-SpreadCommRate-Notional does not exist.
>
>
>
>

Re: Exception in a Lib with a Table using group & aggregation [message #640861 is a reply to message #640679]

Tue, 23 November 2010 06:20

Eclipse User

Yes, Data set is in a library (used several times in my report)
which is used and referenced by my library containing my grid & my table. This library is set in my report.

ReportDesign ----> Grid-TableLibrary ---> DataSetLibrary

Re: Exception in a Lib with a Table using group & aggregation [message #640966 is a reply to message #640599]

Tue, 23 November 2010 12:26

Eclipse User

I made some tests

My library containing my Table using a group with an aggregation is in a Grid :
Library : Grid
Row ---- col ---- Table
Row ---- col ---- (empty : will be filled later)

In this configuration I have an error that group in my Table does not exists.

I tried this : Library : Table (no grid, nothin else)

and it works.

It seems the problem is linked to the fact my Table is embedded in a Grid. Have you ever seen this problem ?

Is there another solution than do not use the Grid and only put directly the Table ?

Re: Exception in a Lib with a Table using group & aggregation [message #640978 is a reply to message #640966]

Tue, 23 November 2010 12:55

Eclipse User

Can you email me the library and the report design? Or preferably build
a library and report off the sample db that shows the problem and post them?

Jason

On 11/23/2010 12:26 PM, Anthony S wrote:
> I made some tests
>
>
> My library containing my Table using a group with an aggregation is in a
> Grid : Library : Grid Row ---- col ---- Table
> Row ---- col ---- (empty : will be filled later)
>
> In this configuration I have an error that group in my Table does not
> exists.
>
> I tried this : Library : Table (no grid, nothin else)
>
> and it works.
>
> It seems the problem is linked to the fact my Table is embedded in a
> Grid. Have you ever seen this problem ?
> Is there another solution than do not use the Grid and only put directly
> the Table ?
>
>

Re: Exception in a Lib with a Table using group & aggregation [message #641004 is a reply to message #640599]

Tue, 23 November 2010 15:17

Eclipse User

For privacy reasons I cannot send my work directly. I have an idea. I can try we the sample database and check if there is the same pb and send you that.

Re: Exception in a Lib with a Table using group & aggregation [message #641121 is a reply to message #641004]

Wed, 24 November 2010 05:28

Eclipse User

I made a report sample using the Birt sample database.

I have also the problem if there is a grid in which I put a table with a group and an aggregation.

In my I made a report design with a simple Grid and two libraries. First library is a Grid containing my table and reproducing the problem. second library is just the table without changing anything : it works.

I do not understand why there is this trouble.

Re: Exception in a Lib with a Table using group & aggregation [message #641122 is a reply to message #641121]

Wed, 24 November 2010 05:31

Eclipse User

Jason, how can I send you by mail, there is no MP button on you profile ? It seemed I cannot (authorization) send mail or MP for this forum.

[Updated on: Wed, 24 November 2010 05:37] by Moderator

Re: Exception in a Lib with a Table using group & aggregation [message #641215 is a reply to message #641122]

Wed, 24 November 2010 09:58

Eclipse User

Can you email it to jasonweathersby at windstream dot net?

On 11/24/2010 5:31 AM, Anthony S wrote:
> Jason Weathersby How can I send you by mail, there is no MP button on
> you profile ?

Re: Exception in a Lib with a Table using group & aggregation [message #641680 is a reply to message #641215]

Fri, 26 November 2010 11:50

Eclipse User

No solution or explanation for the moment. Is it a bug ?

Re: Exception in a Lib with a Table using group & aggregation [message #641878 is a reply to message #641680]

Sun, 28 November 2010 23:31

Eclipse User

I just sent you an email.

Jason

On 11/26/2010 11:50 AM, Anthony S wrote:
> No solution or explanation for the moment. Is it a bug ?

Re: Exception in a Lib with a Table using group & aggregation [message #641933 is a reply to message #641878]

Mon, 29 November 2010 05:05

Eclipse User

Which mail ?
Can you send it again to :
- anthony DOT serfati-ext AT sgcib DOT com
- neozerabbit AT hotmail DOT com

Re: Exception in a Lib with a Table using group & aggregation [message #642027 is a reply to message #641933]

Mon, 29 November 2010 10:29

Eclipse User

I sent it to
anthonyserfati at hotmail dot com
I Tried the jar you sent me ( two report libraries and a report) and ran
it in 2.6.1 and it ran for me. Are you using 2.6.1 or 2.6.0?

Jason

On 11/29/2010 5:05 AM, Anthony S wrote:
> Which mail ?
> Can you send it again to :
> - anthony DOT serfati-ext AT sgcib DOT com
> - neozerabbit AT hotmail DOT com
>
>

Re: Exception in a Lib with a Table using group & aggregation [message #642108 is a reply to message #642027]

Mon, 29 November 2010 16:12

Eclipse User

2.6.0 & 2.6.1

I finaly received it in the afternoon (France).
I do not undersand why you don't have the trouble it is very strange. We have constated it with Birt/Actuate Team.

The following versions are

OPEN SOURCE :
BIRT Chart Framework
Version: 2.6.0.v20100617-7f9T0FQCnv7wz02TTZ0LE1
Build id: v20100609-1613

EMF Mapping
Version: 2.6.0.v20100614-1136
Build id: R201006141136

Eclipse Plug-in Development Environment
Version: 3.6.0.v20100525-7b7mFKtFEx2XmfZ4_B7NUJA
Build id: I20100608-0911

ACTUATE TRIAL VERSION
-------------------------------------
Actuate Open Data Access (ODA) and Adapter
Version : 11.0.0

EMF Mapping
Version: 2.6.0.v20100914-1218
Build id: R201009141218

Eclipse Platform
Version: 3.6.1.r361_v20100909-9gF78GrkFqw7GrsZnvz0JWNTeb6fue6896L
Build id: M20100909-0800

[Updated on: Tue, 30 November 2010 04:07] by Moderator

Re: Exception in a Lib with a Table using group & aggregation [message #642257 is a reply to message #642108]

Tue, 30 November 2010 10:49

Eclipse User

I used 2.6.1 and did not see the issue. Do you have a support case open
with Actuate?

Jason

On 11/29/2010 4:12 PM, Anthony S wrote:
> I finaly received it in the afternoon (France). I do not undersand why
> you don't have the trouble it is very strange. We have constated it with
> Birt/Actuate Team.
>
> The following version are
> OPEN SOURCE : BIRT Chart Framework
> Version: 2.6.0.v20100617-7f9T0FQCnv7wz02TTZ0LE1
> Build id: v20100609-1613
>
> Eclipse Plug-in Development Environment
> Version: 3.6.0.v20100525-7b7mFKtFEx2XmfZ4_B7NUJA
> Build id: I20100608-0911
>
>
> ACTUATE TRIAL VERSION Actuate Open Data Access (ODA) and Adapter Version
> : 11.0.0
>
> Eclipse Platform
> Version: 3.6.1.r361_v20100909-9gF78GrkFqw7GrsZnvz0JWNTeb6fue6896L
> Build id: M20100909-0800
>
>
>

Re: Exception in a Lib with a Table using group & aggregation [message #642289 is a reply to message #642257]

Tue, 30 November 2010 12:11

Eclipse User

No support cas opened for the moment bu some internal discussion bt mail.

We are developping a reporting prototype with Actuate people.

I made the test with Birt 2.5 : it works.

So what next ? It seems this issue is not for all 2.6.0 and 2.6.1.

[Updated on: Tue, 30 November 2010 12:13] by Moderator

Re: Exception in a Lib with a Table using group & aggregation [message #642306 is a reply to message #642289]

Tue, 30 November 2010 12:52

Eclipse User

It would be good if you could get a support case opened for it.

Jason

On 11/30/2010 12:11 PM, Anthony S wrote:
> No support cas opened for the moment bu some internal discussion bt mail.
>
> I made the test with Birt 2.5 : it works.
>
> So what next ? It seems this issue is not for all 2.6.0 and 2.6.1.

Re: Exception in a Lib with a Table using group & aggregation [message #642342 is a reply to message #642306]

Tue, 30 November 2010 15:58

Eclipse User

ok. I need to make someone in Actuate or Birt Resource in order to make it took in count.

Previous Topic:	Is it possible to change BIRT_HOME in birt viewer
Next Topic:	Birt Deployment error - is it a bug?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 13:10:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter