Multiple parameters within beforeOpen script

Erebel55

I am very confused and frustrated with this..I'm trying to have a report that has 2 prompts and the values of these should change the SQL for my dataset. However, for some reason when I add the second parameter to my script it messes everything up. Can someone please take a look at this?

I have attached 2 different attempts at this report..the script in question is the Result Query beforeOpen script. Can someone please help, I have no idea what is going wrong.

Erebel55

After looking at this longer, I found one problem I think..<br />
When I do this..for some reason it isn't entering the if here..I have no idea why it wouldn't because when I run I only select one value for this parameter..I even have it so multiple values aren't even supported yet. So why would this be happening?<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>// Parameter 2
var paramName = "ImpactSeverity"; //report parameter

paramLength = reportContext.getParameterValue(paramName).length;

// One impact assessment type was chosen
if (paramLength == 1)
{
// Replace the default phase type with the single user selection.
param = reportContext.getParameterValue(paramName);

this.queryText = this.queryText.replace( "High", param);
//this.queryText = this.queryText.replace( "AND info.CONFIDENTIALITY_IMPACT = ('High')", replaceString);

}</pre>