Skip to Content
0

static parameter not showing all values

Feb 20 at 07:37 PM

15

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Feb 20 at 07:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded