Creating reports and dashboards | Stimulsoft community forum

Good morning. I have the following data source:

ID Customer
Order description
Order notes

For each "ID Customer" i have many rows, eg. of data in data source:

1
"Description order 1"
"Description notes 1"

1
"Description order 2"
"Description notes 2"

2
"Description order 3"
"Description notes 3"

I need to print:

Customer 1:
Description order 1
Description order 2
Description notes 1
Description notes 2

Customer 2:
Description order 3
Description notes 3

As you can see, i need to group by ID Customer then print all its "Description order" and then all its "Description notes".

May you help on how to do this?

Thank you.

Hello,

You can use the master with two details report.
Please send us your report with test data for analysis.

Thank you.

Attached is sample report and xml data: save it in the folder "c:\stimulsoft".

As above said, i have a flat datasource that contains an "ID Customer", a "Description order" and a "Description notes". I can have many rows with the same "ID Customer".

This is the example datasource:



I need to print it grouped by "ID Customer": for each customer i need to print all his "Description order" and, after, all his "Description notes":



I have designed the group header, two data bands (one with field "Description order" and one with field "Description notes") and the group footer, but the result was not what i wanted (it's printed the group for the first data band "Description order" then are printed all "Description notes" for all customers):



This is the design, grouped by "ID Customer":



Thank you.

Hello,

As a way, in this case you can use the additional datasources.
Please check the modified report in attachment.

Thank you.

Solved using "data from existing datasource", thank you.

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.