<p>I'm working on a report that has a different title depending on which parameter is selected. I need to add a new condition that will display a unique title if specific values are selected from TWO different parameters. Here's what I have:</p>
<pre class="_prettyXprint _lang-js">
<VALUE-OF>if (params["Categories"] == "F-MAC" and params["WorkCodes"] != "ALL")
{
"Furniture and Design"
}
else
{
if (params["Categories"] == "F-MAC")
{
"Move-Add-Change"
}
else
{
if (params["Categories"] == "F-DAMAGE")
{
"Damage"
}
else
{
if (params["Categories"] == "F-DISASTER")
{
"Disaster"
}
else
{
if (params["Categories"] == "F-PMB")
{
"Preventive Maintenance"
}
}
}
}
}
</VALUE-OF> Billing Report
</pre>
<p>The first line is the one I'm having the problem with. The "!= All" is just a placeholder. <strong>What I actually want to do is use "Furniture and Design" as the title when "F-MAC" is selected as the Category and both DESIGN and FURN are selected for the multi-value parameter WorkCodes. </strong></p>
<p> </p>
<p>I guess my question is, how would I code that? What exactly would the value of params["WorkCodes"] look like when both DESIGN and FURN are selected? Would it be "DESIGN,FURN"? Something else? Or is it not even possible to do this?</p>
<p> </p>
<p>Also, for some reason it's not even working when I try != "All". Can you not reference two params in the same line like that? Or did I mess something up somewhere? Any help would be appreciated.</p>
