Sort a Report by a text box bound to expression

  • Thread starter Thread starter TEAM Racing
  • Start date Start date
T

TEAM Racing

I have a text box bound to an expression that uses values
from a subreport, so I can't create a field in the query
to sort. I am guessing that the "order by" property on
the report is the way to go, but can't seem to nail down
the syntax.

I have tried the following in the "order by" property:
Text17
[Text17]
=[Text17]
[rptToolLifeATVs].Report!Text17
=[rptToolLifeATVs].Report!Text17
and so on

Please help.
 
You are wasting your time attempting to set any order in the report based on
a value from a control on a report. Sorting can only be done with
calculations from the report's record source. Are you sure you can't
calculate the value from your subreport in your main report record source?
 
Back
Top