Crosstab Totals and Formula
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=22758
Printed Date: 30 Apr 2024 at 10:44am
Topic: Crosstab Totals and Formula
Posted By: alfiet
Subject: Crosstab Totals and Formula
Date 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
|
Replies:
Posted By: lockwelle
Date Posted: 02 May 2019 at 10:30am
CrossTabs are not my forte, and while they create columns, I am not a fan of what they display. It seems pretty limiting. If you know the number of years back that you may be going, I think just creating a report that does what you want is 'simpler'. You could craft your SQL to 'pivot' your data so the Crystal displays it nicely.
Sorry, not much help.
|
|