Subreport Not keeping the same order 2

[kkarren]

I have a subreport that I a drawing several fields from a query.  I have ordered the subreport on a numerical field.  When I look at the report by itself the order is exactly as I would have it.  When I view the subreport in the context of the main report the order is not being kept.

 

[DougP]

Try this open the Main report in design view then double click the subreport so its in Design view.<br>Next click the &quot;View Menu&quot; then &quot;Sorting and Grouping&quot;<br><br>Pick the field you want to sort on .<br>Save the subreport close it. <br>You should be in the main report.<br>save it then view it.<br>If that does not fix it, then something else on the main report is causing the Sort order to do something you are not expecting. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.