Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Scripting value from dataset
aikeda
I have set up a dataset (let's call it "StoresDataSet") that lists some dynamic/static data, just a direct query from a table:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
select code, name from stores
</pre>
<br />
This will return a simple list:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
01 Sydney
02 Melbourne
03 Adelaide
...
</pre>
<br />
I also have a report Parameter set up (let's call it "param_StoreCode")<br />
<br />
Now I want to set up a dynamic text component as the title, with a value from the dataset based on a report parameter:<br />
<br />
This syntax obviously does not work:<br />
"Daily Report for " + dataset["StoresDataSet"][params["param_StoreCode"]]<br />
<br />
What is the correct syntax to achieve this?<br />
<br />
Things to note:<br />
The dataset does NOT have any filters configured or parameters.
Find more posts tagged with
Comments
cypherdj
I've answered a very similar query here -><br />
<a class='bbc_url' href='
http://www.birt-exchange.com/forum/designing-birt-reports/13905-database-value-dynamic-text-field.html'>http://www.birt-exchange.com/forum/designing-birt-reports/13905-database-value-dynamic-text-field.html</a>
;