Need grouping + crossdata

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

Need grouping + crossdata

Post by Jennypi » Fri Jun 21, 2019 3:48 pm

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 452 times
I'm trying to get following layout
Screenshot_2.png
Screenshot_2.png (13.05 KiB) Viewed 452 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 16 times
Screenshot_2.png
Screenshot_2.png (13.05 KiB) Viewed 452 times
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski » Tue Jun 25, 2019 11:06 pm

Hello,

Please check the sample report in the attachment.

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

Re: Need grouping + crossdata

Post by Jennypi » Wed Jun 26, 2019 10:19 am

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 404 times
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski » Thu Jun 27, 2019 9:31 pm

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: 347
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Re: Need grouping + crossdata

Post by Jennypi » Fri Jun 28, 2019 10:20 am

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 14 times
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Need grouping + crossdata

Post by Lech Kulikowski » Wed Jul 03, 2019 10:45 pm

Hello,

We need some time to prepare a sample for you.

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

Re: Need grouping + crossdata

Post by Jennypi » Thu Jul 04, 2019 7:02 am

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

Re: Need grouping + crossdata

Post by Lech Kulikowski » Tue Jul 09, 2019 9:37 pm

Hello,

please check the modified report.

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