Select statement not returning data

[BlurredVision]

I have the following select statement based on parameters. The first part of the statement 'The issues parameter' works fine, but if that parameter is left blank the report fails to return any data.

Any ideas what I my be doing wrong? Thanks for your help..

if {?Issues} = "Open Issues Only" then {RV_Practitioner_RelationsHeader.IssueClosed} = True else
if {?Issues} = "Closed Issues Only" then
{RV_Practitioner_RelationsHeader.IssueClosed} = False else
if {?Issues} = " " or {?Issues} = "" then
({?Issues Opened By} = {RV_Practitioner_RelationsHeader.IssueOpenedBy} or {RV_Practitioner_RelationsHeader.IssueOpenedBy} = "" or {RV_Practitioner_RelationsHeader.IssueOpenedBy} = "''") and
({RV_Practitioner_RelationsHeader.IssueOpenDate} in {?Issues Opened Date Range}) and
({RV_Practitioner_RelationsHeader.IssueCloseDate} in {?Issues Closed Date Range}) and
({?Issues Forwarded To} = {RV_Practitioner_RelationsDetail.ForwardTo} or {RV_Practitioner_RelationsDetail.ForwardTo} = "" or {RV_Practitioner_RelationsDetail.ForwardTo} = "''")

 

[Katy44]

In these cases could {?Issues} be null rather than blank?

In which case you need to check if isNull({?Issues}) then... and you need to do this first, before any other checks on it at all.