Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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: 8
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!

Report message to a moderator

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?

Report message to a moderator

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: 8
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 21:22:06 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly