Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sorting by a sub-report field

Status
Not open for further replies.

Richey

Technical User
Aug 29, 2000
121
GB
Hi

I have a report with a sub-report 'week subreport' which contains an unbound text field 'Text4'
I want the report to sort by this 'text4' field but am struggling to know how to sort?

Ta
Connor
 
Try placing this in the first box of your Sorting and Grouping.

[MySubReportObjectName].Report![Text4]

Make sure you use the object name for your subreport in the main report, not the name of the subreport itself (unless they are the same).

HTH Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top