Click to See Complete Forum and Search --> : Page Header Suppression
harmonycitra
August 24th, 2004, 01:03 PM
Hello everybody,
Here is my problem. I'm generating a sub report in the report footer of the main report.
My problem is the page header for main report is displaying in the sub report.
I like to suppress the page header when the sub report is displaying.
Is there any way to do this?
Thanks in advance
llednew1827
September 8th, 2004, 05:50 AM
Hello there,
Since I had the same problem regarding your question. I've searched the web for some possible answers, i hope this will help you because it works in my report
Here's how to do it:
1. In your main report right click on the Page Header Section then click Format Section
2. Click on the Page Header, check Supress (no drill down) then click x-2 button
3. Finally paste this formula
WhilePrintingRecords;
Global NumberVar gh1;
Global NumberVar permanentgh1;
Global booleanVar Suppress;
If pagenumber = 1 then
permanentgh1 := gh1;
permanentgh1 = 1;
if gh1=0 then
Suppress:=True
I hope this will work in your report. have a good day.
harmonycitra
September 8th, 2004, 01:18 PM
I resolved the problem by checking a run time value which is set when the lastrecord is read.
i.e suppressing the page header when the cournter is set (i.e when the last record in the main report is read/print)
Hope yours also will work.
Anyway thank u so much.
mpvel
April 19th, 2005, 04:59 PM
harmonycitra/IIednew1827
I am kind of novice in programming vb code. Can you please post the code whatever you developed to suppress the page heading in the subreport.
When I used the existing code on this page It suppressed totally, that means not only on subreport pages, but on main report. I want Header on main report.
Thanks in Advance.
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.