Group Expression more than 1 field

[2004 IR Help]

By: John Augusto Charnet - jcharnet

Group Expression more than 1 field

2005-05-20 06:51

Hello.

I'd like to have a group expression containing more than 1 field.

I'd like to be able to break my report according to 3 different fields. I know that the group expression accepts a Boolean, and that if I put a field as the expression, it compares oldField with currentField.

How can put more than 1 field ?

 

Thanks a lot.

Sincerely,

John

 

 

 

 

By: Akram BEN AISSI - akram

RE: Group Expression more than 1 field

2005-08-23 00:19

Hello jcharnet, Hello all

 

I am facing the same problem. Did you find the solution ?

I tried do concat my 3 fields, but JR does not accept the groupExpression.

$F{myField1} + " " + $F{myField2} + " " + $F{myField3}

 

I also tried to create a variable and use it in the groupExpression, but it did not work also.

 

Can you help me now ?

 

 

 

 

 

 

By: ATha1 - atha1

RE: Group Expression more than 1 field

2005-08-23 03:05

Have you tried to concat the three fields in a new field by the datasource or the querystring?

 

 

 

 

By: Akram BEN AISSI - akram

RE: Group Expression more than 1 field

2005-08-23 03:44

I want to avoid to do this. Because my data is filled from a view, and I do not have acces to this view.

 

 

 

 

 

 

By: ATha1 - atha1

RE: Group Expression more than 1 field

2005-08-23 04:39

OK, so you use a report query?

 

try

select myField1||' '||myField2||' '||myField3 as groupExpression, and the rest of your Query

 

and then declare a new field with the same name (in this case groupExpression) and then try to make a group around this field.

 

 

 

 

By: jorge - sirion_oef

RE: Group Expression more than 1 field

2005-08-23 16:03

i had the same problem, and i didn't know how to solve it, until now, thaks atha1

 

 

 

 

By: ATha1 - atha1

RE: Group Expression more than 1 field

2005-08-23 23:23

So did that work?

 

I don't know if it should but I guess...

 

 

 

 

By: John Augusto Charnet - jcharnet

RE: Group Expression more than 1 field

2005-08-25 09:00

When I solved my problem with multiple fields break, I did the solution atha1 sugested, and it worked fine.

 

 

 

 

By: Akram BEN AISSI - akram

RE: Group Expression more than 1 field

2005-08-30 07:05

Yes it worked. But this is a workaround. But this work.

 

Thank you.