Query filter not working in report (1 Viewer)

S

Shirley

Guest
I created a report based on a query which has sorting criteria set for three fields - Country, State, and Company Name - in that heirarchy in ascending order. When I run the query, the sort order works fine, but when I open the report, all records are sorted on the Company Name field in ascending order (which is the first field in the report). I've checked report parameters and the Order By field seems to have the right expression in there and Order By On is set to Yes. Does anyone know how I can get the report to use the query filter for sorting?

Thanks in advance.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:34
Joined
Feb 19, 2002
Messages
42,970
The parameters set in the report's sorting and grouping properties override any sort sequence specified in the query. Change the report.
 
S

Shirley

Guest
I tried resetting the report's grouping and sorting parameters but when I do, I end up with only 4 records (there should be over 200) - 1 for each Country. How do I get it so that all the records show up?
 

Users who are viewing this thread

Top Bottom