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
Dynamically modifying a data set filter with JavaScript
Migrateduser
<p>I have a data set created by a lengthy union of half a dozen tables.</p>
<p>I want the user to be able to filter this data set on multiple or all districts.</p>
<p>I created a multi-select report parameter which allows me to select several districts. This works fine.</p>
<p>I would like to add the default value 'All' so that the filter actually doesn't filter.</p>
<p> </p>
<p>Is there a way to do this?</p>
<p> </p>
<p>I was hoping there was way to modify the filter using JAvaScript in the BeforeOpen event script.</p>
<p>Another option would be to use JavaScript in the actual filter condition itself but I'm not sure which JavaScript would do the trick.</p>
<p> </p>
<p>Modifying the query text is too cumbersome because I would have to parse every table union.</p>
Find more posts tagged with
Comments
There are no comments yet