Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Suppressing Report Footer on Drilldown Post Reply Post New Topic
Author Message
Tompong
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 11
Quote Tompong Replybullet Topic: Suppressing Report Footer on Drilldown
    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



Edited by Tompong - 11 Feb 2013 at 7:12am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Feb 2013 at 7:01am
set the suppression formula to use the drilldowngrouplevel() function
 
drilldowngrouplevel<>0
IP IP Logged
Tompong
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 11
Quote Tompong Replybullet 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

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Tompong
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 11
Quote Tompong Replybullet 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

Edited by Tompong - 11 Feb 2013 at 7:36am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
 
IP IP Logged
Tompong
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 11
Quote Tompong Replybullet Posted: 11 Feb 2013 at 7:52am
that works perfectly. 

Thanks
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.