sections problem...

[BSK911]

here's my problem, I have a report with the 5 default sections on it.

I want to print a logo and a title on every page of the report and some checkboxes on the first page only.

I made a screenshot to make it easier to understand.

http://www.ygcity.com/images/testwww.jpg (~270kb)

I want section 1 to print on top of every page and section 2 on the first page only.

As it is now, section 1 prints on page one only and section 2 on every page.

Any help is greatly appreciated!

Thanks

[malleyo]

(This example if from Crystal Reports 8.5 and may need to be tweaked a little depending on your version.)

Right Click on the Page Header and click Add Section below. This should give you a 'Page Header a' and 'Page Header b'.

Put the data from Section 1 into the 'Page Header a' instead of the Report Header.

Put the data from Section 2 into the 'Page Header b'. Right Click on 'Page Header b', go to Format, find where you can check Suppress and click the 'X-2' button beside it. Enter the following formula:

PageNumber > 1

Putting your data from Section 1 into 'Page Header a' will repeat it on every page. Putting the data from Section 2 into 'Page header b' and setting the Formula will make 'Page Header b' visible on the first page and suppressed an each page after that. (Just keep in mind that if you have 'ResetPageNumberAfter' or 'ResetPageNumberBefore' set for any of your sections, the 'Page Header b' will be visible whenever the Page Number is 1.)

[BSK911]

it worked perfectly! THANKS!

but now I have another issue.

I did the same thing to the page footer section because I need some information to be at the bottom of the first page(page footer A) and another little logo at the end of each page(page footer B).

It works with the same method but when the page footer A is removed by the formula page footer B is displayed higher on the page instead of staying at the bottom and giving more space to the details section.

Thanks again!

[malleyo]

I noticed that too with the Page Footer. I assumed it must be a bug, but I found this article (http://support.businessobjects.com/library/kbase/articles/c2007807.asp) on Crystal's website.

Here's a summary:
Conditionally suppressing the page footer in a report will print a blank space that is the equivalent size of the page footer being suppressed. The blank space printed in CR is by design.

CR can not generally determine whether the current page is going to have its page footer conditionally suppressed while starting the page formatting, at the top of the page, for at least a couple of reasons:

· If there are any formulas with print-time side effects contained in the page footer, you would be surprised to see those side effects at the top of the page.

· Page footers are often conditionally suppressed based on whether some content finishes on one page or continues to the next page and CR does not know that at the top of the current page.

CR assumes the worst case and reserves space for the page footer. Once CR fills the page, print-time formulas in the page footer are evaluated (in case there are side effects that need to become visible now) and see whether the page footer should be formatted or suppressed.

And the solution:
To eliminate blank spaces caused by suppressing more than one page footer in your report complete the following steps:

1. Select all objects from the various page footers.

2. Move the selected objects into one page footer.

3. Delete the remaining blank page footers.

· Select 'Section' from 'Format'.

· Select the page footer to remove from your report, click 'Delete'.

Complete these steps until all Page Footers you want to delete are gone.

4. Conditionally suppress each object that is placed into the page footer.

To conditionally suppress an object:

· Select the object that is to be suppressed.
· Right-click the object
· From the fly-out menu, select 'format field'.
· Click the 'x + 2' button and enter your formula.

[BSK911]

Thanks for everything, we got the report doing most of what we want!

We appreciate the help a lot!