Manual Running Total blues

[edsaf]

Hello,

Using CR-XI on a SQL database.

I need to dsplay the team with the highest score. I am unable to use the group sort expert because of the way the score is generate so i have used the reset/evaluate/display method, and it works (for the result).

The problem i have is that i need to display the team name that is associated with the highest score.

-----------------------------------------
Here are my current formula's:

-reset-
whileprintingrecords;
global numbervar nps_site:= -999;

-evaluate-
whileprintingrecords;
global numbervar nps_site;

if {@nps_site} > nps_site then nps_site:= {@nps_site} else nps_site

-display-
whileprintingrecords;
global numbervar nps_site;

nps_site

-----------------------------------------
For the team name, i tried doing this, but i keep getting blank results:

-reset-
whileprintingrecords;
global stringvar site_name:= ''

-evaluate-
whileprintingrecords;
global numbervar nps_site;
global stringvar site_name;

if {@nps_site} > nps_site then site_name:= GroupName ({@site}) else site_name


-display-
whileprintingrecords;
global stringvar site_name;

site_name

Whats the best way to get the team name??

 

[dgillz]

i would drop the groupname function and just refer to the database field that holds the name.

Also, there is no need to use "global" in these formulas, all variables are global unless declared otherwise.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

You should identify the groups and the placement of each formula. Assuming you are looking for results at the Group #1 level, then you could use just one evaluation formula like this:

whileprintingrecords;
numbervar nps_site;
stringvar site_name;
if {@nps_site} > nps_site then (
nps_site:= {@nps_site};
site_name := {@site}
);

Use the reset and display formulas that you showed earlier.

-LB

 

[edsaf]

lbass - That worked a charm.

Thank You