Sorting by ALIAS

[doltharz]

Can I have records sorted by an ALIAS calculated field but summaries and recap still refereing the "original" field?

e.g.

[color:red]ALIAS (Calculated) = [color:green]SALESMAN

SomeField total (Calculated) = Recap(somefield, [color:green]SALESMAN)

In the layout i do have

Subsummary by [color:red]ALIAS

You'll agree that order is the same...

[comment]

I'll agree to nothing without knowing what Recap() does. In any case, sub-summary parts will show up only when the breakfield associated with a sub-summary part is explicitly included in the sort order, and the records are sorted. Otherwise the sub-summary will be missing, even if records happen to be in the same order.

[doltharz]

Reading a bit more in help files i got my answer. It appears it's not possible.

I'll have to find something else.

[doltharz]

Till my version in in french, I have to translate function names but it seems it wasn't the right one...

French = Recapitulatif()

English = GetSummary()

Sorry...