Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Hide (suppress) Page Header Section, conditionally Post Reply Post New Topic
Author Message
sajhak
Newbie
Newbie
Avatar

Joined: 06 Oct 2009
Location: Sri Lanka
Online Status: Offline
Posts: 12
Quote sajhak Replybullet Topic: Hide (suppress) Page Header Section, conditionally
    Posted: 28 Oct 2009 at 3:00pm
Hi all,

in my CR , im having a "page header" section and a "details" section ..

The problem im having is, this page header is repeating for each and every case, which is not the way i needed.
What i exactly need is, to display the header section, only if items are available in details section ..

Please reply me , its an urgent one..

Thanks in advance
Saj
IP IP Logged
sajhak
Newbie
Newbie
Avatar

Joined: 06 Oct 2009
Location: Sri Lanka
Online Status: Offline
Posts: 12
Quote sajhak Replybullet Posted: 05 Nov 2009 at 11:20am
Any ideaa???? :( :(       
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 05 Nov 2009 at 11:36am

So are you just wanting a blank page if there are no details?

Is your report grouped in any specific way?
 
I'm going to write this and assume that you are grouped and that you want to show a blank page for the group if there are no details.
 
Use the sum function and create a COUNT of one of the fields in the details section. Insert this into Group1. Conditionally suppress the page header if the SUMFIELD=0.
 
This may not completely get you what you're asking for but maybe it will give you an idea.
 
If you explain a bit more maybe I could help more specifically.


Edited by FrnhtGLI - 05 Nov 2009 at 11:37am
IP IP Logged
sajhak
Newbie
Newbie
Avatar

Joined: 06 Oct 2009
Location: Sri Lanka
Online Status: Offline
Posts: 12
Quote sajhak Replybullet Posted: 05 Nov 2009 at 12:37pm
Thanks FrnhtGLI for your reply,

actually what i need is, i need to avoid displaying the header if there are no details in the details section .. currently the header(column header) is displayed in every page even though data is available or not..


To understand more easily i have drawn a sample .. as shown below , even if there is no data to be displayed in the 2nd page, still the table columns appear , which is the case i need to avoid.. here i have put those table columns into the header section of my CR. ..


(Page 1)
Name      Age     Sex     Status     City
AAA     23     male     Single     CCC
BBB     24     Male     Married     III
CCC     43     Female     Married     RRR
DDD     33     Female     Married     TTT
AAA     23     male     Single     CCC
BBB     24     Male     Married     III
CCC     43     Female     Married     RRR
DDD     33     Female     Married     TTT




( Page 2 )
Name      Age     Sex     Status     City
                    

// No data to display in this page, but still the column
header appears ..


Thanks
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 06 Nov 2009 at 5:07am

So then Page1 should be the only page and Page2 is printing for some unknown reason?

Try going into the section expert and checking suppress blank section.

 
It also may possibly be extra sections on the report (group footers, page footer, report footer) that can't fit on the first page and are forcing the second page to print to fit them. Try tightening up any sections or even suppressing them. Also, if Page2 is the last page of the report and you still need the page, go into the section expert, make sure the page header section is open, go into the suppress formula editor and type:
 
pagenumber=totalpagecount
 
That will suppress the header if it is flowing over to the last page of the report.
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.