How can I suppress a Page header, when I show my subreport that I put in Report Footer B? Also the password that gets asked?

Lalla Belle
Lalla Belle used Ask the Experts™
on
How can I suppress a Page header, when I show my subreport that I put in Report Footer B, at the end of my report?

Also the password for db logon gets asked when I run my report through my vb app?  Is this due to the subreport?  The prompt doesn't appear for a normal report!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
DB Logon - It is probably due to the subreport.  You need to pass the logon information to the subreport just as you do for the main report.

Suppressing the page header
Try this idea
Add a formula to the report header
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader := False;

Add a second report footer
Right click the report footer in the left margin
Click INSERT SECTION BELOW
Put the subreport into Report Footer B

In Report footer A add a formula
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader := True;
''

In the Section Expert
Select the REPORT FOOTER
Click the formula button to the right of SUPPRESS
 WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader

mlmcc

Author

Commented:
Hi,

It totally supresess the subreport then.  I have a second report footer already, so I added one new (b) and put the report in (a).
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Sorry.  You should put the last formula on the PageHeader

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial