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

Allowing a Blank Parameter

Status
Not open for further replies.

checkai

Programmer
Jan 17, 2003
1,629
US
After installing the updates for Daylight Savings Time on our Enterprise Server, we are seeing an issue with a report that asks for a string parameter value. A user should be able to leave it blank. However unless they type something in, even a space, the report will not be allowed to run. Is it possible to allow a blank value??

"...your mom goes to college..."
 
The common solution is to set a default value of All and code for it in the Report->Selection Formula->Record:

(
if {?MyParm} <> "All" then
{table.field} = {?MyParm}
else
if {?MyParm} = "All" then
true
)

-k
 
Shouldn't you be able to just leave it blank? My current work around is to put a space in as the default...

"...your mom goes to college..."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top