Need grouping + crossdata

Stimulsoft Reports.NET discussion
Post Reply
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Need grouping + crossdata

Post by Jennypi »

Hi Stimulsoft team,

I'm struggling with a report design.
I have 2 datasources, one field ("Plot") being common and the number of "FieldsX" changing all the time in each datasource.
Screenshot_1.png
Screenshot_1.png (17.56 KiB) Viewed 2451 times
I'm trying to get following layout
Screenshot_2.png
Screenshot_2.png (13.05 KiB) Viewed 2451 times
I tried many kind of designs, using Group bands, Crossdata bands, crosstabs... none of them give me the expected results.
How would you do obtain such a result?

Many thanks for your help. Attached the sample data.
Attachments
report_data.xlsx
(10.16 KiB) Downloaded 144 times
Screenshot_2.png
Screenshot_2.png (13.05 KiB) Viewed 2451 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
ReportSample.mrt
(28.78 KiB) Downloaded 175 times
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Re: Need grouping + crossdata

Post by Jennypi »

Hi,

It works great, thank you so much!
Just one thing: it may happen that not all the fields are filled in for one plant.
For example, in this second example, you can see that plant 1 is not scored for field 6, and plant 2 is not scored for field 4. Still, all the headers shows up in the main header row.
Is there a way to do that? Crosstab maybe?

Thank you!
Attachments
Screenshot_1.png
Screenshot_1.png (48.42 KiB) Viewed 2403 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski »

Hello,

In that case, you can make the following steps:
- add an additional data source with only grouped headers for Plant - Field5, Field6, Field7, etc
- and use it as master Cross-Data and for each plant use filtering
- add two groups blocks - one for headers, second - for data.

Thank you.
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Re: Need grouping + crossdata

Post by Jennypi »

Thank you for your reply, but I'm not sure I understand your instructions, sorry... do you mind setting a quick sample report?
I'm joining my report, even though I'm not sure it's useful to you without data sample.

Many thanks for your help.
Attachments
Field book draft.mrt
(99.6 KiB) Downloaded 136 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski »

Hello,

We need some time to prepare a sample for you.

Thank you.
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Re: Need grouping + crossdata

Post by Jennypi »

Thank you very much to take this time to help me.
Looking forward to learning from your sample.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski »

Hello,

please check the modified report.

Thank you.
Attachments
ReportSample2.mrt
(31.82 KiB) Downloaded 179 times
Post Reply