Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: % in auto crosstab in CR11 Post Reply Post New Topic
Author Message
hermiod
Newbie
Newbie
Avatar

Joined: 15 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote hermiod Replybullet Topic: % in auto crosstab in CR11
    Posted: 19 Jul 2010 at 2:47am
I have 2 fields and wish to express one as the percentage of another within an auto-crosstab.
Is this possible in 11.5 or will I have to use manual crosstab?

Grid looks like this currently:

Area       | C1 | C2
--------------------
Grouping 1 | 20 | 15
Grouping 2 | 30 | 20

I'd like to have another column on the end of this crosstab showing C2 as a percentage of C1.
IP IP Logged
Shures
Newbie
Newbie


Joined: 21 Apr 2010
Location: United States
Online Status: Offline
Posts: 3
Quote Shures Replybullet Posted: 30 Jul 2010 at 6:46am

Were you ever able to figure this out?  I have the same problem with my cross tab. 

The formula I wrote works for the percent of the list as a whole but not each individual row. 
 
Name   Made  Total   Percent
Dave       66     100        66%  <----How do I get that number?
Larry       54     108        50%  
IP IP Logged
hermiod
Newbie
Newbie
Avatar

Joined: 15 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 7
Quote hermiod Replybullet Posted: 30 Jul 2010 at 11:07am
I don't think there is a way to do it in CR11 although I think you can do it in 2008.

The only way I can think to get around this is to have the percentage as a column in the source SQL but that only works if you are getting the data out of the database as you wish to display it rather than aggregating from source data within Crystal.

You could always try it as a SQL expression I suppose, that may have the desired effect.

I ended up just building this as a manual table in the end.
IP IP Logged
sunnyday
Newbie
Newbie


Joined: 26 Jul 2010
Online Status: Offline
Posts: 8
Quote sunnyday Replybullet Posted: 03 Aug 2010 at 6:53am
how do you create a manual table? in a crosstab report, the values are referencing the same database field. how can you get around this manually? i'm asking because i have the same problem where i need to create a formula based on 2 values in a crosstab report, but it can't be done.
Thanks,
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.027 seconds.