How to group the duplicates?

Stimulsoft Reports.NET discussion
jjthed
Posts: 15
Joined: Mon Jul 07, 2014 11:36 pm

How to group the duplicates?

Post by jjthed »

Hello,

I have a question regarding the grouping of the same item. I am trying to show the quantity of the same product and the cost of it, please help me how can I achieve that result.

Here is an example for my questions: (below is what my report looks like)

ItemName size quantity length unitPrice cost %ofCost

Handle

Handle 9 X 12 1 3' $ 2 $ 2 10%
Handle 9X12 2 4' $ 2 $4 12%
Handle 5X6 1 5' $ 1 $1 5%

Door

Door 10X5 2 5' $20 $ 40 20%
Door 10x5 1 6' $20 $ 20 15%

**********************************************************************************************************

This is what I want my report looks like:

ItemName size quantity length unitPrice cost %ofCost

Handle

Handle 9 X 12 3 7' $ 2 $ 6 22%
Handle 5X6 1 5' $ 1 $1 5%

Door

Door 10X5 3 11' $20 $ 60 35%


The report is categorized by the item, and within each item, all the same size are combined into one row with the quantity, length, cost and % of cost combined according to the same size of the item.

Please advise? Thanks!!
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to group the duplicates?

Post by HighAley »

Hello.

You could calculate sum on the Group Header and percentage with total sum.
Please, look at the attached report template.
Report.mrt
(25.88 KiB) Downloaded 289 times
Thank you.
jjthed
Posts: 15
Joined: Mon Jul 07, 2014 11:36 pm

Re: How to group the duplicates?

Post by jjthed »

Thanks for the reply, but I can't seem to preview your report. Can you give me the instructions on that? Thanks!
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to group the duplicates?

Post by Alex K. »

Hello,

Please try to use the our Demo xml files from installation pack.

Thank you.
Attachments
Demo.zip
(479.76 KiB) Downloaded 281 times
jjthed
Posts: 15
Joined: Mon Jul 07, 2014 11:36 pm

Re: How to group the duplicates?

Post by jjthed »

H Aleksey,

Thanks for the demo file, I saw the sample report that you showed me. It seems my report is a bit more complicated then that. I've already got them sorted and grouped, but my report need to have two groups. 1. is to have them categorized into different types. 2. within each type, the same size is grouped together. Please see the sample I made in excel, the top is what I have now, and the bottom with highlights is what I want it to look like. Please advise me how to make grouping within a group.

Thanks!!
Attachments
sample.xlsx
(9.59 KiB) Downloaded 266 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to group the duplicates?

Post by Alex K. »

Hello,

Please try to use the group by Type and Size fields in one GroupHeaderBand.

Thank you.
jjthed
Posts: 15
Joined: Mon Jul 07, 2014 11:36 pm

Re: How to group the duplicates?

Post by jjthed »

Thanks, but can you tell me how to write the expression on how to group both type and size in one GroupHeaderBand?

Sorry, I am very new to this.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to group the duplicates?

Post by Alex K. »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
sample1.xlsx
(8.71 KiB) Downloaded 280 times
SampleReport.mrt
(16.88 KiB) Downloaded 538 times
Capture.PNG
Capture.PNG (10.96 KiB) Viewed 3164 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to group the duplicates?

Post by HighAley »

Hello.

You should just add one more Group Header to your report. Like in the attached our sample.

Thank you.
Attachments
Report.mrt
(27.46 KiB) Downloaded 278 times
jjthed
Posts: 15
Joined: Mon Jul 07, 2014 11:36 pm

Re: How to group the duplicates?

Post by jjthed »

I got it!!!!!!!!! THANK YOU THANK YOU THANK YOU!!!!! :D
Post Reply