Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Null Formula Post Reply Post New Topic
Author Message
MichelleM
Newbie
Newbie
Avatar

Joined: 22 Nov 2011
Online Status: Offline
Posts: 5
Quote MichelleM Replybullet Topic: Null Formula
     Posted: 23 Nov 2011 at 11:25am
I'm very new to writing formulas......
 
I have a report that lists an agent's quality score.  There are several sections for scoring, however, based on the type of call taken, maybe some sections would not be filled in as it did not pertain to the call.  When I run this report, those sections appear with blank answers.  Is there a formula that can eliminate the sections where the Display Answer is Null?
 
Thanks!
Michelle
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 23 Nov 2011 at 11:42am
if they are in their own sections, goto the section expert and check the entry for 'suppress blank sections'
IP IP Logged
MichelleM
Newbie
Newbie
Avatar

Joined: 22 Nov 2011
Online Status: Offline
Posts: 5
Quote MichelleM Replybullet Posted: 29 Nov 2011 at 11:36am
It's actually a field {DisplayAnswer} inside a section {ScoringDetail.viw.QuestionText}.  So if {DisplayAnswer} were blank, I do not want the {ScoringDetail.viw.QuestionText} to appear at all.  Possible?
Michelle
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 30 Nov 2011 at 8:50am
hmm...
 
in the section expert, click the x-2 button to the right of suppress.
 
Enter the criteria into that signifies when to hide the section.
 
I typically use code like:
{table.field} = "x"
 
if it is true, the section is supressed and displayed if not.  it's a short cut to:
if {table.field} = "x" then
  true
else
 false
 
HTH
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 30 Nov 2011 at 10:55am
in the "report" tab click "select expert" put
not (isnull({DisplayAnswer}))
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.