Print Page | Close Window

Suppressing Report Footer on Drilldown

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19079
Printed Date: 03 May 2025 at 6:19pm


Topic: Suppressing Report Footer on Drilldown
Posted By: Tompong
Subject: Suppressing Report Footer on Drilldown
Date Posted: 11 Feb 2013 at 6:47am
How do I suppress report footer when I drill down?

Structure:
Report Header
Page Page Header a
Page Page Header b
Group Header #1
Details
Group Footer#1
Report Footer a  - want to suppress on drill down
Report footer b - want to suppress on drill down


Replies:
Posted By: DBlank
Date Posted: 11 Feb 2013 at 7:01am
set the suppression formula to use the drilldowngrouplevel() function
 
drilldowngrouplevel<>0

Posted By: Tompong
Date Posted: 11 Feb 2013 at 7:11am
Hi,

Its not working.

Structure:
Report Header
Page Page Header a
Page Page Header b
Group Header #1
Details
Group Footer#1
Report Footer a  - want to suppress on drill down
Report footer b - want to suppress on drill down

Posted By: DBlank
Date Posted: 11 Feb 2013 at 7:27am
the report footer is only on the last page so I am a little confused by your request.

Posted By: Tompong
Date Posted: 11 Feb 2013 at 7:35am
everytime I drill down, the total for the main report is still showing up on the report footer, I want to hide the total of the main report from the drilldown

Posted By: DBlank
Date Posted: 11 Feb 2013 at 7:45am
under file>report options there is an option for 'show all headers on drill down'. mark that as false (unchecked)
 
or right click on the field you want to suppress,
select format field
select common
select tghe suppress formula and use
drilldowngrouplevel<>0
 

Posted By: Tompong
Date Posted: 11 Feb 2013 at 7:52am
that works perfectly. 

Thanks


Print Page | Close Window