Repeat data band twice (grouped)

Stimulsoft Reports.NET discussion
Post Reply
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Repeat data band twice (grouped)

Post by Fabio Pagano »

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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Repeat data band twice (grouped)

Post by Alex K. »

Hello,

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

Thank you.
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Repeat data band twice (grouped)

Post by Fabio Pagano »

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:

Image

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":

Image

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):

Image

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

Image

Thank you.
Attachments
Stimulsoft.zip
(2.19 KiB) Downloaded 380 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Repeat data band twice (grouped)

Post by Alex K. »

Hello,

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 899 times
User avatar
Fabio Pagano
Posts: 355
Joined: Mon Apr 16, 2007 12:38 pm
Location: Bari (Italy)

Re: Repeat data band twice (grouped)

Post by Fabio Pagano »

Solved using "data from existing datasource", thank you.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Repeat data band twice (grouped)

Post by HighAley »

Hello.

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

Thank you.
Post Reply