How to turn off Grouping from report form

[fuhrj]

I have two groups set up in my report:

Queue
Date

I created a Form and added two checkboxes that allow the user to choose how the data should be grouped.

The form code looks like this:

Code: Select all

if (groupQueue.Checked) {
	GroupHeader_Queue.Enabled = true;
	GroupFooter_Queue.Enabled = true;
} else {
	GroupHeader_Queue.Enabled = false;
	GroupFooter_Queue.Enabled = false;
}

if (groupDate.Checked) {
	GroupHeader_Date.Enabled = true;
	GroupFooter_Date.Enabled = true;
} else {
                GroupHeader_Date.Enabled = false;
	GroupFooter_Date.Enabled = false;
}

If I only choose group by queue and not by date, it still groups by date. The result looks like this:

Queue Name Count
Customer Complaints 10
Customer Complaints 15

The queue 'Customer Complaints' should only appear once with a total count of 25. It is breaking it into two separate lines because there are two dates involved.

Is there something else I need to activate/deactivate to control groups?

[Edward]

Hi

Please add this expression to the group condition which must be turned off/on:

groupQueue.Checked

Thank you.