Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Suppress a Section Post Reply Post New Topic
Author Message
carleen
Newbie
Newbie


Joined: 02 Jul 2008
Online Status: Offline
Posts: 29
Quote carleen Replybullet Topic: Suppress a Section
    Posted: 16 Dec 2008 at 11:04pm

Hi, does anyone know how to supress a section of a sub report in that section returns no values?  I can see how to supres the sub report but not the whole section. Thanks

IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 17 Dec 2008 at 3:53am
Hi
 
Open the subreport and go to the section which you want to suppress right click select section expert then in common tab Suppress no drill down click X+2 then enter the code to check any of the field values
 
isnull(count({table.fieldname}))
 
Cheers
Rahul
IP IP Logged
carleen
Newbie
Newbie


Joined: 02 Jul 2008
Online Status: Offline
Posts: 29
Quote carleen Replybullet Posted: 17 Dec 2008 at 9:18pm
Hi Rahul
 
Sorry if I wasnt clear. I want to supress the whole section in the main report (this consists of a heading in main report and detail contained in sub report) (all contained in the one seciton of the main report though) if the sub report detail is empty.  I hope this is clearer as I dont think supressing from the actual sub report is going to suppress my heading and all etc..
 
Thanks
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 18 Dec 2008 at 12:22am
Hi
 
Go to the main section in the report which you want to suppress right click that section ,select section expert then in common tab Check Suppress Blank Section
 
Cheers
Rahul 
IP IP Logged
carleen
Newbie
Newbie


Joined: 02 Jul 2008
Online Status: Offline
Posts: 29
Quote carleen Replybullet Posted: 21 Dec 2008 at 2:03pm
Hi
I am so sorry but yes this suppresses the section however it does not suppress the heading, therefore the section shows a big blank area with the heading.  Is there any way I can get the whole section to dissapear? 
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 23 Dec 2008 at 3:44am
Hi
 
Did u try doing the same steps for heading i.e. Suppress Blank Section.....
Cheers
Rahul
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.016 seconds.