sort group expert problem 1

[ncchish]

I need help with this report if anyone has any ideas – thanks in advance. I’m using Crystal Reports 11. I have parameter driven report. The report currently has a main report and a subreport. They wanted me to add another parameter for a new ranking. Currently, we have ranking by sales and they want a parameter ranking by life amount. It’s set up so they can run it by either one and it suppresses the opposite column based on which parameter they run. I added the summary to the group sort expert descending under the original sort. However, it doesn’t sort the face amount in descending order. It appears to be in some random order. If I take the face amount and move it to the top in the group sort expert and select descending and then run the report then it runs correctly. If I run the sales metric (which is now second in the list) then it’s in random order. Why is it doing this? I need them both to be in descending order. The report works well other than this one problem. Can anyone help with this?

Thanks.

 

[IanWaterman]

You might be better off to use a formula to group the report as required rather than suppressing data.

@Group

If {parameter} = 'Sales' the {salesfield] else {Lifefield}

Ian

 

[lbass]

You could create a formula like this:

if {?Parameter} = "Life" then
{table.lifeamt} else
if {?Parameter} = "Face" then
{table.faceamt}

Insert the summary on this formula and then remove the other group sort fields and only use this one.

-LB

 

[ncchish]

Thanks so much LB. That worked like a charm. You are the best!