Display of multiple parameters.

Good morning!
 
I have an issue with the display of multiple parameters.
I am using mblockâ€™s report design for reference (â€œInClauseTestâ€): I have
<pre class="_prettyXprint">
HR_APPOINTMENT.C_COURT IN ('****')
</pre>
in my DataSet and
<pre class="_prettyXprint">
this.queryText = this.queryText.replace("****", params["C_COURT"].value.join("','"));
</pre>
in my DataSetâ€™s script.
 
It works well, but I get duplicated rows as a result (screenshot is attached).
 
Is there a way to:
1. get rid of excessive rows;
2. and, very important, to display information in line? Meaning, â€œPARAM_1, PARAM_2, PARAM_3â€ and not one above the other. User will choose as many parameters as he wants, so, he can get over 10-20 names, it will be visually much more comprehensive to see them neatly in line separated by commas.
 
Thank you in advance!!!

Find more posts tagged with

Comments

micajblock

Can you share your design and query?

alecsia

I deleted all excessive tables in my report, I attached the sample only with tables with issues and I did the screenshot to show the result I have now.
 
I guess I figured this out a bit. I managed to get better results: I placed the header in the Header section on the Table, so it doesnâ€™t duplicate now. I even manipulated borders so that I donâ€™t have a border between names when they pile up on each other. The second one is the original: I guess the problem was with my attempt to pass parameters from one table to another within it. When I figured out that wasnâ€™t necessary, I didnâ€™t change the binding, although I deleted all parameters I created.
 
Now everything looks like on the screenshot! So, the first table works almost perfectly.
 
I still have one issue: it would be better to display parameters in one row separated by commas!

micajblock

Either use the Concatenate aggregation or simply display the parameters by using a data item with this expression:
<pre class="_prettyXprint">
params["C_COURT"].value.join("','")</pre>

alecsia

Works great!!! Thank you a lot once again!!!