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.....
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
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".
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
IP Logged
