Cross Tab Problem

Hi,
I am adding cross tab into my report. I want to display results of sum as "0" if there is no value for it. Please let me know how can I do it.

for ex..
Columns: a b c

Data: 0 2 0

Total 0 2 0

Thanks for your help.

Thanks

Find more posts tagged with

Comments

mwilliams

Hi Susmitha,

What do you currently get?

Susmitha

Just a blank value.

Thanks,
Susmitha

Susmitha

Hi Michael,
actually my example is not right. Sorry for that.
here is my updated example

Columns: a b c

Data: 0 2

Total 0 2 0

the value for C column is empty. But I want to display sum as 0.

Thanks in advance for your help.

Thanks,
Susmitha.

mwilliams

Susmitha,

If you put this in the onCreate method for the Total line, you should get what you're looking for.

if ( this.getValue() == null){
this.setDisplayValue("0")
}

Let me know.

Susmitha

Thanks very much Michael. I am able to do it.

Thanks,
Susmitha.