Group Sort on Sum Formula 1

[cwsstins]

I have a SUMFormula that does a SUM(@OtherFormula1) + SUM(@OtherFormula2). I want to do a Group Sort using the SUMFormula, but it's not listed in the Group Sort Expert for my group.

How can I sort on this thing? CR XI, SQL Server 2005.

 

[lbass]

Create a formula like this for the detail section:

{@OtherFormula1} + {@OtherFormula2}

Then insert a sum on it at the group level. Group sort should now be available on the sum of this new formula. You must have inserted a summary in order to activate the group sort feature.

-LB

 

[cwsstins]

LB, you rock! So simple...thanks!