Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: suppress line formula Post Reply Post New Topic
Author Message
00331data
Newbie
Newbie
Avatar

Joined: 09 Mar 2011
Online Status: Offline
Posts: 13
Quote 00331data Replybullet Topic: suppress line formula
    Posted: 28 Mar 2011 at 11:14am
Hi:
 
If I have a formula:
 

If ({Group5_csv.ObjRecordType}=‘Archives Collection’

or {Group5_csv.ObjRecordType}='Mixed Media Collection'

or {Group5_csv.ObjRecordType}='Oral History Collection')

     then ‘Collection Title:     ‘ &  {csv.ObjCollectionTitle}

          else “”

Instead of having the formula say 'else blank,' how can I make it say
'else suppress line'?
 
PS  Thanks for all the help you guys have given in the past--you are geniuses!  I greatly appreciate your help.
thanks,
00331data
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Mar 2011 at 11:20am
you cannot make it suppress in this formula but rather in the section expert find the section you want to suppress and add you condtion to the suppress formula option under 'suppress no drill down'
NOT(({Group5_csv.ObjRecordType} in [‘Archives Collection’,'Mixed Media Collection','Oral History Collection'])
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Mar 2011 at 11:29am
note that makes your other formula a bit redundant and you can just add a text field with ‘Collection Title:     ‘ &  {csv.ObjCollectionTitle}
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.