Master Component Grouping

tims · Post by **tims** » Fri Feb 03, 2012 1:52 pm

I have a report that I need to group a component by a couple of fields, then have a list of items below it related to that item. I have it set up with a Master-Component report and it works fine, but I have an issue when there is more than one of the master. The Master is grouped correctly, showing 1 row, with a QTY of 2 and only showing the infomration for the master once. The detail however, is ouput on the report for each. I have the grouping set up on the detail component, but it still repeats multiple times.
I've attached the data, report, and a PDF of the output. As an example, look at the first item. The Drawer Front Solid Wood has a QTY of 2, grouped together, but the individual parts that make up that drawer front are listed out twice. Further down, there is a QTY of 3, grouped, with the detail listed 3 times.

How do I adjust so that in the first example, the detail would list once under each master, allowing me to sum the QTY on the detail to show the total qty of detail parts.

http://dl.dropbox.com/u/2491635/Report%20Files.zip

I appreciate any help you can provide.

Tim S.

Post by **Alex K.** » Tue Feb 07, 2012 8:10 am

Hello,

In your report you uses Microvellum.Globalization.Dll and we can not show the report.
Can you please send us a work or sample report which reproduces the issue for analysis.

Thank you.

tims · Post by **tims** » Thu Feb 09, 2012 9:32 am

I've removed the globalization.dll and it's references.

http://dl.dropbox.com/u/2491635/Subasse ... Report.mrt

Tim S.

Post by **Alex K.** » Fri Feb 10, 2012 8:08 am

Hello,

Can you please check sent database, because in you report you using datasource Projects, which not in database.

Thank you.

tims · Post by **tims** » Fri Feb 10, 2012 8:25 am

I updated the report to remove the reference to projects. Please download again from the report link.
http://dl.dropbox.com/u/2491635/Subasse ... Report.mrt

Sorry for the inconvenience.

Tim S.

Post by **Alex K.** » Mon Feb 13, 2012 4:42 am

Hello,

We check your report and all work correctly.
Please see the attached screenshot (on this screenshot data for your report):

Thank you.

tims · Post by **tims** » Mon Feb 13, 2012 11:10 pm

I agree that the grouping at the Master level you've shown is working correctly. If you look at the Detail component however, it is listing the detail once for each record in the master instead of grouping the detail together. I want the QTY 2 for that first item, but then I only want to see one set of lines showing the Drawer Bottom Rail, Drawer Left Stile, Drawer Right Stile etc.

Tim S.

Post by **Alex K.** » Tue Feb 14, 2012 3:05 am

Hello,

Sorry, maybe we did not exactly understand your question. Can you please send us sample image how it should like look.

Thank you.

tims · Post by **tims** » Tue Feb 14, 2012 8:08 am

See attached. Areas in Red should be not displayed QTY's in Green boxes should be summing the results.

http://screencast.com/t/WzKyNOH7k

Thanks,
Tim S.

Post by **Alex K.** » Thu Feb 16, 2012 1:56 am

Hello,

Please check the modified report in attachment.

Thank you.