Tables disappear without data

[#1]

hi

i built straight tables that every row is a diffrent calculation.

my problem is that: if i dont have data to show - like if the user chose (year=2010) and i dont have data for this year , the table disappear!!

i've tried to handle this with 'isnull' function , but it didnt succeed.

what should i do?

thanks

[vincent_ardiet]

Hi,

Have you try to use the calculation condition in the properties of your table (general tab) ?

With a formula like =Count(distinct [key field])>0 , you will have a message instead of no table.

Regards,

Vincent

[#3]

hi

this is my exp: sum({$<FACT_TAFTAF_KVUZAT_IFYUN ={'pigurim'}>}FACT_TAFTAF_Open_TafTAf)

in each row thete is diferent expretion.

i think i need some function that can handle with null values and perform 0 instead

thanks

[prieper]

Under Properties - Presentation you may untick "Suppress Zero Values" and/or untick "Suppress Missing"

HTH
Peter

[#5]

hi peter

thank you , this realy was the problem.

i never thought the answer is so simple..

elad