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.
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 .
Notes: Special thank to Kamal Pasha my college to help me to resolve the problem.