Print Page | Close Window

How to supress sub report if it does not have data

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7782
Printed Date: 01 May 2024 at 7:43pm


Topic: How to supress sub report if it does not have data
Posted By: arulselvan
Subject: How to supress sub report if it does not have data
Date 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.....


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window