How do I change the page header?

[jlgjohnson]

I would like to change the page header when group = AWARDED is a sales report. How can I do this? Any help would be great!

I know that I can add header b, but what formula would say IF pipeline.opps = "awarded" then (what would I put here?)

Or is this even right?

 

[AndrewBaines]

If all you want to do is to display one of two page headers, the easiest thing is to create two page headers, then conditionally suppress one or the other on each page.
In one page header, under suppress you'd have:

pipeline.opps = "awarded"

in the other, you'd have:
pipeline.opps <> "awarded"


Andrew Baines
Chase International

http://www.chase-international.com

 

[jlgjohnson]

Thanks Andrew. I did get that to work but now I have another question.

I had this formula in the supress section:

Remainder(RecordNumber,2) = 0

because I have highlighted lines.

Now that I have put the other formulas in there, I can't have both. How would I do the above formula also?

Jamie

 

[AndrewBaines]

Are they both in the page header?
If not, there's no problem.

If they are then use either:

pipeline.opps = "awarded" and Remainder(RecordNumber,2) = 0

or

pipeline.opps = "awarded" or Remainder(RecordNumber,2) = 0

depending upon the logic needed.

Andrew Baines
Chase International

http://www.chase-international.com

 

[jlgjohnson]

Kudos Andrew! It worked well. After I figured out if I wanted "and" or "or". Thanks much for the help.

Jamie Johnson