Hi

How would I force a number to have no decimals in a formula in crystal reports .net? I've set the report's default number format to have no decimals and I can set a single number fields format to have no decimals but I am having problems with numbers showing up with decimals in formula fields. I've tried casting to an int using Int() but that didn't work.

Ex : This formula is used as the header for a cross table.

ToText(Int(tableName.NumberField)) & chr(10) &
ToText(Int({tableName.AnotherNumberField}))

The numbers show up as having no decimals using the "Main Report Preview" but the decimals come back when I publish the report on a webservice (the webservice creates a new reportobject and uses ExportToStream to create a PDF version)

Anyone have any ideas?

Andrew