Crosstab Percent of Total Formatting?

[gbrian]

The percent of total always rounds down for me.

I am using Crystal X. Is there any way to have the percent show up to 1 or 2 decimal places? I'm not in front of my report now .. is it as simple as selecting the total field in design view and using format field? If so, sorry for the post!

 

[Madawc]

Check the icons at the top - this ought to include one that shows decimal places being added or removed. This works when you have clicked on the field.

Or right-click, format field and adjust the number.

Or show in a formula field: ToText({your.Percent}, 2).

You can also set defaults File > Options > Fields.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[gbrian]

If I use the icons at the top or right-click format field, it doesn't do anything... my percentages stay the same (i.e.-- 25% stays as 25% instead of the 25.7% it should be)

 

[gbrian]

I notice there was a bug in Crystal Reports 9. Has anyone run into this problem in Crystal 10?

I need to deliver these reports to the client with tenths digits on my percentages...and I can't get it working!!

Any help would be greatly appreciated.

 

[lbass]

Please explain whether you are looking for percentages of the grand total or percentages of row or column totals. Please also provide the names of your row and column fields, along with your summaries.

-LB

 

[gbrian]

LB-


Here is my crosstab below. As you can see the decimal place is not showing (the 2% that is missing from the total). If I try to format this field to show the tenths digit, it does nothing. I have also tried selecting the field and clicking the "Increase Decimals" button.

MARKET VALUATION
Current Quarter
Fairly valued 46%
Overvalued 40%
Undervalued 12%
TOTAL 100%


Thanks ahead for any insight you might give!

 

[lbass]

Please see my post in thread149-1179423, which I think will address your issue.

-LB

 

[gbrian]

Ok, I will read this over and give it a try. So is this is a bug that has never been fixed?

Also, I have 8 cross-tabs on my report that have this issue. From briefly reading your post--it appears they will all have to be subreports due to the grouping.

A lot of work just to show some decimal places!

 

[lbass]

Why do feel subreports are necessary? I'm concerned that you might be misreading my suggestion.

-LB

 

[gbrian]

I read to quickly and thought you meant "GROUP BY" in Crystal...not in the command. Sorry!

This worked for me. However, it leaves the vertical space for the top 2 summaries on the cross-tab's. Any way around this?

And just out of curiousity--any idea why this bug has never been fixed? It was found in a 9.2.2 version of Crystal (you would think it'd be fixed by now). Would upgrading to Crystal XI fix my problems?

I do a lot of cross-tabs (for a financial company specifically). If I have to go through this on every cross-tab it will add hours.....

Thanks for your help!!

Brian

 

[lbass]

The lack of decimals also seems to be the case for XI. I assumed it was by intent, but not sure why.

Regarding the extra row space, drag the borders of the summaries until they are as thin as possible. Try it in design mode to make it a little easier. It should look pretty normal.

Also, if you are only displaying the percentages, you could use the suppression area for the command field summary to create the denominator value, and then use the summary you are using in the numerator for both the top value in the suppression area and the display formula in the display string area. Then you will only have one unused row to resize.

-LB