How to avoid displaying ? in cross tab result group

Hi

I have cross tab where i am dividing the result group by 1000 to covert in to Tonnes. But when the oput result for one row is 0 that is getting displayed as ?. To avoid displaying that in my cross tab i have to use some expression in expression builder.I dont know how to do that.I am using My Elcipse IDE to create reports.

So can any one suggest me how to display some value in place of ?

Thank you in advance

Vijay Kumar Bolisetti

Find more posts tagged with

Comments

vbolisetti

Hi

I am have a cross tab and am dividing the summary group value by 1000 to convert that in to tonnes.When there is no value or 0 it is displying ? in result table(crosstab Result).TO avoid this i came to know that we need to use some expression in expression builder.Can any one help me in writting that expression.

Any good site for reference.

Thank you in advance

Vijay Kumar Bolisetti

mwilliams

Hi Vijay,

You should just have to use an if statement like:

if (numerator == 0){
//set display value to 0
}

in your onCreate script for the display element.

Let me know if you have questions.