Crystal report Crosstab percentage Rounding Problem Fix


When we use Integrated Cystal report of VS 2008 for report generation, it works fine except some special place. In my previous post in this blog some of those problem  were identified and i tried to give solution. Now i discuss another new point that was discovered and fix recently.

In crosstab report, if we use percentage based on count, there is rounding problem. Total sum of a row is not equal to 100. The Crystal report truncate the value after floating point automatically. I have searched in the net to find the reason of this behavior, unfortunately can’t get acceptable answer(may be i am not good googler !). So to save my self from client bullet, i have to think alternative.

A new custom field is created(Right click formula Field>new) which only count the record using blow formula,
————
WhileReadingRecords;
1
————–

Now this custom filed is used in cross tab. In this time, at first the sum is made of the custom field and then the show as percentage option of crosstab expert is checked.

This problem only occur only in the integrated Cystal report of VS 2008. So i was able to duck the client bullet .

………………………….
Khayer
GIS Programmer,
CEGIS

Notes: Special thank to Kamal Pasha my college to help me to resolve the problem.

Advertisements

6 thoughts on “Crystal report Crosstab percentage Rounding Problem Fix

  1. Thank you so much for posting this work around. I have been struggling with a solution for this problem for a long time. Cheers!

  2. Hiya very nice site!! Guyy .. Beautiful .. Amazing .. I’ll bookmark our site
    and take the feeds also? I am happy to fnd a lot of helpdul inf here
    in the put up, we’d like work out extra techniques on this regard, thanks for sharing.
    . . . . .

  3. Wow, thank you so much. This problem has been annoying me ever since I started using Crystal Reports… I only wish I’d found your site the last three times I searched for a solution.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s