cancel
Showing results for 
Search instead for 
Did you mean: 

How to avoid space on page footer ?

Former Member
0 Kudos

Dear Experts,

I have Designed Report  by using  following section (Report Header , Detail , Page footer ).  I need to show page footer record on first page alone . No need  to repeat on each page . So I used conditional suppress formula ( when page number > 1 ).  My page footer section is little big .   Every thing is working fine  when I have minimum records (If it's completed in 1 page ).

If I have more records (Multiple pages) , then I cant able to occupy the space for page footer . Page footer getting suppress but  empty space is still there . 

How to occupy page footer  space . Otherwise is there any other alternate way to achieve this without using page footer ?

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Sri,

Please see if the suggestions in this thread help:

-Abhilash

Former Member
0 Kudos

Dear Abhilash ,

In the Above Link you mentioned [ Instead of suppressing the section itself, try suppressing each field in those sections ], I tried the same , but still getting blank space .

In My scenario I cant use group section also , because group footer will display at the end of group header only .

So pager footer is the only option if I need to show some fields on first page itself . Is there any other alternate way to do this  ?

abhilash_kumar
Active Contributor
0 Kudos

Hmm...would you be able to attach the report with saved data please?

-Abhilash

Former Member
0 Kudos

Dear Abhilash ,

Please preview my report , need to avoid space in 2nd page  .

abhilash_kumar
Active Contributor
0 Kudos

Hi Sri,

I have a solution that unfortunately will not work for your report .

The solution is to get rid of the Page Footer and move all its contents to a Details b section. Then using a conditional suppression logic (based on the max record count that should be displayed on the page) and a conditional New Page After for Details b, you get a 'make-shift' Page Footer that shows just on the first page and doesn't occupy space when there is no Page Footer too.

The reason it will not work on your report is because the Details Section is made of objects that 'Grow' - grow so much that they keep spanning almost 3 pages. Adding a Details b section will result in that section being shown at the end of Details a which is actually the thrid page.

I'm sorry but this is a dead-end, unless someone has another solution.

-Abhilash

Former Member
0 Kudos

Thanks for your support Abhilash ,,

Is it possible to add this type of scenario in [Sap Place your idea form ] .

I am waiting for solution for this from long time , I already posted this same query in different title , that time itself u mentioned its very hard to occupy  reserved space of page footer . Now you directly checked my rpt ,

Also this report is an pre printed report , need to place data's exactly in stationary

so I hope according to my requirement  I did max.

abhilash_kumar
Active Contributor
0 Kudos

You could try your luck by posting this to the Ideas Place. Hopefully, many other users are also waiting for a better workaround.

If you do post this to the Ideas Place, please paste the link to the Idea here and I'll Vote Up. We could also ask Ludek to tweet it for us in hope that more votes come in.

-Abhilash

Former Member
abhilash_kumar
Active Contributor
0 Kudos

Thanks, Sri. I just voted up.

-Abhilash

abhilash_kumar
Active Contributor
0 Kudos

Please do tweet this Enhancement as well, .

-Abhilash

former_member183750
Active Contributor
0 Kudos

WILCO

DellSC
Active Contributor
0 Kudos

I have voted for it and posted it out to BOB and a couple of lists that I'm on .

-Dell

Answers (4)

Answers (4)

Former Member
0 Kudos

Sriram,

What version of Crystal Reports are you using?  I'm on 2008 and am curious if the issue has possibly been addressed in a newer version.  I would gladly upgrade to fix this problem.

If that's no good, have you come up with a good workaround?  I've searched and searched the vast corners of the internet with no luck on resolving this.

Thanks,

Chris

Former Member
0 Kudos

Hi sriram santharaman,

you can create suppress in crystal report using formula and hide page footer.

I hope you fix the issue.

abhilash_kumar
Active Contributor
0 Kudos

Thanks Nguyen, however that won't solve the issue.

The issue is specific to Sri's needs with no workaround in sight requiring an Enhancement Request to be posted which he already has.

If you scroll a few posts above, you should see the link to the Idea - Please go ahead and Vote for it.

, please don't forget to close this thread.

-Abhilash



Former Member
0 Kudos

Hi Abhilash ,

How to close this thread , If I click any one of the answer as correct answer , then this thread will get close ?

abhilash_kumar
Active Contributor
0 Kudos

Yes!

-Abhilash

Former Member
0 Kudos

HI Sriram,

U can use the hide formula

ON page footer:--

If PageNumberr <> 1

then

TRUE.

Former Member
0 Kudos

Have you tried a conditional 'clamp page footer' available in:

section expert > page footer

-Prathamesh

Former Member
0 Kudos

I do agree with Prathamesh on this.

-Uday.

Former Member
0 Kudos

Hi , Prathamesh

I tried with clamp page footer section , its showing that data's cover full page  from top to bottom .

Actually I didn't seen any difference in record  if I use clamp page footer .

if I check clamp page footer , then also its showing same level of record only , but its printing record from mid of the page .

Please check my image file for better understanding .

Former Member
0 Kudos

Hi Sriram,

In this case, along with Clamp page footer section option try to add some blank section below or above pagefooter section and adjust the height same as you require but supress that section for first page.

-Uday

Former Member
0 Kudos

Dear Balu ,

Why I need to add some blank section , Actually my query itself need  to avoid page footer reserved space , and shown data in full sheet of A4 page .

0 Kudos

this answer is really perfect and good working for avoiding space in page footer