Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: page header display problem Post Reply Post New Topic
Author Message
Mellison
Newbie
Newbie
Avatar

Joined: 20 Nov 2009
Location: India
Online Status: Offline
Posts: 15
Quote Mellison Replybullet Topic: page header display problem
    Posted: 11 Aug 2010 at 2:26am
i have a formula which has to be displayed at the first page of the report(only once when report is getting generated) so i display it on the report Header. This result from this formula can grow more than one page.But the problem here is if the result from the formula grows more than one page then the page header is not displayed in the second page on the top rather it is displayed after the results from the formula gets completed suppose the results gets completed in the middle of second page then the page header gets displayed and then the remaining detail section starts.But the page header has to be displayed on top for each and every page.How to do this?Is there any design solution for this problem.

For Example

Sample Report
Page 1
                                 Report Header

Results from Formula.......
........................................
........................................
........................................
........................................
Page 2
........................................
........................................
........................................
                                  Page Header

                                  Detail section
..........................................
.........................................

Note: Here Report header and Page header contains same text

                            



Edited by Mellison - 11 Aug 2010 at 2:30am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Aug 2010 at 3:10am
why not suppress the report header.  If the page header and the report header have the same text, hide the report header and have the page header do all the displaying.
 
Does this help?
IP IP Logged
Mellison
Newbie
Newbie
Avatar

Joined: 20 Nov 2009
Location: India
Online Status: Offline
Posts: 15
Quote Mellison Replybullet Posted: 11 Aug 2010 at 3:34am
Thanks for the reply lockwelle,
                           Here i want the results of the formula to be displayed only once in the report but if i use the page header then the results of the formula might be displayed for each and every page.Is there any way to display it only once in the report using page headers
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Aug 2010 at 4:42am
if you only want it once, then the report header is the place to put it.
 
It shouldn't affect the page header.  I can see the first page header being affected, but you can just put a 'print page before' in the section expert.  Then you should only see it once and everything should display as desired...I think.
 
Any better?
IP IP Logged
sukhveer
Newbie
Newbie


Joined: 18 Aug 2010
Online Status: Offline
Posts: 22
Quote sukhveer Replybullet Posted: 22 Aug 2010 at 11:23am
A report header should be used if at all you would like your header to appear only once in your report. (it is a best practise)
 
However, if you insist on using Page header only.. then right click on the page header and select Format Text.. write a conditional suppress formula like pagenumber > 1;
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Aug 2010 at 3:16am
as for sukveer solution,, it seems fine, but rather than page number I would use:
not OnFirstRecord
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.