Creating reports and dashboards | Stimulsoft community forum

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.

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.

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

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

Tim S.

Hello,

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

Thank you.

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.

Hello,

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

Thank you.

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.

Hello,

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

Thank you.

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.

Hello,

Please check the modified report in attachment.

Thank you.