Sort main report based on subreport field

[Guest]

Greetings,

Is it possible to enter an expression in the main report's Grouping and
Sorting to sort the records in the main report based on the value of a field
in the first record of its subreport?

jpn

 

[Duane Hookom]

No. You may be able to create a totals query that can be joined to your
report's record source that provides the value.