Having problem with grouping

[cliff7376]

I have two criteria i need to group on. One is a true/false field and the other is a date field. What I want to do is group all the true fields together at the beginning of the report then I want all the false records to group by date. The results i am getting is either all the true fields group with no date grouping or all the date fields group with no true/false grouping. Does anyone have an idea?

 

[Newman]

Just a guess...
Maybe with sub reports?!?!?
In the where statements, use the True/false.
And then group each sub reports by date.

 

[Waltang]

Add a field to the query of your report.

Groupdate: iif([true/falsefield] = true, " ",[datefield])

Then use that field for your grouping.