Page 1 of 1
How to merge objects by property
Posted: Thu Jan 16, 2014 11:13 am
by l.rohrmann
Hi, I've got a set of objects, called Position. Each Position has properties, for example: UnitPrice, Amount and TaxRate. I'd like to get a list, where (specific properties of) all Positions with the same TaxRate get sumarized (UnitPrice*Amount). How is this possible?
Re: How to merge objects by property
Posted: Fri Jan 17, 2014 12:12 pm
by HighAley
Hello.
Sorry, but we don't understand what problem do you have with creating this report.
Could you describe your issue more detailed?
Thank you.
Re: How to merge objects by property
Posted: Fri Jan 17, 2014 12:16 pm
by Alex K.
Hello,
Can you please send us a sample with test data for analysis.
Also please see the samples with business objects in our Demo.
Thank you.
Re: How to merge objects by property
Posted: Fri Jan 17, 2014 3:55 pm
by l.rohrmann
At the moment, i've a table like this:
the first Column = Positions.TaxRate
the second Column = Positions.UnitPrice*Positions.Amount
the third Column = Positions.UnitPrice*Positions.Amount*(Positions.TaxRate/100)
Code: Select all
0% Tax | 150 $ | 0 $
0% Tax | 20 $ | 0 $
5% Tax | 100 $ | 5 $
10% Tax | 250 $ | 25 $
By Processing duplicates only in the column row I get this:
Code: Select all
0% Tax | 150 $ | 0 $
| 20 $ | 0 $
5% Tax | 100 $ | 5 $
10% Tax | 250 $ | 25 $
But what i want is this:
Code: Select all
0% Tax | 170 $ | 0 $
5% Tax | 100 $ | 5 $
10% Tax | 250 $ | 25 $
Also I tried to set the second and third column on "merge based on tag", the result was this:
Code: Select all
0% Tax | 150 $ | 0 $
| |
5% Tax | |
10% Tax | |
Inside the attached File, "Datenband1; Bussinesobject: Positions" the last 3 columns are the relevant ones.
Re: How to merge objects by property
Posted: Mon Jan 20, 2014 7:28 am
by HighAley
Hello
You should use Group Header Band instead of the Processing Duplicates property.
Please, look at the attached report template.
Thank you.