nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Set Default value of Birt parameter with data from dataset

basami

Hi,
 
It is possible to set the default value of a parameter with data provided by a dataset?
 
I need that the parameter takes a default value from my dataset in order to use this parameter to select data of another dataset.
 
Thanks in advance for any help

Find more posts tagged with

Comments

Clement Wong

Attached is one solution.
 
There's just one line of code in the onFetch of the first data set to set a variable to the output you want to save.
<pre class="_prettyXprint">
myCustomer = row["CUSTOMERNUMBER"];</pre>
Then in the second dataset, the SQL is SELECT * FROM ORDERS WHERE CUSTOMERNUMBER = ?, and we update the Data Set Parameter and set the expression to "myCustomer;".
 
I had posted a previous example (<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35044-using-the-output-of-one-dataset-as-parameters-to-another-dataset-in-a-chain/?p=129985'>http://developer.actuate.com/community/forum/index.php?/topic/35044-using-the-output-of-one-dataset-as-parameters-to-another-dataset-in-a-chain/?p=129985</a>) that used a report variable instead to save the value.