Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design  
Message Icon Topic: Crosstab Totals and Formula Post Reply Post New Topic
Author Message
alfiet
Newbie
Newbie


Joined: 05 Apr 2019
Online Status: Offline
Posts: 1
Quote alfiet Replybullet Topic: Crosstab Totals and Formula
    Posted: 12 Apr 2019 at 1:00am
Hi, I've been away from CR for a few years (having been using SQL Report Services instead) and can't remember how to do much, so i'm hoping someone may be able to help me with a specific issue!

I have a crosstab that has two row fields (Customer and Year - the Year will be Current Year and Last Year and possibly the year before last year as well) and a column which we call Type. The Type's are things like Units, Value, Profit etc. I have managed to suppress the Grand Totals, but can't work out how to suppress the Totals being displayed for the Type columns. For example, I'm seeing a total units column for a customer for the last three years - this isn't a useful number for us so we'd like to suppress it. All Suppress Totals options have been selected in the Crosstab Expert window.

Secondly, instead of the Total we'd like to see difference and percentage difference between each subheading for the Current Year and Last Years numbers (i.e. the difference between this year and last years Units, Value, Profit etc). I could do this with extra SQL views but wasn't sure of this can be done in the crosstab instead?

Hopefully this makes sense.

Thanks

Edited by alfiet - 12 Apr 2019 at 1:00am
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.031 seconds.