Print Page | Close Window

suppress line formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12736
Printed Date: 27 Apr 2024 at 1:17am


Topic: suppress line formula
Posted By: 00331data
Subject: suppress line formula
Date 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


Replies:
Posted By: DBlank
Date 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'])

Posted By: DBlank
Date 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}


Print Page | Close Window