Eclipse Community Forums: BIRT » Can we use group by on combination of two rows?

Home

Home » Archived » BIRT » Can we use group by on combination of two rows?

Can we use group by on combination of two rows? [message #1602770]

Thu, 05 February 2015 15:01

Eclipse User

In groups
Can we use group by on combination of two rows?

Re: Can we use group by on combination of two rows? [message #1602819 is a reply to message #1602770]

Thu, 05 February 2015 15:45

Eclipse User

Combination of rows? or columns? If you mean by two column values, yes, there's an expression option for the group on value. If you mean row, could you explain a little more?

Re: Can we use group by on combination of two rows? [message #1602896 is a reply to message #1602819]

Thu, 05 February 2015 16:55

Eclipse User

Michael Williams wrote on Thu, 05 February 2015 20:45

Combination of rows? or columns? If you mean by two column values, yes, there's an expression option for the group on value. If you mean row, could you explain a little more?

sorry its column grouping.

What should i use between two columns? row["column1"]+row["column2"]

Re: Can we use group by on combination of two rows? [message #1602897 is a reply to message #1602896]

Thu, 05 February 2015 16:58

Eclipse User

Yeah. You'd just click the expression builder for the group value and enter whatever way makes sense to combine them. If it's possible that a combination of the two could be repeated improperly, say you have data like:

Column1 | Column2
A | AA
AA | A

what you're wanting to use wouldn't work, it'd be better to do something like: row["field1"] + "_" + row["field2"] or something like that.

Previous Topic:	Can you help me? Myeclipse Birt Designer Error
Next Topic:	Cannot call a function when creating a dataset

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Mar 25 05:43:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter