How to convert the format?

[mariannextdoor]

Hi Friends,

I have created an MS Excel Report in Crystal Reports 10.The data that I have in excel report has numerical numbers like 100.00% or 102.00%. Now when I view the report in Crystal Report it is displaying the values 1 and 1.02 respectively instead of complete number with % sign. I believe the format has been changed automatically by the CR tool.So how can I rectify this and get the same display of data in the original format?? (ex 102.00% instead of 1.02).

I think this is quite a small deal but I am really lost and don't really know how to rectify this.

Any views or suggestions would be highly appreciated.
Awaiting for your response eagerly.

Thanks,
Aditya

 

[beltmanjr]

I made a test xls sheet with only one column. This is referred to as Sheet1.F1 in Crystal (replace by your own field):

Create a formula and type:

totext({Sheet1_.F1}*100,0) & '%'

This will display your percentages without decimals like
102%

{Sheet1_.F1}*100 & '%'

Will display including decimals like
102.00%

 

[mariannextdoor]

Thanks a lot for your reply. I had also made a dummy xls sheet. Now when I insert the formula with the desired fields, the formula does not get saved giving an error that the values should be boolean. Can you please tell me how to rectify this?

Thanks,
Aditya

 

[dgillz]

How did you create the formula? A boolean or T/F formula is typically only used in record or group selections and conditional formatting.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[beltmanjr]

Hey Mariannextdoor
Where are you creating this formula? Please note that this should be in crystal rather than excel.

And if you already did this in crystal, what did you click to create the formula and please copy paste the exact code here.

 

[mariannextdoor]

Well yes I had applied the same formula dat u gave in the formula for crystal reports. Its working fine now.
Thanks,
Aditya