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
Multiple dependent datasets
Migrateduser
<p>I have a report that has several datasets. the first 3 are used to define and pull a set of primary keys from a table. I set this up using the a couple of report parameters and then a cascading parameter group. This all works fine and the dataset populates with the keys. Here is my problem. I need to use this dataset as the source parameters to pull back data for 2 other datasets. The sql is somthing like this.</p><pre class="_prettyXprint _lang-sql">select * from myTable where id in (project_id)</pre><p>I'm replacing project_id in the beforeOpen event on the dataset</p><pre class="_prettyXprint _lang-sql">var rawIdString = params["ids"].value.join(",");var p_ids = rawIdString.split(",");var idString = "";for (var i=0;i<p_ids.length;i++){ if (i < p_ids.length - 1) { idString += "'"+p_ids[i]+"',"; } else { idString += "'"+p_ids[i]+"'"; }}this.queryText=this.queryText.replaceAll('project_id',idString);</pre><p>I have gotten it work when previewing the report but not in the stand alone report viewer. Is there another way to accomplish what I'm trying to do?</p>
Find more posts tagged with
Comments
There are no comments yet