×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Unable to export to excel with conditional suppress

Unable to export to excel with conditional suppress

Unable to export to excel with conditional suppress

(OP)
I'm sorry, I'm not sure this is the right forum for this kind of question. I'm using Crystal XI. In a group section, I use a formula to suppress unwanted values. When exporting it to excel, it stops and popups this formula. What is going on here? Thank you.

RE: Unable to export to excel with conditional suppress

So are you saying that you are getting an error in the formula?

RE: Unable to export to excel with conditional suppress

(OP)
No, the report runs without error. Error when I try to export to excel. Thanks.

RE: Unable to export to excel with conditional suppress

Is your suppression formula conditionally suppressing a group section Or is it a field suppression formula?

Also, please provide the suppression formula.

-LB

RE: Unable to export to excel with conditional suppress

(OP)
Data error. It fails when the filed is blank. I checked for null and missed blank. Thank you for your help!

RE: Unable to export to excel with conditional suppress

You haven't answered my questions.

Also, is the error message coming from CR or from Excel?

-LB

RE: Unable to export to excel with conditional suppress

Quote:

I use a formula to suppress unwanted values.

I wouldn't agonize on having "unwanted values" exported. Excel can quite easily filter the values you don't want. If it is unwanted columns, it would be even easier. First of all, and I would assert of primary importance, do not open the exported file with Excel. Doing so can result in some of your data being changed in unwanted ways. Text extracts should ALWAYS be opened within Excel using Data > Get External Data> From Text Files... where YOU can specify the Data Type of each column.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close