Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
List-Box Multiple Values Parameter - "Select All" issues
Migrateduser
<p>Hello.</p><p> </p><p>I am having trouble with a report parameter. </p><p> </p><p>I have it set up as a dynamic list box, which allows multiple values to be selected, and I have added in a default value of "ALL" so that the user has an option to select all values. Additionally, the SQL statement will select all values by default (confirmed in SSMS). </p><p> </p><p>In the beforeOpen script of my data set I have included the following script:</p><pre class="_prettyXprint">param=params["report_param"].value;queryString = this.queryText;if (param != 'ALL'){queryString = queryString + " AND field IN ('" + params["report_param"].toString().replace(/,/g,"','") + "')";this.queryText = queryString;}</pre><p>This script works for selecting multiple values, however it does not work when I choose the default value of "ALL". I do not have this parameter linked to my data set in any other way, that I am aware of. Any advice or direction would be greatly appreciated! If you need more information, I'd be happy to provide.</p><p> </p><p>Thanks.</p>
Find more posts tagged with
Comments
There are no comments yet