Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Adding non summary column to a cross tab report Post Reply Post New Topic
Author Message
msram78
Newbie
Newbie


Joined: 22 Jan 2008
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote msram78 Replybullet Topic: Adding non summary column to a cross tab report
    Posted: 22 Jan 2008 at 10:16am
Hi,
 
I am new to this forum and this is my first post.
 
I am in an urgent need of a solution for a report that I am working on.
 
I have created a cross tab report, with rows as categories and columns as containing different types/values of expenses, for different months in an year.
 
It would look something like that
 
                                           jan/2007                        feb/2007
                              travel    purchses   misc    travel    purchses   misc
Category1                35        175            25       50           225        35
 
I have done this using cross tab expert, by adding category1 as rows, the date as columns and sum of travels, purchaes and misc to the summarized fields.
 
Now I want to add the sum of all expeneses for the previous year as a column to the report for every category.  if i add the previous year expenses to the summarized fields, it is displayed for every month, but I want it as a separate columnn in the report.
 
Can anyone help me with some solution for this, it would of great help.
 
Thanks & regards
 
Ram
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.