Process Duplicate with condition

Stimulsoft Reports.NET discussion
WilliamCcy
Posts: 10
Joined: Sat Jul 21, 2007 6:18 am
Location: Malaysia,KL

Process Duplicate with condition

Post by WilliamCcy »

Dear All,

Currently, im using process duplicate to merge the duplicate information.
I would like to "Merge" or "Merge, base on some condition". Below is the result on my design.

Purchase No Supplier Item
0001 AAA Keyboard
Mouse
Monitor
0002 Hard Disk
Ram

=========================================
But i want the result which look like below.


Purchase No Supplier Item
0001 AAA Keyboard
Mouse
Monitor
0002 AAA Hard Disk
Ram

i would like the show the supplier name when the purchase no is change. Any Suggestion??



Regards
WilliamCcy

Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Process Duplicate with condition

Post by Edward »

Please use the Processing Duplicates property of the text component to merge repeated columns.
If it doesn't help then please describe your task in more detail.

Thank you.
ptabkra
Posts: 27
Joined: Tue Oct 16, 2007 10:33 pm

Process Duplicate with condition

Post by ptabkra »

Hi All,

I'm browsing on related forum topics about Processing Duplicates and I got this one. Had this been solved already?
Anyway, the scenario on the report im doing is similar with this one where the required output is this:

Code: Select all

Item No  Description      Other Details
01          AA                  123/158
            AA                  234/654
02          BB                  345/321
03          AA                  123/127
That is, Merge the same description ONLY under the same Item No.
I'm using 1 data band and 1 datasource only.
And using Processing Duplicates = merge on the textfield (on Description field), I got:

Code: Select all

Item No  Description      Other Details
01           AA                  123/158
                                 234/654
02           BB                  345/321
03                               123/127
Suggestions please.. anyone?

Thanks in advance.
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Process Duplicate with condition

Post by Edward »

It is not a correct behavior. Could you please send to support[at]stimulsoft.com a mdc file of your rendered report (click save button for storing in the preview window).

Also please include a mrt file as well.

Thank you.
ptabkra
Posts: 27
Joined: Tue Oct 16, 2007 10:33 pm

Process Duplicate with condition

Post by ptabkra »

Hi Edward, I just found the solution --> Processing Duplicates = Hide did it fine. :) Thanks.
ptabkra
Posts: 27
Joined: Tue Oct 16, 2007 10:33 pm

Process Duplicate with condition

Post by ptabkra »

So it's like "hide" duplicate rows under the same Item No and not "merge".
ptabkra
Posts: 27
Joined: Tue Oct 16, 2007 10:33 pm

Process Duplicate with condition

Post by ptabkra »

oh sorry, i've got a new set of test data and at Processing Duplicates = Hide, i realized that it doesnt behaved correctly. i've got the same output when i first raised this issue :(
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Process Duplicate with condition

Post by Edward »

Could you please send a sample report with data to support[at]stimulsoft.com (in any suitable to you format) for analyzing of the issue you'd met?

Thank you.
ptabkra
Posts: 27
Joined: Tue Oct 16, 2007 10:33 pm

Process Duplicate with condition

Post by ptabkra »

Hi,
I have sent the files relating to this issue at support[at]stimulsoft.com.
Please let us know on how your investigation goes.

Thanks.
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Process Duplicate with condition

Post by Edward »

Here is the result your are requested. Please download it and open in the Demo.exe sample application.

Thank you.
Attachments
34.ManuallyProcessingDuplicates.zip
(2.6 KiB) Downloaded 1030 times
Post Reply