Skip to Content
avatar image
Former Member

static parameter not showing all values

Feb 20, 2018 at 07:37 PM | 16 Views | Last edit Feb 20, 2018 at 07:37 PM 2 rev.

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

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Abhilash Kumar
    Feb 20, 2018 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