Hello dear DevExpress.
I need to generate table report with two levels of grouping (the top one and the nested one).
This is a simple task using the DevExpress in case the summary info is displayed right after each group using GroupFooterBand (for both top and nested level).
But what if I want to display overview of all nested groups found within one top group AFTER all the details for these nested groups were generated?
The data structure is like:
CodeNAME;DATE;AMOUNT
The wanted report definition is like:
group by [NAME]
group by GetMonth([DATE])
use GroupHeaderBand with DetailBand to show every found nested group and its details
show overview of all individual groups found by GetMonth([DATE])
within [NAME]
+ plus calculate their total
So for following sample data:
CodeNAME;DATE;AMOUNT
Alice;2025-01-07;84
Alice;2025-01-13;65
Alice;2025-01-29;92
Bobby;2025-01-08;95
Bobby;2025-01-22;75
Alice;2025-02-05;88
Alice;2025-02-17;74
Bobby;2025-02-19;92
The resulting report should be like:
Code=================================================
Alice
=================================================
Details for Alice by months:
January 2025
2025-01-07 ... 84
2025-01-13 ... 65
2025-01-29 ... 92
February 2025
2025-02-05 ... 88
2025-02-17 ... 74
-------------------------------------------------
Summary for Alice by months (after the details for Alice by months):
January 2025 ... 241
February 2025 ... 162
-----------------------
Total ... 403
=================================================
Bobby
=================================================
Details for Bobby by months:
January 2025
2025-01-08 ... 95
2025-01-22 ... 75
February 2025
2025-02-19 ... 92
-------------------------------------------------
Summary for Bobby by months (after the details for Bobby by months):
January 2025 ... 170
February 2025 ... 92
-----------------------
Total ... 262
What is the proper way to achieve this behavior?
Duplicate the nested grouping by GetMonth([DATE])
within [NAME]
? Use sub-report? Generate the overview/summary "manually" by my code?
Thank you.