Solved

Crystal Suppress Header for specific parameters

Posted on 2011-02-23
5
469 Views
Last Modified: 2012-05-11
I have a huge crystal report that prints out different "pages" (headers) based on specific parameters.  I want to hide the main page header (our company logo) on 2 of the 25 pages.
I had it where if @p5 then true else false but then even if other parameters are picked it with that one, it hides it on those pages too.
Does that make sense?
0
Comment
Question by:fleets9876
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 34965591
Which 2 pages?

Can you identify the page from code like by page number?

mlmcc
0
 

Author Comment

by:fleets9876
ID: 34965601
No because you could pick many parameters or just 1.  If you pick 4 parameters, you would get 4 separate pages with different information on them.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 34965837
How do youknow which to suppress or when to suppress the logo?

mlmcc
0
 

Author Comment

by:fleets9876
ID: 34965874
right now that is what i am trying to do - suppress the header that has the logo if page 35 is picked.
But the problem is if they pick pages other than 35 too, it suppresses it on all pages.

Page Header a - Has logo
Report Footer a - ax - several different options (pages) to pick from.
It is a sales proposal report.  A sales rep can pick that they want page 4 (report footer d) which is a scope of work and page 7 (report footer h) which is a list of parts and pricing and also page 35 (rep ft ax) which is our contract.  I want it to show the header on page 4 and page 7 but not page 35.
If i do the supress where if page 35 is true then suppress, it supresses it for all pages selected because it think that since 35 is true then it should!  I can't think of a formula for it to say supress ONLY on report footer ax.   Sorry if this is confusing.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34965984
Try this idea
It seems to work in my report

Add a formula to the report header
WhilePrintingRecords;
Global BooleanVar  SuppressLogo := False;
""

Conditionally suppress the logo with this formula
WhilePrintingRecords;
Global BooleanVar  SuppressLogo;
SuppressLogo

In each of the RF sections add a formula.  Use True or False depending on whether to suppress the logo for that section
WhilePrintingRecords;
Global BooleanVar  SuppressLogo;
SuppressLogo := True/False;
""

I assume you have NEW PAGE BEFORE set for each section.

mlmcc
 
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question