Skip to Content
avatar image
Former Member

static parameter not showing all values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 20 at 07:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded