on 10-15-2013 7:19 AM
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
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
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.
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
Dear Abhilash ,
Please check this link
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sriram santharaman,
you can create suppress in crystal report using formula and hide page footer.
I hope you fix the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
HI Sriram,
U can use the hide formula
ON page footer:--
If PageNumberr <> 1
then
TRUE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you tried a conditional 'clamp page footer' available in:
section expert > page footer
-Prathamesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.