Page 1 of 1

Merge rows for SubReport.

Posted: Fri Dec 27, 2013 7:25 am
by Phi Phi
Hi, I'm working on a report which combines DataSource and some SubReports.
For example:
DataSource: App
Col1.............Col2.................Col3
App.ID......App.Name........Sub Report (Filter Expression: App.ID = Data.ID).
--------------------------------------------------------------
1..............Test......................Data1
............................................Data2
--------------------------------------------------------------
1..............Test......................Data1
............................................Data2

App.ID is not unique so I want to merge it.
It's ok to Col1 and Col2, but I cannot set merge for SubReport.
Col1.....Col2.........Col3
---------------------------------------------------------
1..........Test..........Data1
...........................Data2
...........................--------------------------
...........................Data1
...........................Data2
---------------------------------------------------------

Is there any solution for this case?

Thank you.

Re: Merge rows for SubReport.

Posted: Fri Dec 27, 2013 8:25 am
by Alex K.
Hello,

Please try to use the ProcessingDuplicates property for the Text component.

Thank you.

Re: Merge rows for SubReport.

Posted: Fri Dec 27, 2013 9:12 am
by Phi Phi
Hi I tried but it didn't work for SubReport.

Re: Merge rows for SubReport.

Posted: Fri Dec 27, 2013 9:38 am
by HighAley
Hello.

Please, read the Processing Duplicates section from our User Manual.
If it does not help then send us additional information about your issue.
What our component do you use?
Which version?
Send us your report template with sample data which reproduces the issue.

Thank you.

Re: Merge rows for SubReport.

Posted: Fri Dec 27, 2013 10:39 am
by Phi Phi
Hi,
The other DataSource is included in SubReport (Col3).
I can set Processing Duplicate for the Text component inside the SubReport.
Col1...........Col2................Col3
-------------------------------------------------
..................Test1...............Data1
........................................Data1.....-> These are the data of the SubReport and it can be merged. Only one "Data1" is displayed.
1..............-------------........---------------
..................Test2...............Data1
........................................Data1

You can see, I have two rows with the same App.ID. Col1 can be merged via Processing Duplicate of the Text component.
With Col3, I can only merge the data inside the SubReport:
Col1...........Col2................Col3
-------------------------------------------------
..................Test1...............Data1
........................................
1..............-------------........---------------
..................Test2...............Data1

How to make it look like this:
Col1...........Col2................Col3
-------------------------------------------------
..................Test1...............
1..............-------------............Data1
..................Test2

Re: Merge rows for SubReport.

Posted: Mon Dec 30, 2013 6:58 am
by Alex K.
Hello,

In this case please try to place the data from SubReport to the main page.

Thank you.