Merge rows for SubReport.

Stimulsoft Reports.NET discussion
Post Reply
Phi Phi
Posts: 3
Joined: Fri Dec 27, 2013 6:41 am

Merge rows for SubReport.

Post 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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Merge rows for SubReport.

Post by Alex K. »

Hello,

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

Thank you.
Phi Phi
Posts: 3
Joined: Fri Dec 27, 2013 6:41 am

Re: Merge rows for SubReport.

Post by Phi Phi »

Hi I tried but it didn't work for SubReport.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Merge rows for SubReport.

Post 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.
Phi Phi
Posts: 3
Joined: Fri Dec 27, 2013 6:41 am

Re: Merge rows for SubReport.

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Merge rows for SubReport.

Post by Alex K. »

Hello,

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

Thank you.
Post Reply