Link to home
Start Free TrialLog in
Avatar of vbcosupport
vbcosupport

asked on

Crystal Report 10 suppress data when exporting to Excel Data only

Have a couple of columns in a CR10 report that I want to suppress when exporting to Excel Data Only. Have this formula that works great when exporting to Excel or PDF, but it adds a blank column in the Excel file when Data Only option is selected..

if {?@intFromMonth}=12 then
    formula = true
else
    formula = false
end if

Is there a way to suppress this column ??
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vbcosupport
vbcosupport

ASKER

hmm.. Ok. Thanks for the tip. Found some VB code that might do the trick post export.