Report not grouping query data properly

[maloner]

Hello all,

I am quickly running out of hair to pull out because of this bizarre problem I'm getting. I have a fairly complex query (based off multiple other queries) that, for all that went into making it, is properly pulling the data I need in query view.

BUT...when I pull it into a report and try to group it, I wind up with an insane jumble. Basically I'm trying to show a course catalog arranged by start date, only the report isn't grouping on start date properly. I got confused by the results so I dropped a start date field into both the header and detail section to see if it was just skipping dates, and this is what I get -- it's grouping by start date, but then putting multiple start dates UNDER THAT DATE. And no, there are not multiple start date fields that could be causing this through some messed up relationships.

I'm attaching a screenshot of the design and the jumbled output for reference. As weird as this problem is, I'm hoping someone has seen something like this before?

 

[vbaInet]

I don't understand.

If you're grouping by start date, why put it in the Detail section too?

 

[maloner]

Strictly to figure out why all of my start dates weren't showing. It was error checking, and that's how I found out that they were being grouped improperly. Once I get the report working properly, I'll remove that field from the detail section, but for now, it clearly shows that the report grouping isn't working.

 

[vbaInet]

I suspect you have other Grouping in place. If you first want to Group By date, then it must come first in the list of the report Groupings.

 

[maloner]

There is other grouping, by course number, but that isn't the problem because I want a list of all start dates by course number. Why are multiple start dates being grouped on a single start date level? That is the issue.

But, just to test, I removed the course number grouping and ran the report without ANY grouping beyond start date, and I get the same jumbled results.

 

[boblarson]

Let's see a screenshot of your Sorting And Grouping dialog.

 

[maloner]

Let's see a screenshot of your Sorting And Grouping dialog.

Sure, here you go. Note that the report is particularly useless at the moment since I removed all fields unrelated to this issue in an effort to eliminate them as a possible source of error.

 

[boblarson]

Sorry to do this to you but there is the MORE button that needs to be expanded. The reason I am saying this, is that your grouping (based on your screenshots) appears to be grouped by QUARTER and so if you click on the MORE > on the grouping, you might find that BY QUARTER is selected instead of BY DAY. I just tested and it seems that BY QUARTER is the default (for whatever reason) when you add the grouping on the report for a date.

 

[maloner]

Ugh, thank you. That fixed it. I'm going to go flog myself in the parking lot now.

 

[Brianwarnock]

I hate you Bob

I looked at this and thought its grouping by quarter, No it can't be he hasn't asked for that, is this another quirk of 2007, and maybe 2010, neither of which I have, things appear to be going backward.

I'm even more glad I'm retired.

Brian

 

[boblarson]

I'm even more glad I'm retired.

I wish I could be.