cancel
Showing results for 
Search instead for 
Did you mean: 

static parameter not showing all values

Former Member
0 Kudos

i'm having many issues

1. trying to have a promt over a vendor number in the database vendor stored as char i'm trying to have a vendor static optional parameter i have tried this

in formula {APDISTRIB.VENDOR} = {?Vendor Number} and this in the selection fourmla ltrim({APDISTRIB.VENDOR}) ={?Vendor Number} still returning nothing. please help

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Mira,

If you'd like the report to return ALL Vendors when no values after entered/selected in the prompt, then you'd need to use the following Record Selection Formula:

(Not(HasValue({?Vendor Number})) OR {APDISTRIB.VENDOR} = {?Vendor Number}) 

-Abhilash