Export page header to excel, but not report header

[mmwchac]

I am using version 9 (9.2.2.693) and I can export my field headings by unchecking the "simplify page headers" option in the excel export dialogue box. However, I also get my report header. I can't do away with the report header because I need it for printing in PDF format. Is there any way to export the page header objects ONLY without bringing along the report header? Thanks!

 

[synapsevampire]

I think that you'd need to create a parameter to conditionally suppress the report header.

A formula such as:

{?My PDF or Excel parameter} = "Excel"

-k

 

[mmwchac]

Pardon me for being "thick" but I don't understand the statement, {?My PDF or Excel parameter} = "Excel". I know how to conditionally supress but could you dummy down the syntax for me?

Thanks!

 

[synapsevampire]

I just used boolean logic, it would be the equivalent of:

if {?My PDF or Excel parameter} = "Excel" then
true
else
false

-k

 

[IdoMillet]

In case it's not clear, {?My PDF or Excel parameter} is a parameter that you would need to create in the report. It would prompt the user to indicate the desired format.


Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mmwchac]

IdoMillet,

Thanks, that's the answer I was looking for! However, I wasn't even aware you could use a parameter to tell the report what export format you want to use. What else might I need to know to set the parameter up? Sorry - I must sound like I'm a real newbie!!

 

[IdoMillet]

The parameter will not control the export format; it will only control whether or not the report header is suppressed.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mmwchac]

No wonder I've never heard of it! Duh!!

Thanks for your help.