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

How to display 0 in crosstab cell if there is no value in database for that cell?

sunnypatel285

I made a crosstab.In that crosstab some of the cells are displayed blank because of no values in database for that cell.
So , I want to display 0 as the value for that cell.

So ,what is the script for script

onCreateCell( cellInst, reportContext )
{

}

Plz,help me.

Find more posts tagged with

Comments

SiBry

Hi,

Im new to BIRT but i think that if you select the crosstab from the layout editor, then using the "Property Editor - Cross Tab", select the "Empty Rows/Columns" properties tab. Scroll to the bottom of the Empty Rows/Columns window and at the bottom there is an option called " For empty cells, show:", then you can add anything you like as the value i.e. "0". This can also be a character or special character.

I hope that helps.

Simon.
Using Eclipse Birt 2.6

sunnypatel285

<blockquote class='ipsBlockquote' data-author="'SiBry'" data-cid="98135" data-time="1332421807" data-date="22 March 2012 - 06:10 AM">
Hi, 
 
Im new to BIRT but i think that if you select the crosstab from the layout editor, then using the "Property Editor - Cross Tab", select the "Empty Rows/Columns" properties tab. Scroll to the bottom of the Empty Rows/Columns window and at the bottom there is an option called " For empty cells, show:", then you can add anything you like as the value i.e. "0". This can also be a character or special character. 
 
I hope that helps. 
 
Simon. 
Using Eclipse Birt 2.6 </blockquote>

sunnypatel285

Thanks SiBry....

It works fine as exactly i want to do...

SiBry

Hi,

As mentioned i am new and only use the designer view, not the script, but i changed to XML view and the following is what i found in the body area of the crosstabe section of the xml view
<property name="emptyCellValue">0</property>

Try adding this to the body of your XML page and see if it helps, if not why dont you just use the designer view and select the options i mentioned in first reply.

SiBry

sunnypatel285

Yes it also works SiBry....