Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot format %of total in Cross Tab CR9

Status
Not open for further replies.

cjlarue

Programmer
Jun 27, 2001
240
US
Hello
Has anyone had a problem using the %of total in a cross tab in CE9 Dev 9.2.2 . It seems to work fine except I can't seem to adjust the number of decimal places to display. Always displays as 60% rather than 60.48 for example. When I try to change the format it reverts to the whole number. Is this a bug or another undocumented feature.


Regards
Chuck LaRue
ADRS Computer Services
 
Hi Chuck,

I just created a simply crosstab using version 9.2.0.448 and the "as percentage of" appear to work fine. I'd be happy to send you the simple sample report. Just a dumb thought: are you sure your column is wide enough to display the decimals?
 
Sorry This isn't and answer, but can you do "as percent of" in a crosstab in crystal reports 8.5
 
Thanks dpatrickcollins
Yea the column is wide enough to hold all the zero's I could want. I wonder if it is a bug in release 9.2.2. All other formatting works as expected. Please send the sample report along. clarue@rehab.state.al.us.




Regards
Chuck LaRue
ADRS Computer Services
 
Czalebx
This CR 9 is the first version with this feature. You might look at some other threads on how to use formulas to create percentage fields in earlier version cross tabs.


Regards
Chuck LaRue
ADRS Computer Services
 
Sorry for delay, chuck. Just examined my sample. It is showing decimal places all right, but they are all zeros. I'm afraid you have hit upon a bona-fide bug as far as I can tell.
 
Thanks for taking a look. I just sent it off to Crystal. Will update here when I get a reply.


Regards
Chuck LaRue
ADRS Computer Services
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top