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


Parameter Issue

Parameter Issue

Parameter Issue

I have created the attached parameter into a report. The field is integer and linked to a SQL database

It asks for the order number when I refresh the report, but then goes through every order number and then displays all the orders not just the one I have entered. Any ideas why the parameter is not just picking up the order number I have entered?

Attached is a screen shot of how the parameter is set up currently


RE: Parameter Issue

Make sure you used the parameter in your record selection:

{yourOrdernumberField} = {?yourParameter}

RE: Parameter Issue


Sorry don't quite understand what you mean. When I refresh the report it asks for the ordernumber but when I enter one it goes through all orders, I can seem to make it just look and bring up the order only with that order number?


RE: Parameter Issue

Setting up the parameter is the first step. The next step is to make it part of your record selection.
On your menu bar: Report / Selection Formulas / Record - In the formula box:

{yourOrdernumberFieldName} = {?yourParameterName}

RE: Parameter Issue


Ok got you, all working fine now, thanks for the help

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!

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