How to group the duplicates?

[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]

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]

Thanks for the reply, but I can't seem to preview your report. Can you give me the instructions on that? Thanks!

[Alex K.]

Hello,

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

Thank you.

[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!!

[Alex K.]

Hello,

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

Thank you.

[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.]

Hello,

Please check the sample report in the attachment.

Thank you.

[HighAley]

Hello.

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

Thank you.

[jjthed]

I got it!!!!!!!!! THANK YOU THANK YOU THANK YOU!!!!!