Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter w/ a Formula

Status
Not open for further replies.

IronRocket

Technical User
Dec 28, 2005
74
US
I have a parameter that asks the user for an orders amount value. If they put in a certain amount, the report comes back showing everything in that field that is greater than that amount. However, anything less than the amount in that field shows a $0.00. So, from there, I formatted the field to where I try to suppress it by choosing the suppress option button and my conditional formula is "{Orders.Order Amount} = $0.00". This doesn't suppress the $0.00 value. Just wondering how I can suppress anything that is less than what the user puts in.
 
Maybe you can rethink it and drop the orders in the Select Expert, using the parameter. So if the parameter for example is "Order Amount" and you want the user to enter the dollar value for minimum order amount, then the Select Expert would say:

{orderamount} >= {?Order Amount}
 
Bingo! It worked. I didn't have anything in my select expert, that was my problem. Thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top