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.
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,""+"%"
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.