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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditions on Parameter input

Status
Not open for further replies.

ashark

Programmer
Nov 21, 2002
31
0
0
IN
Hi Group,
Can following Condition be placed on the input paramteres?
There are 2 input parameters A and B
and the Sum of A and B should not be greater than 100
eg 1. A - 85
B - 15 should be allowed
2. A - 25
B - 15 should be allowed

but A - 55
B - 55 should not be allowed

Can such a condition be placed?
 
This is a three step process but it works.

1)Create a record selection formula:
If {?ParmA}+{?ParmB} >100 then false else <<your normal record selection logic>>

2) Create a text object that says &quot;Parameter A and Parameter B are greater than 100, Please rerun the report with different values&quot;

3) Conditionally suppress this test object if the parameter total less than 100. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, Crystal Reports and Goldmine
dgilsdorf@trianglepartners.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top