Sorted sub-report NOT sorted in main

[Guest]

I have a subreport whose Record Source properties as a SQL query. One of the
items is sorted ascending by name. When I execute the report by itself, all
is sorted properly. However, when embedded in a parent report as a sub, it
doesn't sort at all. What's wrong please, and how do I address it?

Report Filter is blank.

Thanks!

 

[Guest]

If you sort the record in the source of the report then its not always working.
go to the report grouping and sorting select the field you want to sort by,
and choose asc or desc.
Try it

 

[Guest]

That was it. Thanks a million!!!!

If you sort the record in the source of the report then its not always working.
go to the report grouping and sorting select the field you want to sort by,
and choose asc or desc.
Try it

 

[Guest]

any time

That was it. Thanks a million!!!!