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!

How to setup default value in paramter which would change every year

Status
Not open for further replies.
Aug 13, 2009
29
0
0
US
Hello,
I need to give a option in CRXIR2 report in a way that A user can enter the value in paramter or if they dont enter default value should be the current value in that field. Every year the value in this field changes, it has only value. Any ideas how to do that?. Thank you.
Lori.
 
Ok I came up with an idea
If ?Paramter = "*" then thresholdfield = thresholdfield else thresholdfield = ?Paramter , any other ideas?
 
Hi,
You cannot, I believe, make a field equal to itself as a record selection formula..

If it does not matter what value is in that field, then just use:

Code:
If ?Paramter = "*" then 
True
Else
thresholdfield = ?Paramter



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top