Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Supress section formula Post Reply Post New Topic
Author Message
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Topic: Supress section formula
     Posted: 29 Aug 2013 at 10:40pm

On a report i have a name field, depending on if a name ends with (Status90) i would like to show/hide those which contains (status90)
Example:

Company-name1
Company-name2
Company-name3 (status90)
Company-name4
Company-name5 (status90)
etc.

So how do i do a supress section formula that 1. only show companys with (status90) in the name field and 2. only shows companys without (status90) in the name field?

IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 30 Aug 2013 at 1:48am
Hi,
 
If you want to show companys with (status90) in the name field then
Right click on the section and select "section expert" > select suppress
in the formula window write below code
 
if ({Database_Field}) like "*(status90)" then False
 
If you want to show compays without (status90) then
write below suppress logic
if ({Database_Field}) like "*(status90)" then True
 
--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Posted: 01 Sep 2013 at 11:26pm
Didnt work at first...(mybad) then it worked perfect, Big thanks again :)
 


Edited by Wosp - 02 Sep 2013 at 3:46am
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