Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Random Name is Getting Ommitted on Report Post Reply Post New Topic
Author Message
waterg2
Newbie
Newbie
Avatar

Joined: 29 Oct 2010
Online Status: Offline
Posts: 10
Quote waterg2 Replybullet Topic: Random Name is Getting Ommitted on Report
     Posted: 08 Nov 2010 at 10:24am
I'm trying to troubleshoot why the name field is blank for one person on my report, even though the rest of the data is showing. I have check the table where the data is stored, and it looks fine. The report has about 900+ rows, all of which look fine. The report is grouped on a combination of fields and formulas.  Problem is only occurring in one of the groups. The first row of data is missing the individuals name.
 
I'm using an @Name formula - FLXFormatNameMTS ({@RuleInfo},{FirstName},{MiddleName},{LastName})
 
I have tried using this formula too, but it did not resolve the issue.
{LastName}+ ', ' +{FirstName}+'  '+{MiddleName}
 
Any help is greatly appreciated !!!!
 
waterg2
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Nov 2010 at 11:39am
do you have a null value in any of these fields?
If so and youa re not accounting for that it will kill the formula and return nothing.
IP IP Logged
waterg2
Newbie
Newbie
Avatar

Joined: 29 Oct 2010
Online Status: Offline
Posts: 10
Quote waterg2 Replybullet Posted: 09 Nov 2010 at 11:23am
Yes, this particular example does have a null value for the middlename field. I will rework the formula to account for that to see if it resolves issue.
 
Thank you!!
 
waterg2
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Nov 2010 at 11:25am
youc an just flip the option in the formula editor from 'Exceptions for Nulls' to 'Default values for Nulls'
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum