Creating reports and dashboards | Stimulsoft community forum

Hello,
i'm developing a report for a company which sales some articles which are in specified article groups.

My report has to display
- the date
- the customer
- the articlegroup with the amount of sold articles in this group for this day
- a total amount of sold articles for every customer at the end of the customer group (in which are the sold articles)
- and a total amount at the end of the day for every articlegroup which were sold

Now my problem is, that i get in one query all esential information for the first 4 points but now i have to display the total amount of every articlegroup for one day at the end of the active day.
In my second query i tried to get the articlegroups with its total amount of a day and grouped them by the day.
My concern is to display the results of the second query at the end of the day (which is in a group), but this doesn't work because of the upper group isn't connected to the lower one.
So my report shows at the moment all of my grouped articlegroups and their amount at the very end of my report.

I hope somebody has any suggestion how i could solve this problem.

Best regards
ape

Hello.

Please see the 'Master-Detail with Parameters' report in 'SQL' group of reports in the Demo sample application from the standard installation. In that report the relation between Master and Detail was not necessary. The relation has been made with help of parameters. Detail query was reopened each time after rendering of the Master.

If task is still unclear, please send the sample report and data for it to support[at]stimulsoft.com. We could help you with design of the mrt file.

Thank you.