Print Page | Close Window

Page Footer Orentation

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21093
Printed Date: 06 May 2024 at 7:36am


Topic: Page Footer Orentation
Posted By: Dr4ke
Subject: Page Footer Orentation
Date Posted: 02 Oct 2014 at 6:31am
Good afternoon,

I currently have a Page Footer which contains the page number and my company logo. The problem I am currently experiencing is that when I use Landscape orientation on pages the logo (far right in the design view) appears in the center.

I cannot change the Report Footer to be Landscape or move/copy the logo to the far right for the Landscape pages....

Is there a way around this?


Replies:
Posted By: lockwelle
Date Posted: 03 Oct 2014 at 5:22am
why not have 2 logos, one that is suppressed if the orientation is landscape and one that is displayed.

if you have a way of rotating the page, there must be logic that can be used to move the logo or conditionally suppress it.

Posted By: Dr4ke
Date Posted: 03 Oct 2014 at 5:49am
There isn't the ability to have a logo at the desired location (far right of a landscape orientation) and I can't amend the orientation to landscape...

Posted By: z9962
Date Posted: 05 Oct 2014 at 9:40pm

Is it happening when you change the page between portrait/landscape through the selection expert?

 
You do have a function CurrentPageOrientation which will equal crportrait or crlandscape
 
You can then have two PFs and use the above function to suppress depending on the layout.
 
To design the landscape version you will need to change the whole report to landscape, design as required then change back to portrait as crystal doesnt like you putting things off the edge of the page.

Posted By: Dr4ke
Date Posted: 05 Oct 2014 at 10:17pm
Morning,

I think that's the problem I can't change the page between Portrait/Landscape through Selection Expert; the 'Orientation' section is completely greyed out.

The function and design help provided is going to prove really useful if I can get the 'greyed out' issue resolved :-).

Posted By: z9962
Date Posted: 05 Oct 2014 at 10:19pm
what section are you trying to change the page orientation?

Posted By: Dr4ke
Date Posted: 05 Oct 2014 at 10:23pm
The Page Footer

Posted By: Dr4ke
Date Posted: 05 Oct 2014 at 10:24pm
Everything apart from Page Header and Page Footer appear to allow orientation configuration...

Posted By: z9962
Date Posted: 05 Oct 2014 at 10:28pm
you need to change it in the group or details section.
 
What you can do is in the group, create two sections.
A for portrait, B for landscape
if both sections do a custom suppress depending on your criteria, therefore it will only change when that criteria is met.
 
you should also have new page before or after set for that group depending on your requirements.
 

Posted By: Dr4ke
Date Posted: 05 Oct 2014 at 10:30pm
Thank you for that - I think I need to reread it a couple of times and think about what Changes are needed to my report (luckily it's made up of subreports so won't be too difficult to execute).

I'll try it and report back. Thanks again!

Posted By: Dr4ke
Date Posted: 07 Oct 2014 at 2:02am
I have tried this method but unfortunately I do not have groups in my main report. I tried creating one and putting the logo in the Group Footer but this didn't work at all.

What is the correct method to create two Page Footers from a Details section??

Posted By: z9962
Date Posted: 07 Oct 2014 at 2:06am

Do you have the alternating pages now? ie some landscape some portrait?

You are using the group just to control the change from landscape to portrait.

You create two page footers, use the custom suppress using CurrentPageOrientation=crportrait or crlandscape

 

Posted By: Dr4ke
Date Posted: 07 Oct 2014 at 2:12am
Yes - I have 12 portrait and 5 landscape. I have created a group and an extra Page Footer (so I have Page Footer A and Page Footer B) but I still cannot change the orientation?

Posted By: z9962
Date Posted: 07 Oct 2014 at 2:15am
in page footer A (landscape) add the custom suppress CurrentPageOrientation=crportrait
in page footer B (portrait) add the custom suppress
CurrentPageOrientation=crlandscape
 
Design PageFooterB as required (for portrait view)
 
Go to page setup and change your report to landscape
Design PageFooterA as required for landscape view
 
change page setup back to portrait view.

Posted By: Dr4ke
Date Posted: 07 Oct 2014 at 3:17am
Thank you for your help; it led me to a slightly different way that worked for my report without adding in a group.

I created a second Report Footer (A & B) as you recommended, extended the logo size (i.e. added in white space to the left of it) so it was considered an 'over hang' and then suppressed each section using the CurrentPageOrientation function.

Posted By: Dr4ke
Date Posted: 07 Oct 2014 at 3:58am
Although this worked unfortunately, because there are two Page Footers (A & B), the Logo on one of the page types (Portrait or Landscape) does not appear at the bottom of the page (it floats slightly above).

The sections have conditional fomatting applied but this doesn't remove the problem; is this something that can be resolved??

Posted By: Dr4ke
Date Posted: 07 Oct 2014 at 4:07am
Managed to figure this out...

If you select 'Reserve Minimum Page Footer' on the Page Footer section in Select Expert (Not A or B) then it will only reserve the space for those needed.

Reference: http://www.codeproject.com/Tips/694808/Remove-Blank-Space-in-Crystal-Reports-Footer-Secti


Print Page | Close Window