Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: How to supress sub report if it does not have data Post Reply Post New Topic
Author Message
arulselvan
Newbie
Newbie
Avatar

Joined: 23 Sep 2009
Location: India
Online Status: Offline
Posts: 1
Quote arulselvan Replybullet Topic: How to supress sub report if it does not have data
    Posted: 23 Sep 2009 at 11:55pm

Hi,

    I have a problem in crystal report that is Iam having one main report and two sub report. depending upon the input date i will display data.In paticular date sub report 1 does not have data to display. But in that paticular date sub report 1 also displaying data. so I want to supress the sub report  if it does not have any data ...... This is my problem ... Help me... Thank you.....
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 12 Oct 2009 at 2:19pm

In the suppression formula for all sections in your subreport, for all sections that contain only data, turn on "Suppress Blank Section." Fo sections where your've typed text, put something like "IsNull({table.some_key_field})" using a field from your data that determines whether there is data in the subreport.

In the main report section where the subreport is located, turn on "Suppress Blank Section".
 
-Dell
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.