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!

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

GRP FOOTER SORT

Status
Not open for further replies.
elaineva

elaineva

Programmer
Nov 14, 2002
35
US
Can you sort on a calculated field in a grp footer?

I have a calculated percent field based on 2 tot fields created in the grp footer and want to sort on the new percent field. The field does not show up as a sort field.
 
Sort by date Sort by votes
What version of CR are you using? There is a solution using SQL expressions, but this does not necessarily work in higher versions.

-LB
 
Upvote 0 Downvote
Please see thread767-874782 for the solution using SQL expressions.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Cross Tab Sorting Columns
Replies
1
Views
241
hilfy
hilfy
Maverick2021
  • Locked
  • Question
runtime error 20567 "page header/footer is larger than page"
Replies
0
Views
207
Maverick2021
Maverick2021
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
177
lbass
lbass
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
235
lbass
lbass
NBVC
  • Locked
  • Question
Suppressing Report Footer on a report that uses page renumbering between groups 1
Replies
4
Views
132
NBVC
NBVC

Part and Inventory Search

Sponsor

Back
Top