Sort by formula

[pgovind27]

Hi All,
I have old report, Now i want to change the displaying order of the report based on some calculation. i did one formula for that. now i want to sort by the formula, but iam not able to add this formula to record sort expert, iam able to add all formula which all already created but not the new one i created. how to solve this?

or alternatively anything is there " whileprinting sort Asc/desc" like that?


please help me in this regard

 

[lbass]

You have to show the content of the formula (and of any nested formulas) that you want to sort by.

-LB

 

[pgovind27]

Thanks LB Here is the content:

Shared Stringvar array VotedAnalyst;
Shared Numbervar array VotedValue;
Shared Numbervar array VotedPercent;
Local Numbervar i;
Local Numbervar J;
Local booleanvar Chk := True;
for i := 1 to ubound(VotedAnalyst) Do
(
if Ucase({SP_IE_Analyst_Sector_Rankings;1.IndividualName})
= Ucase((VotedAnalyst)) and Chk = True then
J := VotedValue;
Chk = False ;
);
((j - minimum(VotedValue))/maximum(VotedValue)) * 100;


The shared arrays are coming from subreport.

 

[lbass]

Sorry, you cannot sort by shared values from a subreport.

-LB

 

[pgovind27]

Thanks LB