Repeat data band twice (grouped)
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Repeat data band twice (grouped)
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.
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.
Re: Repeat data band twice (grouped)
Hello,
You can use the master with two details report.
Please send us your report with test data for analysis.
Thank you.
You can use the master with two details report.
Please send us your report with test data for analysis.
Thank you.
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Repeat data band twice (grouped)
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.
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.
- Attachments
-
- Stimulsoft.zip
- (2.19 KiB) Downloaded 381 times
Re: Repeat data band twice (grouped)
Hello,
As a way, in this case you can use the additional datasources.
Please check the modified report in attachment.
Thank you.
As a way, in this case you can use the additional datasources.
Please check the modified report in attachment.
Thank you.
- Attachments
-
- Report_modified.mrt
- (12.25 KiB) Downloaded 900 times
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Repeat data band twice (grouped)
Solved using "data from existing datasource", thank you.
Re: Repeat data band twice (grouped)
Hello.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.