Print Page | Close Window

Count percentage of group - it's a bug?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14547
Printed Date: 06 May 2024 at 6:47pm


Topic: Count percentage of group - it's a bug?
Posted By: silesianeu
Subject: Count percentage of group - it's a bug?
Date Posted: 29 Sep 2011 at 12:33pm
Hi,

I have CrystalReports 2008.
I created simple report, It has two groups and fields into template. And I'd like show percentage group2 to sum of whole group2.


It looks like that:

group1 name
  group2 name     fieldFromDb
det: empty
             sum: summaryOfField

fieldFromDb is limited by input user parameter (user enter date) and formula looks like that: {?param} =  {fieldFromDb}. All is OK.
Row "details" is empty.

Next I want create new field type percent near fieldFromDb. It needs count: (fieldFromDb/summaryOfField)*100

sample:

Group1 Name1
   T1       384492   46,954%
   T2       434383   53,046%
       sum: 818875

But I've got on Preview tab:

Group1 Name1
   T1       384492  100,000%
   T2       434383   53,046%
       sum: 818875

Where is mistake? Any ideas?


Best regards,
Paul



Print Page | Close Window