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; } } }

Data Set does not show any result

cha?s

Hi Forum, 
 
in my report I am using a Data Set with that query: 
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT TO_CHAR(SORT, 'YYYY'), SUM(P_KST), SUM(I_KST), SUM(BUDGET)
FROM PLM61PROD.T_DASH_KST
WHERE SPNUMMER IN (?) AND COST_UNIT = 240
GROUP BY TO_CHAR(SORT, 'YYYY')
ORDER BY TO_CHAR(SORT, 'YYYY') ASC</pre>
The parameter for the column SPNUMMER is stored in a Report Parameter. The value is for exmaple '06399','06777' but that does not work. The result set is empty. 
Changing the Data Set to: 
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT TO_CHAR(SORT, 'YYYY'), SUM(P_KST), SUM(I_KST), SUM(BUDGET)
FROM PLM61PROD.T_DASH_KST
WHERE SPNUMMER IN ('06399','06777') AND COST_UNIT = 240
GROUP BY TO_CHAR(SORT, 'YYYY')
ORDER BY TO_CHAR(SORT, 'YYYY') ASC</pre> 
Returns the expected results. 
 
What is wrong in the first statement? 
 
cha?s

Find more posts tagged with

Comments

Hans_vd

Hi cha?s,

In the first query you are comparing SPNUMMER to "'06399','06777'" (the entire string).

Take a look at http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html for a very good explanation to get round this.

Regards
Hans

cha?s

Hans

thank you for this short explanation.
Do I have to write my own function to enable a multi select?
The download link for the plugin did not work.

Regards
cha?s

cha?s

Ok, found the necessary jar files.

cha?s

Hi again, 
after installing the Plugin it is not possible to use the 
funtion MultiSelectSql. 
I try to add this code to my Data Set in the beforeOpen event: 
<pre class='_prettyXprint _lang-auto _linenums:0'>this.queryText = BlackboardFunctions
.MultiSelectSql(this.queryText, reportContext);
</pre>
Is that the right way? Where is this function located in Birt? 
 
cha?s