Page 1 of 1

How to turn off Grouping from report form

Posted: Mon Nov 30, 2009 10:14 am
by 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?

How to turn off Grouping from report form

Posted: Mon Nov 30, 2009 4:59 pm
by Edward
Hi

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

groupQueue.Checked

Thank you.