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

Want to add parenthesis in Field of dataset

Sunil1

Hello all,
please Look into following image, there is "OBM" data set field in report design,
while i run the report i got the result which is as per second image,
in that i got value 12,
Now my question is
(1) can i display value of OBM field in parenthesis like (12) ?
(2) can i add Astrix to the value like 12* ?

Find more posts tagged with

Comments

Hans_vd

1: double click on the field in the table and go to the expressio builder; then enter 
<pre class='_prettyXprint _lang-auto _linenums:0'>"(" + dataSetRow["OBM"] + ")"</pre>
 
2: idem, but enter: 
<pre class='_prettyXprint _lang-auto _linenums:0'>dataSetRow["OBM"] + "*"</pre>
 
Regards 
Hans

Sunil1

Thanks hans for your reply,
Its very good idea.

I have another question:
suppose i have another dataset field named "TOTAL"
now when the value of TOTAL becomes greater than zero i want to print 12*(value of OBM with Astrix)

so How can i put conditions on dataset field(TOTAL) ?

Hans_vd

Something like this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (dataSetRow["TOTAL"] > 0) {
dataSetRow["OBM"] * 12 + "*"
}
</pre>
 
Regards 
Hans

Sunil1

Thanks Hans,
I done it as per your suggestion.

Sunil1

Following is possible only if OBM is string:
so, keep OBM's datatype as a string.

"(" + dataSetRow["OBM"] + ")"
and
dataSetRow["OBM"] + "*"

Sunil1

Hello hans, 
Following is my expression for OBM:

if(dataSetRow["OBM_BF_CORR"]>0) 
{ 
dataSetRow["OBM"]+"*" 
} 
else 
dataSetRow["OBM"]

should i have to create this type of coding block for each field or is there any feature in birt 
by which we can generate function which returns me string with * ? 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif 
 
Thanks, 
Sunil