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.

Jobs

Returning unmatched records

Returning unmatched records

(OP)
Using Crystal version CR Developer version 14.0.4.738 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?

Thanks
Bennie

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.

-LB

RE: Returning unmatched records

(OP)
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”.

-LB

RE: Returning unmatched records

(OP)
lbass,

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?

-LB

RE: Returning unmatched records

(OP)
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.

-LB

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!

Resources

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