Input Parameter Comparison prior to report execution

[lori.stopka]

I am searching for a way to compare two input parameters prior to report execution.  I have two drop down selections, each containing values (Yes, No, Either Yes or No).  In our previous reporting tool we were able to interogate the values chosen by the user and stop them from running the report if they hadn't chosen "Yes" in at least one of the drop downs.   Not sure Cascading Input Parameters can help here. 

Any help appreciated.

Lori

[zh3ntil]

Hi,

Try to use dynamic queries in Studio

     Tutorial to use Dynamic Parameters in JasperSoft Studio 5.5

       

[lori.stopka]

Thanks for response but I don't see how dynamic queries will solve my issue.   I don't want the user to run the report.  I want the user to be told prior to running the report that they need to choose "Yes" in at least one of the two drop downs. 

Example:  In our previous reporting tool (Hyperion SQR), the SQR contains the code below.  Assigned and Occupied are two dropdown input parameters.

    if $assigned='Yes' or $occupied='Yes'
        Do Main        !OK to Run Report
    else
        Print 'ERROR: Either Assigned or Occupied must be set to "Yes"' ()     !Display Error to User
    end-if