Crosstab - DataValue

[rhymie]

Hello,

how can I change DataValue in Crosstab so as not to show 0 value

I tried with method Sub finish()

Sub Finish( )
Super::Finish( )
If DataValue = 0 Then
DataValue = Null
End If
End Sub

DataValue is numeric

regards

 

[rhymie]

Well, I've just made it :

Crosstab -> Crosstab builder -> Expression Builder

IIf (Sum(numeric_value)=0, Sum(numeric_value)=Null, Sum(numeric_value) )

I hope it will be useful for you.


But how to change a color depends on its value in crosstab ?

 

[Peter Headland]

IIf (Sum(numeric_value)=0, Sum(numeric_value)=Null, Sum(numeric_value) )

That is horribly inefficient and totally unnecessary. All you need to do is set the Format property of the value(s) to something like this:

0;;""

Check the manuals for more about using multi-part format patterns.

 

[rhymie]

thanks, it works great

but how to change colors ?