Disable group still groups items in nested group

[fuhrj]

I have a nested group that looks like this:

Group 1: Payment Type
Group 2: Product ID

There is a form that allows the user to indicate if they want to group by payment type and disable/enable Group 1 in form code:

Code: Select all

if (!chkGroupByPayment) {
GroupHeaderBand1.Enabled = false;
GroupFooterBand1.Enabled = false;
}

The problem I am having is that if Group 1 is disabled, it still groups by Payment Type.

The resulting output looks like this:

ORDER 1001 PRODUCT ABC123 PAY: Cash

Total for ABC123: 1

ORDER 1002 PRODUCT ABC123 PAY: Credit Card

Total for ABC123: 1

If Group 1 is disabled, it should only group by Product ID and look like this:

ORDER 1001 PRODUCT ABC123 PAY: Cash
ORDER 1002 PRODUCT ABC123 PAY: Credit Card

Total for ABC123: 2

How can I disable Group 1 so that it's grouping option is ignored and only Group 2 is active?

[Ivan]

Hello,

Can you please send us a sample report template with data, which reproduces the issue?

Thank you.

[fuhrj]

Hello,

Can you please send us a sample report template with data, which reproduces the issue?

Thank you.

I've attached the report to my original post.

Thanks!

[Ivan]

Hello,

Sorry, can you provide data for your report, which reproduces the issue?
We couldn't reproduce this bug on our data.

Thank you.

[fuhrj]

Hello,

Sorry, can you provide data for your report, which reproduces the issue?
We couldn't reproduce this bug on our data.

Thank you.

I uploaded a test database that you can run the report against.

[Ivan]

Hello,

The issue is confirmed.
Unfortunately, this behavior of the GroupHeader is by design, and we do not plan to change it.
As a workaround, please check the report sample in the attachment.

Thank you.

[fuhrj]

Ok, thanks.

I'll take a look at the workaround.

[Andrew]

Hello,

Ok!

Let us know about the result.
Thank you.