Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Formatting Report Data

Created: 21 Nov 2012

Sorry if this is the wrong place to ask if it is please let me know the right place.

I am (for the first time) working on a report in SMC all the data is displaying as I expect.  However I have a price column that gets its data from a decimal field in the DB and displays incorrectly.  I would like 0 to display as £0.00, 56.02 as £56.02 etc.

For the life of me I cannot see how I would do this.  I have looked at advanced formatting but this makes no sense at all and I have to help files that I can find.

Any pointer would be really appriciated.

Many Thanks