General information
Title:
Removing decimals from numbers in formulas
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only