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

Empty column in crosstabs

zharenkov

Hello,
I've got birt report with 2 crosstabs in it. The tabs contain the name of the service as header and customers rating as row values. In each crosstab i've got first column without header and with 0 in each row.
 
I tried to use "Visiblity" tab with the rule like this
<pre class="_prettyXprint _lang-xml">
data['category']==""
</pre>
but that has no effect. Also I tried to add if statement in fetch script - again no result.
 
Is any way to hide this columns in report?
 
In attached files there are my birt report and pdf file, where you can see first empty columns in each table
Thanks

Find more posts tagged with

Comments

mwilliams

Sounds like you could filter the null values for that dimension on your dataset and that value would not exist in the cube to be shown in the crosstab. Let me know.

zharenkov

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="131775" data-time="1415029183">
<div>
Sounds like you could filter the null values for that dimension on your dataset and that value would not exist in the cube to be shown in the crosstab. Let me know.
</div>
</blockquote>
I tried to add if statement in fetch script
<pre class="_prettyXprint _lang-nocode">
if (serviceName!=null){
//here some code
}

</pre>
but empty columns are still in my report. Or you mean filter in open script?

mwilliams

With a scripted dataset, you'd need to handle stepping to the next row of data in your fetch script. If not, you'd still push the empty rows through because each time that function processes, it creates a row. Or, you could pre-process the data in your open script to strip out the rows with a null value so you don't have to worry about incrementing through your data in the fetch.

mwilliams

You could also probably just put a filter on your crosstab.