Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page Header Suppress options? 1

Status
Not open for further replies.

CraigBest

Programmer
Aug 1, 2001
545
US
Hi Folks

I have a report which I sometimes need to print a page header on, but only under the following conditions:

* Never on page 1
* Only if the details section is active on any page following page 1 (2-n)

Any suggestions on how I can set this up properly? I'm having a little trouble with it.

Thanks

Craig in NJ
 
Dear Craig in NJ,

Well the first part is easy. Click format section, select the page header, click the suppress x2 button and enter

Pagenumber <> 1

Now the second part is a little harder because I don't know what makes the details &quot;active&quot;.

Are you conditionally suppressing the details? If so, please provide details for me so that I can help you.

ro (also in nj!) Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Hi Rosemary, thanks for your response.

<< Now the second part is a little harder because I don't know what makes the details &quot;active&quot;.

Are you conditionally suppressing the details? If so, please provide details for me so that I can help you. >>

Here's the thing. The report is actually a purchase order. It's basically made up of three sections: The Group Header, which displays the PO #, the Buyer, the vendor, etc. The Detail section, which lists the line items of the PO, and a Report Footer section, which includes about 2-1/2 pages of legal jargon. It only prints one group at a time (one complete purchase order).

I don't want the page header to print on page one because the group header carries the basic info already. I want the page footer to print on subsequent pages after #1 to provide column headings fo the line items (if there are more than will fit on the first page). But once the details are completed and the Report Footer starts printing, I don't want the page header to appear anymore.

So, not on page one, only on subsequent pages if the line item details spill over one page, and not after the report footer has started.

Hope this make sense! Thanks for helping.

Craig in NJ
 
Dear Craig,

Why not just suppress the PageHeader all together and have the Group Header Repeat.

There is an option in the Change Group Options to repeat group header on each page.

Right click on your group and click the box (last one in dialog box).

See if that meets your needs,

ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Hi Ro

Thanks, but no, that won't work. The Page Header and Group Header don't contain the same info. Group Header (page 1)has more data (full names and addresses, instructions, etc) and takes up about 4&quot; of space at the top of the first page. The Page Header I want to use on pages 2-n is much smaller, only 1/2&quot; high, and only has the column headings and the PO #. I don't need to repeat the whole works of GH1 on subsequent pages.

The Suppress on PageNumber = 1 works fine, thanks. What I need to know now is how to suppress it when the details section is finished printing.
 
Dear Craig,

Insert a new section under the existing Group Header. It will be related. So you will see GH1a and then GH1B, put your column headings data there.

In the section format for that section - suppress x2 button and put this formula:

Inrepeatedgroupheader = true

That's it, it will print above the details, anytime the details run over to 1+ pages

ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Hi Ro,

Tried your suggestion, still not working. Created two GH1 sections A & B, section A is my primary header, section B is the page 2-n header.

When I do this, both the A and B headers print on page 1, none print on page 2-n (save the lines drawn in GH1B), and the line appear on the report footer pages as well.

Any more suggestions? I also tried setting the suppress formula for GH1A to PageNumber <> 1 and the suppress formula for GH1B to PageNumber = 1. This suppresses GH1B so it doesn't print on page 1, but it doesn't print on page 2-n either.

Thanks

Craig in NJ
 
Dear Craig,

Email me your report with saved data and I will look at it real quick.

I am working on a client project and am under the gun, you are also welcome to call me on my cell 973-818-2260.

ro
Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Just wanted to update this topic so that others experiencing this issue will benefit from the fix.

There were two problems. First, I made an error in my formula above it should be:

inrepeatedgroupheader <> true //had it backwards

and

The Group Option, Repeat Group Header on Each page was not checked in the report for GH1B. Checked it and the report displays as desired.

ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Thanks again, Ro. You fixes were just the thing. Now I can also update the three other similar reports.

Craig in NJ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top