Formatting Decimals

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi All,

Can someone help with the simple issue of formatting a decimal in a report record item?

I have a report with a currency column - currently this displays a pre-formatted string of 12345.10.  The problem with this is it does not sort unless I set the sort priority manually.

I would prefer to avoid setting the sort priority. - How can I format the decimal in the record item so it always prints 2 decimal places?  Currently the report control only displays 12345.1.

Thanks,

Chris

Product: Xtreme SuitePro (ActiveX) version 11.1.3 
Platform: Windows XP (32bit) - SP 2 
Language: Progress OpenEdge 10 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ChrisRichardson Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 24 March 2009 Location: United Kingdom Status: Offline Points: 4	Post Options Post Reply Quote ChrisRichardson Report Post Thanks(0) Quote Reply Topic: Formatting Decimals Posted: 06 October 2009 at 4:44am
	Hi All, Can someone help with the simple issue of formatting a decimal in a report record item? I have a report with a currency column - currently this displays a pre-formatted string of 12345.10. The problem with this is it does not sort unless I set the sort priority manually. I would prefer to avoid setting the sort priority. - How can I format the decimal in the record item so it always prints 2 decimal places? Currently the report control only displays 12345.1. Thanks, Chris Product: Xtreme SuitePro (ActiveX) version 11.1.3 Platform: Windows XP (32bit) - SP 2 Language: Progress OpenEdge 10

mdoubson Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 17 November 2008 Status: Offline Points: 1705	Post Options Post Reply Quote mdoubson Report Post Thanks(0) Quote Reply Posted: 07 October 2009 at 6:52am
	Use format settings "Your text filler %.02f"