cancel
Showing results for 
Search instead for 
Did you mean: 

Remove the blank spaces after a Page Footer in Crystal Reports ?

Former Member
0 Kudos

I am using a Page Footer A and Page Footer B. Page Footer A contains the first page information and Page Footer B contains a "Page n of N" means remaining page information. Page Footer A will be conditional supressed after page 1 while Page Footer B will show after page 1.

Page footer A is supressed for reamaing pages but it has taken blank page. and due to this blank page my Page footer B contain shifted to next page.

I think this is a crical bug in Crystal report.

Accepted Solutions (0)

Answers (2)

Answers (2)

abhilash_kumar
Active Contributor
0 Kudos

Hi Biswanath,

Would you be able to attach a copy of this report 'with saved data' to Google Drive and post the URL here?

-Abhilash

DellSC
Active Contributor
0 Kudos

Unfortunately, this is one of the issues that Crystal has had for many years. SAP (and BusinessObjects before them and Crystal Decisions and Seagate Software before them...) will tell you that it's not a bug, it's a "feature".

However, depending on what's in footer a, here's how I might handle this:

1. Move the Footer A information to a subreport in page footer section a.

2. In the main report, make the subreport as small vertically that you can and set its location so that the Y value is 0.

3. Pull the bottom of the footer a section up to the bottom of the subreport.

4. Set both the subreport and the footer a section to suppress when PageNumber>1.

What will happen now is that the subreport will render the first footer on page 1. The section of the main report that contains the subreport will expand to fit the subreport when it's rendered. On the succeeding pages it should use a very small amount or no space for the first footer and you'll just have the second footer.

I haven't tested this, but I think it will work. If it doesn't work, I have a couple of other thoughts for how to do this.

-Dell

Former Member
0 Kudos

The given solution is not working, can you please provide some other solution...

I had tried to find some solution on google but i haven't.

DellSC
Active Contributor
0 Kudos

From what you posted below, your subreports are very "tall". Did you try shrinking them - same width across, but very small height?

Is the information in the first page footer all you want to see on the first page or are there other parts of the report? If it's all that you want to see on the page, have you tried putting it in a report header section instead?

-Dell

DellSC
Active Contributor
0 Kudos

Hi Biswanath,

I'm looking at the reports you posted. Is it correct to assume that this will be printed once for a single vehicle? Is there a particular reason why you're using subreports based on parameters (no data connection) instead of putting all of the information in the main report?

Since you didn't save the reports with any data, it's a challenge to see how any changes I make will look. Do you have a way of saving it with dummy data so I can play with the structure?

Thanks!

-Dell

Former Member
0 Kudos

Any help on these issues is appreciated.

DellSC
Active Contributor
0 Kudos

Take a look at my updates here: https://drive.google.com/file/d/1D82yPb_fOeXTs642Ouiqh9iC2kLQvDqs/view?usp=sharing

I did a number of things:

1. Moved the report footer to a details section. Crystal won't render a page footer in the report footer. I also left "Keep Together" turned on for this additional section so that it automatically moves to the next page because there's not enough space for it on page 1.

2. Took off ALL of the suppression on sections.

3. Moved the contents of Page Footer 2 into Page Footer 1.

4. Set the suppression formulas on the two text blocks that are now in the single page footer section.

a. The formula for the text for the first page is: PageNumber > 1

b. The formula for the text for the next page(s) is: PageNumber = 1.

<soapbox>The condition in an If statement returns true or false. If your If statement will return true or false, remove the if and just use the condition! </soapbox>

5. I also decreased the size of the text for the first footer to match that of the second footer.

6. I moved the two objects in the footer toward the top of the section and pulled the bottom of the section up to the bottom of the tallest object.

Crystal will reserve the space for both footers if you have two sections. If you have a single section with more than one object in it, it will reserve space on ALL pages for the tallest object. If you make the object shorter, with Can Grow turned on, Crystal will not render the whole thing - just the part of it that's showing in Design mode. (I learned that while playing with this report.) Page footers will always be the same size as they are in design mode. So, if you can make the two objects similar heights, and make the page footer section as small as possible while still showing everything in the objects it contains, you'll effectively minimize how much space will be taken up for all of the page footers.

-Dell