Sort ordering not working

[swenger]

I have 2 tables. Table 1 is Header information, Table 2 is Details. I have a report based on Table 1 and then I created a query on Table 2 where I sorted the detail by a filed called order. I created a report off this query. When I run this report the information comes in the correct order, but when I attach this as a subreport to the report with the Header using order number as the link, the details of the report don't come in the correct order as the query or subreport.

I can't figure out why this is

[orange]

Reports have their own sorting and grouping, and will not necessarily use the order from the query.
Try setting the order you want in the report.

Good luck.

[swenger]

Thanks. I added [order] to the order by property in the subreport. This fixed the problem, but I am perplexed why since the subreport was always sorting properly when ran alone. Only when ran the main report which included the subreport was there an issue.