Sub-Report Won't Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subreport on a report that will not sort.
The subreport is filtered from a query to show results that match a student
ID. I tried going to the properties of the subreport and setting the OrderBy
to qryAlphaTardies.date and changing OrderBy On to yes.

Each time I view the report, the OrderBy On changes back to No.

I then went into SQL and set the query's date sort to alpha, but when I get
back to the report the subReport is still not sorted.

Can anyone tell me what is going on here?
 
Open the subreport in design view, than from the view meny
select sorting and grouping, and in the sorting and
grouping window set the sort to the desired parameter.
Hope this helps.
Fons
 
THANK YOU!!!!!

It was driving me CRAZY!

RIP

Fons Ponsioen said:
Open the subreport in design view, than from the view meny
select sorting and grouping, and in the sorting and
grouping window set the sort to the desired parameter.
Hope this helps.
Fons
Click to expand...
 
Back
Top