number format lost in Crystal Enterprise

[heidi88]

I have a formula calculation sales marging in % format. Crystal report designer shows 20%, after publish the report into Crystal enterprise that field shows $20.

Does someone know why?

Thanks

Heidi

 

[synapsevampire]

Consider that the solution is probably version dependent, which you omitted.

It also might depend upon how you've created this percentage display (there are different means), perhaps you can share that also.

-k

 

[heidi88]

Oh, you are right.

I created the report in CR 8.5 and publish it in CE 9.0

 

[heidi88]

In term of how I created the percentage, I use formula like:

(Sales-Cost of sold)/Sales *100,

Then turn on the % sign on the menu bar.

Please let me know if you need more info.

Thanks a lot.

 

[synapsevampire]

I think that a service pack in CE addressed this, at any rate, apply the service packs religiously:

http://support.businessobjects.com/fix/hot/si75/?ref=default.asp_selectlist

And then as a trick try formatting it by selecting the number, right click, format Field->Number->Customize->Hit the currency symbol tab->Enable Currency Symbol->Fixed->Position(123)$->and change Currency Symbol to percent.

Another means is a formula containg:

totext((Sales-Cost of sold)/Sales *100,0,"&quot+"%"

-k

 

[heidi88]

I have another un-related question and hoping you can help.

Whenever I use activex viewer to view report on CE 9.0, it gives me red-x on the top and nothing happens. When I first launch the report, it did ask me to install ActiveX component, I guess I didn't choose yes. How can I get the prompt back again?

Thanks a lot.

 

[synapsevampire]

It's generally best to start new threads so that people might find related ones.

Here's the whitepaper:

http://support.businessobjects.com/library/kbase/articles/c2004405.asp

-k