Joined: 15 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 7
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?
Joined: 15 Oct 2008
Location: United Kingdom
Online Status: Offline
Posts: 7
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.
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,
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