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

Formula Field with For loop can't be used in Group sort?

Status
Not open for further replies.

bhfmc

IS-IT--Management
Jun 18, 2003
29
0
0
US
In 8.5 I just wrote my first 2 Formula Fields (FF) using a "For loop." The FF's work great EXCEPT when I try to concatenate them into another FF on which one of my Groups is (grouped and) sorted. The error message I get is "Group specified on a non-recurring field." Just printing these 2 FF's in a report is no problem. How can I use those 2 FF's in a Group sort FF?
 
They'd have to always evaluate at the row level to be *grouped*.

Perhaps you would be better served to describe requirements using example data.

-k
 
You should share the contents of your formulas and explain what you are trying to do, in addition to describing your report structure and supplying some sample data.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top