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!
  • Students Click Here

*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

Returning unmatched records

Returning unmatched records

Returning unmatched records

Using Crystal version CR Developer version RTM on a DB2 table

I’m converting a number field to text and prompting on the field. Sometime the converted number field results in a 0.

If I prompt for 235 for example, it will return records with a 0 and 235.

Why are the 0 records being returned and how can I stop it?


RE: Returning unmatched records

Are you using the prompt in a record selection formula or in a conditional formula? If some condition for a number field is not met, the default will be zero. Please show the formula you are using and explain where you are creating it.


RE: Returning unmatched records

The number field I'm converting to text is using this formula

Right (ToText({MyNumberField},0),3) Name of the formula is @ShipToArea. This is just a field on the report.

I also have a Parameter that is prompting for this value. Now in an attempt to "fool" Crystal to allow for more that one value, my select statement is
{@ShipToArea} in {?ShipToArea} and it is a string parameter

When prompted, I'm entering the values like 233, 234, 191

Not sure what I did but it seems to be working now.

If you have any suggestions on a better way to allow for an IN clause to be used with a prompt, would love the hear them.

RE: Returning unmatched records

You don’t need to ‘Trick’ Crystal to accept multiple values. Not sure why you are converting to text. You could just be using a number parameter, set up as a multiple value parameter. The report would be much faster doing it this way. You also don’t have to use “in”—you could just use an = sign and select multiple values—although it doesn’t hurt to use “in”.


RE: Returning unmatched records


The report runs automatically without any human interaction and it is getting the values from a table. Experimenting on my own it did not appear that I could do it as you described. Do you have any experience with a setup like this and if you do, will what you describe work?

Also I converted it text so I could enter ALL to get all territories on one report but I could have just as easily have used 999.

RE: Returning unmatched records

If there is no human interaction with the report, how is the response to the parameter generated?


RE: Returning unmatched records

We use a 3rd parts report scheduler (rePORTAL) and is has a feature called report bursting. Basically when the report runs it reads a table/field that has the parameters and the email address where the report is to be sent to.

RE: Returning unmatched records

Sorry, I’m not familiar with that. You said earlier that it was working, so you are probably all set then.


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