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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting results based

Status
Not open for further replies.

diegoC11

Technical User
Sep 21, 2010
10
US
Hey everybody,

I have a report that has three levels of grouping, level two and three are suppressed. The end-user wants the report to be sorted based on a formula in the last grouping level, but I haven't found a way to do that yet. Any ideas (possibly using a formula as the group sort order?)?

High level View

Group 1
Group 2 (supressed)
Group 3 (suppressed)
Formula 1


Thanks in advance for your help!!
 
Hi,
Yes, a formula can be used as a Group , assuming the info needed is present in the preceeding section ( within G1,G2 and G3 )

[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
You need to show us the content of the formula (and of any nested formulas).

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top