Grouping Report by Date

[dmyoungsal]

on my report, I want to group the lines by date.

I have:

Page Header
Entry Date Header
Detail
Page Footer
Report Footer

I want the report to show the "entry date" and have all lines related to that date grouped under.

When I print the report, I get the date on one line and the detail of the first record on the next line.
The third line is the same date and the fourth line is the next detail record.

etc, etc, etc...

My Group By settings are:
Group By = Entry Date, A on Top, by Entire Value, with no totals, with title (blank)
with a Header section, without a footer section, keep whole group together on one page.

Obviously there is a setting I am missing.

Thank you, Mark

 

[pbaldy]

If I had to guess, your dates have a time component. You can try adding the DateValue() in the report's source query to isolate the date.

 

[dmyoungsal]

If I had to guess, your dates have a time component. You can try adding the DateValue() in the report's source query to isolate the date.

Just as your response came in, I had solved the problem.

My issue was that my report originally had two sorts and the report worked just like I needed it to. This morning I added the "group by" and it appeared under the sorts.

I solved it by removing the entries in the Sort and Group section and recreated them putting the Group By first and then the sorts next. It all is good now.

Thank you for responding.

 

[pbaldy]

Glad you got it sorted out.