Skip to Content
Former Member
Oct 29, 2015 at 10:36 AM

Multi Parameters only returning first criteria?



I've create a report with multiple parameters but when the report is run it only returns the first parameter.

For example the code is:

If {?Supplier} = 'z' then {Supplier_Code} = {Supplier_Code} else {Supplier_Code} = {?Supplier} and

if {?Date} = 'z' then {Date_Field} = {Date_Field} else {Date_Field} = {?Date} and

if {?Stock} = 'z' then {Stock_Field} = {Stock_Field} else {Stock_Field} = {?Stock}

When the report runs it uses what I've entered in the supplier and only returns that supplier but returns all dates and all stock codes. If I swap date for example as the first line of the code that returns the date criteria but all suppliers and stock codes regardless if they've been entered or not.

I use the 'z' criteria to return all data even if nothing is specified.

If you can help that would be great.