Missing information in Crystal report 2

[Crystalamateur]

Hi, I need some help please.

I have created a report to show the financial results for the previous year.

Our data consists of a main centre with individuals linked to that centre. In the group footer I have the following fields showing.
fbFINANCEINFO.UALPHA_2 (this is the main centre record)
fbFINANCEINFO.UALPHA_3 (this is the name of the centre)
fbFINANCEINFO.UALPHA_4 (this location of the centre)
Sum of fbFINANCEINFO.Amount Paid

Where the financial information is taken from more than one record, i.e individuals linked to the centre, the name and location are not showing in the report. Where finance is only taken from the main centre then the name & location is shown.
The financial details are fine.

Many thanks
Peter

 

[lbass]

You haven't identified your group field. If there is only one value for each of these fields per group, insert a maximum on them at the group level.

-LB

 

[Crystalamateur]

Hi LB

Sorry the group field is UALPHA_2

How do you inserta maximum value at group level?

Thanks
Peter

 

[lbass]

Place the fields in the detail section. Select one->right click->insert summary->maximum->select the group level.

-LB

 

[Crystalamateur]

Hi,
Thank you very much for that it worked.
Peter

 

[franceshd]

HEY! I am having a similar problem with a formula stringing a name Last,Middle,First. It tried inserting a max value at the footer record, but it still didnt work. Any ideas, please? THANKS SO MUCH! Here is the formula:


// StringNameLFM

stringVar LName:= '';
stringVar SName:= '';
stringVar EmpName:= '';
If Not IsNull({HRPERSON.LAST_NAME}) then
LName:= Trim({HRPERSON.LAST_NAME});

If Not IsNull({HRPERSON.SUFFIX}) then
SName:= Trim({HRPERSON.SUFFIX});

Empname:= Trim(LName) & ', ' & Trim(SName) & ' ' &
Trim({HRPERSON.FIRST_NAME}) & ' ' &
Trim({HRPERSON.MID_NAME});

 

[franceshd]

Well, well. I just found some instances of people with multiple items that DO have the name. So it must be something else wrong.
The groups are : Certification (field - C or N)
Selection (another formula - "New Hire" or
"Current Emp" depending on
hire date)
Last Name (field)
First Name (field)

 

[lbass]

Place your formula in the detail section along with the related fields to see if it is performing correctly. I think you should do a null check on the middle name, too.

-LB

 

[franceshd]

WOW! Thanks! I didnt notice that people without a middle name were the problem.
THANKS AGAIN and have a GREAT weekend!!