Hide field when excel

[2004 IR Help]

By: agb22 - andreagb

Hide field when excel

2005-05-31 14:57

Hi,

 

I want to hide the page number field when the report is generated in excel format, but keep that on pdf format.

 

Can anyone help me?

 

 

 

 

By: Chris - joshua_dawg

RE: Hide field when excel

2005-06-03 12:43

Hey!

 

Here's how I solved this problem. Once i determined which format I would be outputting to, I set a boolean variable to either True or False, depending on which format I would be outputting to. Then, I passed this as a parameter to the report and used it in a "Print When" expression.

 

In your case, if set the boolean to false for excel fomat, and true for pdf. Then use that parameter as the "Print When" expression for the page number text field. Hope that helps!