TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Jennifer Day <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 6 Aug 2013 13:20:18 -0600
Content-Type:
multipart/related
Parts/Attachments:
text/plain (7 kB) , text/html (8 kB) , image001.gif (7 kB)
Thank you, Laura! That worked perfectly!

Jennifer

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Wenzel, Laura
Sent: Tuesday, August 06, 2013 1:06 PM
To: [log in to unmask]
Subject: Re: Suppress page header on first and last page of a report?

Hi Jennifer,

Try this:

if PageNumber = 1 then true
else if pagenumber=TotalPageCount then true
else false

I did a test on one of my reports with page headers and it worked the way you describe.

Best,
Laura

[cid:image001.gif@01CE92A7.B1DB3510]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jennifer Day
Sent: Tuesday, August 06, 2013 11:31 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Suppress page header on first and last page of a report?

Hi all,

Maybe someone who's good with formulas in Crystal Reports could help me with this. I want to suppress a page header on the first and the last pages of a report. In the Section Expert -> Common tab -> Suppress (No drill down) X-2, I can suppress it just on the first page with the formula "PageNumber = 1". I can suppress it on the last page with the formula "If pagenumber=TotalPageCount then true else false".

Is it possible to combine these two statements (or some variation thereof) so as to suppress my header on both the first and the last page of the report? (Sorry, very shaky knowledge of formula syntax...)

Thank you!
Jennifer

Jennifer Day
Registrar, Indian Arts Research Center
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504
Phone: 505-954-7205
Fax: 505-54-7207
[log in to unmask]<mailto:[log in to unmask]>

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.


ATOM RSS1 RSS2