Need some help with groups
Need some help with groups
Hello,
I'm joining a report as well as data sample (please adapt the path for the datasource)
I'm having problems to display one label per plot2+plant2 (sometimes plant is empty) and then one label for each combination of plot1*plot2
What I would like to display are labels in this order:
2681
2681*2650
2682.1
2682.2
2682.3
2682.5
2682.6
2690.1*2682.1
2697.1*2682.1
2684.1*2682.2
2691.1*2682.2
2685.1*2682.3
2692.1*2682.5
2687.1*2682.5
2694.1*2682.6
2683
2695*2683
2684.1
2684.2
2696.1*2684.1
2697.1*2684.1
2698.1*2684.2
2699.1*2684.2
Hope it's clear.
Is it possible to do that?
Thanks!
I'm joining a report as well as data sample (please adapt the path for the datasource)
I'm having problems to display one label per plot2+plant2 (sometimes plant is empty) and then one label for each combination of plot1*plot2
What I would like to display are labels in this order:
2681
2681*2650
2682.1
2682.2
2682.3
2682.5
2682.6
2690.1*2682.1
2697.1*2682.1
2684.1*2682.2
2691.1*2682.2
2685.1*2682.3
2692.1*2682.5
2687.1*2682.5
2694.1*2682.6
2683
2695*2683
2684.1
2684.2
2696.1*2684.1
2697.1*2684.1
2698.1*2684.2
2699.1*2684.2
Hope it's clear.
Is it possible to do that?
Thanks!
- Attachments
-
- Classeur13.xlsx
- (8.67 KiB) Downloaded 108 times
-
- Report.mrt
- (268.5 KiB) Downloaded 109 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Need some help with groups
Hello,
Sorry, maybe we did not exactly understand your logic. Could you explain your issue in more details?
Thank you.
Sorry, maybe we did not exactly understand your logic. Could you explain your issue in more details?
Thank you.
Re: Need some help with groups
I don't know what I can explain more.
I attached a report as well as data sample.
Because I group by plot2 + plant2, you can see that data are printed out that way:
2681
2681*2650
2682.1
2690.1*2682.1
2697.1*2682.1
2682.2
2684.1*2682.2
2691.1*2682.2
2682.3
2685.1*2682.3
2682.5
2692.1*2682.5
2687.1*2682.5
2682.6
2694.1*2682.6
2683
2695*2683
2684.1
2696.1*2684.1
2697.1*2684.1
2684.2
2698.1*2684.2
2699.1*2684.2
Instead of that, I would like all the plant2 groupped together for one plot2, followed by the couples plot1.plant1 * plot 2.plant2:
2681
2681*2650
2682.1
2682.2
2682.3
2682.5
2682.6
2690.1*2682.1
2697.1*2682.1
2684.1*2682.2
2691.1*2682.2
2685.1*2682.3
2692.1*2682.5
2687.1*2682.5
2694.1*2682.6
2683
2695*2683
2684.1
2684.2
2696.1*2684.1
2697.1*2684.1
2698.1*2684.2
2699.1*2684.2
Is it clearer?
thank you.
I attached a report as well as data sample.
Because I group by plot2 + plant2, you can see that data are printed out that way:
2681
2681*2650
2682.1
2690.1*2682.1
2697.1*2682.1
2682.2
2684.1*2682.2
2691.1*2682.2
2682.3
2685.1*2682.3
2682.5
2692.1*2682.5
2687.1*2682.5
2682.6
2694.1*2682.6
2683
2695*2683
2684.1
2696.1*2684.1
2697.1*2684.1
2684.2
2698.1*2684.2
2699.1*2684.2
Instead of that, I would like all the plant2 groupped together for one plot2, followed by the couples plot1.plant1 * plot 2.plant2:
2681
2681*2650
2682.1
2682.2
2682.3
2682.5
2682.6
2690.1*2682.1
2697.1*2682.1
2684.1*2682.2
2691.1*2682.2
2685.1*2682.3
2692.1*2682.5
2687.1*2682.5
2694.1*2682.6
2683
2695*2683
2684.1
2684.2
2696.1*2684.1
2697.1*2684.1
2698.1*2684.2
2699.1*2684.2
Is it clearer?
thank you.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Need some help with groups
Hello,
Unfortunately, only with GroupHeaderBands, it is not possible. You structure and logic are not enough for grouping. You should add an additional column which will contain a necessary order for grouping.
Thank you.
Unfortunately, only with GroupHeaderBands, it is not possible. You structure and logic are not enough for grouping. You should add an additional column which will contain a necessary order for grouping.
Thank you.
Re: Need some help with groups
Hello,
Would it be possible to help me with setting up such a design? Can you provide me with a simple example which would group as I want?
My user is awaiting for this change which would make her work easier, but unfortunately I'm not enough an expert to satisfy her needs
Thank you for your help.
Would it be possible to help me with setting up such a design? Can you provide me with a simple example which would group as I want?
My user is awaiting for this change which would make her work easier, but unfortunately I'm not enough an expert to satisfy her needs
Thank you for your help.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Need some help with groups
Hello,
Directly, in the designer, it is not possible.
You structure and logic are not enough for grouping. You should add an additional column in your data source which will contain a necessary order for grouping.
Thank you.
Directly, in the designer, it is not possible.
You structure and logic are not enough for grouping. You should add an additional column in your data source which will contain a necessary order for grouping.
Thank you.
Re: Need some help with groups
Hello,
I'm very sad and disapointed that you cannot help me further. This forum used to be much more helpful. I feel like non-coding users are left on their own, with limited functionnalities.
I'm very sad and disapointed that you cannot help me further. This forum used to be much more helpful. I feel like non-coding users are left on their own, with limited functionnalities.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Need some help with groups
Hello,
Without modification data it is not possible. Please check report with modified data.
Thank you.
Without modification data it is not possible. Please check report with modified data.
Thank you.
- Attachments
-
- Capture.PNG (108.88 KiB) Viewed 2073 times
-
- Report.mrt
- (19.83 KiB) Downloaded 98 times