Crosstab printing 0.00

rbuser

is it possible to tell the cross tab to show cells with "0.00" values?
Actually those values ar not printed.
(Using 7.04)

thank you
christian
EULANDA Software

nicocizik

Hi Christian,

I'm a bit unclear about what you would like to happen. In my testing, when
the crosstab tries to access a 0 numerical value, it prints 0.00. Are you
talking about null values?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Sorry, i mean the other way.
Is it possible to not print "0.00" if the value is "0"? Like in DbText and
float. There is also a property to do this. So all values with "0" should
print as "blank".

chris

nicocizik

Hi Chris,

Try using the OnGetDementionValue event of the crosstab component to alter
the output. As a quick test, the following code worked the way you wanted
it.

procedure TForm1.ppCrossTab1GetDimensionValue(Sender: TObject; aDimension:
TppDimension; var aValue: Variant; var aSkip: Boolean);
begin
if aValue = '0.0000' then
aValue := '';
end;

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com