Sorting Data on Report

[crhodus]

I'm having a problem with sorting the data in one of my reports. I am using the following query as the record source in my report:

SELECT
Project.project_id, Project.project_name, Project.project_mgr, Project.prioritycode,[Project Info].project_id,[Project Info].employment, [Project Info].company_prod_service, Project_Updates.project_id,Project_Updates.note_date, Project_Updates.update_notes
FROM (Project LEFT JOIN [Project Info] ON Project.project_id = [Project Info].project_id) LEFT JOIN Project_Updates ON Project.project_id = Project_Updates.project_id
ORDER BY Project.project_mgr, Project.project_name, Project_Updates.note_date DESC;


On my report, I have created two header in the Sorting and Grouping popup window:
FIELD/EXPRESSION --> project_mgr
SORTY BY --> ascending
GROUP HEADER -->Yes
GROUP FOOTER --> No
GROUP ON --> Each Value
GROUP INTERVAL --> 1
KEEP TOGETHER --> No
---------------------
FIELD/EXPRESSION --> project_name
SORTY BY --> ascending
GROUP HEADER -->Yes
GROUP FOOTER --> No
GROUP ON --> Each Value
GROUP INTERVAL --> 1
KEEP TOGETHER --> No

I have the project_mgr textbox in the project_mgr header and the project_name textbox int the project_name header.

In the Detail section, I have the note_date and update_notes textboxes.

Everything prints out in the correct order, except for the detail section. The note_date does not print out on the report in descending order. Instead the note_date, are ordered in a random order as far as I can tell.

When I run just the SQL query, it returns data in the correct order.
(BTW note_date is a Date/Time data type)

Can anyone help??

Thanks!

 

[Rich]

You need to use the Sorting/Grouping options to order the date field

 

[crhodus]

Thanks Rich! I was under the assumption that the data would be sorted based on my query. Plus I forgot that (stupid me) that you don't have to create a group header or footer on a report when you use the Sorting & Grouping feature.

Thanks again!