INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

(OP)
Crystal Reports 10
MS SQL Server 2008 R2.

Two Show/Hide Headers are in the main report, grouped by XX.
Header 1 shows for page 1 for each new subject in group, else hidden.
Header 2 shows for all additional pages for each subject in group, else hidden.

E.g.,
Header 1
Group XX, A subject, page 1 only, else hide.
Header 2
Group XX, B subject, page 2 onwards, else hide.

Pagination returns to page 1 after the final record in the detail for each subject.

After the last record for the entire group XX, I have a cross-tab in the Footer.
I want to hide Header 1 on page 1 of the crosstab display.
Header 1 is already hidden for pages 2 and onwards because of the hide logic in place.

I am using the Variable:

Shared NumberVar PageofLastField;

If OnLastRecord then PageofLastField := PageNumber;


Then, placing the following code in the header section that I wish to hide:

Shared NumberVar PageofLastField;

PageofLastField := PageofLastField;

if pageofLastfield = 1 then false
else
if pageofLastfield <> 0 and PageNumber > PageofLastField
THEN TRUE
ELSE FALSE

However, this isn't exactly what I need because, of course, the Header appears where the page numbering for the cross-tab pages reverts back to one.

What solution can I use to hide Header 1 on the first page of the cross-tab?

Thanks!

RE: Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

Create 2 formula fields:

@SwitchPageHeaderOn
WhilePrintingRecords;
booleanVar ShowPageHeader := Yes

place it in the group2 header(make font white on a white background to hide it)

@SwitchPageHeaderOff
WhilePrintingRecords;
booleanVar ShowPageHeader := No

place it in the group1 footer
in the header's section expert, suppress the header with the formula;

WhilePrintingRecords;
booleanVar ShowPageHeader;
if ShowPageHeader
then
No
else
Yes


In my Scenario,; I have no details only group1 header & 3 x group2 footers each with a pivot table
My group1 is SupplierName
Group 2 is the CostType(Freight, Additionals,Destination)- so a pivot of each

The first page of pivots Supplier has the Group1 header "SupplierName1
the subsequent pages of group 1 have 1 header : "SupplierName1 continued...."

I think this is what you want, if not, it's near enough to edit for your purposes

RE: Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

hmax
Did NickieP's help? If so, it is polite to acknowledge the poster's assistance (the Great Post purple star is a good way to do so), and also helps others to know if the proposed solution worked or not. Failure to at least acknowledge and thank those trying to help may result in them deciding not to assist you in the future.

If it didn't work or didn't provide the result you were looking for an explanation might mean someone else can help you.

RE: Crystal Reports 10; MS SQL Server 2008 R2. Hide Header for cross-tab in footer.

(OP)
NickieP:

Thanks for getting back to me. Just reading your response now. Normally I receive an email when a response post appears - unfortunately I must have missed it this time around.

Truly appreciate your feedback. I will have to test out the scenario, but as you suggest, it's near enough to do some edits if necessary.

pmax9999:

Thank you for your response, too, and you are absolutely right. Apologies for the delay on my part, and Nickie has received the purple star!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close