Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Aggregation Issues
Aggregation Issues [message #1783538] Tue, 13 March 2018 21:02 Go to next message
Tyler Chessum is currently offline Tyler ChessumFriend
Messages: 5
Registered: March 2018
Junior Member
I am developing a report that requires me to aggregate a certain columns information.

Order ODTEXT

123456 WINDOW
123456 100X20
123456 WHITE
123456 NEEDS GRIDS
123456 4FF
123456 (SP) CL
123456 (SP) LE


I Aggregated the ODTEXT column but it is still giving me 7 instances of the following results.

123456 WINDOW
100X20
WHITE
NEEDS GRIDS
4FF
(SP) CL
(SP) LE

123456 WINDOW
100X20
WHITE
NEEDS GRIDS
4FF
(SP) CL
(SP) LE

123456 WINDOW
100X20
WHITE
NEEDS GRIDS
4FF
(SP) CL
(SP) LE

and so on and so on

Is it possible to have the Order # only show up once and all the ODTEXT that are associated with said Order # only show up once?

Also, I am using select distinct, but I believe it is giving me an answer to go with each row of the ODTEXT.

Any assistance would be greatly appreciated!
Re: Aggregation Issues [message #1783602 is a reply to message #1783538] Wed, 14 March 2018 14:21 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 212
Registered: July 2009
Location: Houston TX
Senior Member

You need to clarify for us. What is in column ODTEXT in the actual database table?
Is it:
123456 WINDOW
123456 100X20
123456 WHITE
123456 NEEDS GRIDS
123456 4FF
123456 (SP) CL
123456 (SP) LE

or is it:
WINDOW
100X20
WHITE
NEEDS GRIDS
4FF
(SP) CL
(SP) LE

and the 123456 comes from some other column?
Re: Aggregation Issues [message #1783614 is a reply to message #1783602] Wed, 14 March 2018 15:24 Go to previous message
Tyler Chessum is currently offline Tyler ChessumFriend
Messages: 5
Registered: March 2018
Junior Member
The information in the ODTEXT column is

WINDOW
100X20
WHITE
NEEDS GRIDS
4FF
(SP) CL
(SP) LE

and the 123456 is its own separate column. The Order column.

[Updated on: Thu, 15 March 2018 21:29]

Report message to a moderator

Previous Topic:Encoding UTf-8 on birtviewer server
Next Topic:BIRT XML Data Source tutorial
Goto Forum:
  


Current Time: Tue Sep 25 08:59:34 GMT 2018

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

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

Back to the top