Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Suppress Section Post Reply Post New Topic
Author Message
sandy
Groupie
Groupie


Joined: 10 Jan 2007
Location: United States
Online Status: Offline
Posts: 45
Quote sandy Replybullet Topic: Suppress Section
     Posted: 07 Jun 2007 at 11:54am

I  added 2 subreports in their own group footer sections on the detail page.

One subreport should print if they are a resident and the other if there are not a resident.
 
Within the section expert of each group footer section, is this where I want to add a formula to suppress or print that section?
 
would this be the formula?  Reason is I get that it must return a boolean
if (tablename.field) =
then
formula = False
else
formula = True
end if
 
thanks so much!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 07 Jun 2007 at 12:50pm
You already got it figured out! In the section expert there is a Formula button (X-2) that lets you conditionally suppress the section. Just put the formula you listed here in it (and include the actual string for 'Resident'). This is Crystal Syntax.
if (tablename.field) ="Resident" Then
 
    False


else


    True;
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
sandy
Groupie
Groupie


Joined: 10 Jan 2007
Location: United States
Online Status: Offline
Posts: 45
Quote sandy Replybullet Posted: 08 Jun 2007 at 7:16am
Yes!  Thanks for quick response.  Not sure though how you link it.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Jun 2007 at 10:59am
Read my free chapters online. I walk you through it there.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
MythMosy
Newbie
Newbie


Joined: 03 Mar 2008
Location: United States
Online Status: Offline
Posts: 2
Quote MythMosy Replybullet Posted: 03 Mar 2008 at 6:01am
Hi,
I am having the same problem... I used the same formula & it isnt working for me ...
 
Plz help...
Thx,
Mythili
IP IP Logged
sandy
Groupie
Groupie


Joined: 10 Jan 2007
Location: United States
Online Status: Offline
Posts: 45
Quote sandy Replybullet Posted: 03 Mar 2008 at 8:11am
Did you place the formula at the group level?  This is what I did to print the residential section if resident  (apply a suppress formula at the Group level (right click on GF1a or whatever group you have that section in)

 

For Non-resident

if {APBLDG.WORKTYPE} = "NEWNRS"  Then

 false

Else

 true;
IP IP Logged
MythMosy
Newbie
Newbie


Joined: 03 Mar 2008
Location: United States
Online Status: Offline
Posts: 2
Quote MythMosy Replybullet Posted: 03 Mar 2008 at 9:55am
Thx for the reply..
Actually I solved it myself in a different way....
 
For example,
if I want to suppress the section if worktype is 'NEWNRS', then I typed
{APBLDG.WORKTYPE} = "NEWNRS"  in the suppress formula...
I didnt use if-else condition & in section expert, It is not mandatory to select the suppress checkbox...
 
It works perfectly.....
 
Thx,
Mythili
IP IP Logged
anandjnf
Newbie
Newbie


Joined: 20 Jun 2009
Location: India
Online Status: Offline
Posts: 1
Quote anandjnf Replybullet Posted: 20 Jun 2009 at 3:11am
thanks a lot. It worked for me also rahter than using if..else
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 | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.