We help IT Professionals succeed at work.

Grouping and sorting report

Gordon Hughes
Gordon Hughes asked
on
Hi
I have a report which I am trying to group by a formulae, but it will not shown in the group option (group Header #1
The formulae is Category
Also I want to sort the group Header #2 by the Sum of the Transactions.total
But again it does not show the option

Any ideas?
Have attached the report
Members-Bar-Spend.rpt
Comment
Watch Question

Ido MilletProfessor Emeritus of MIS at Penn State Erie and Owner, Millet Software

Commented:
Crystal won't allow you to group on a formula that gets evaluated at print time due to it depending on a total or other print-time factors.

So revisit the logic of what you are trying to do and make sure you are grouping on a field/formula that can establish its value at the time records are read as opposed to at the time the report gets rendered after sorting and totaling.
Gordon HughesDirector

Author

Commented:
I am giving this route up so will close the question
Director
Commented:
Not doing it
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you trying to sort the groups on the summary formula?

If so use the GROUP SORT option under the REPORT menu.

mlmcc