Format fields in Crystal Report
Posted on 2013-06-05
I'm fairly new to C# programming, and I'm using Visual Studio 2008 and Crystal Report to generate some reports. Problem is:
I've written a program to give me an xml file from a PDA.
The xml fields/nodes get imported to my Crystal Report, however, all the fields are "string" format. I have a date field, but it shows as "2013-06-05T00:00:00-07:00"
What should I do to get this displayed as a proper date field, i.e. "5 June 2013"
Do I need to create a parameter or formula field?
Also, I got a field with numbers. Example: "39.2857142857143"
I want this to be in percentage with and only 2 decimal places.
These are the two issues I'm stuck with at the moment.
If you can help me with the steps I need to take in order to achieve this, I would appreciate it very much.