Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Cross Tab Question Post Reply Post New Topic
Author Message
Geeshan
Newbie
Newbie


Joined: 31 Aug 2009
Online Status: Offline
Posts: 1
Quote Geeshan Replybullet Topic: Cross Tab Question
    Posted: 31 Aug 2009 at 3:44am
Hi All,

I have a cross tab report  something like following.


 Case A

 Case B

 ...

 ..

 Case X

 Case Y

 

 

 CaseN

  A

 Sum(AA)

 sum(AB)

 

 

 

 

 

 

 

 B

 

 

 

 

 

 

 

 

 

 C

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Where as A,B and C are employees and Case A, Case B.. are projects. Sum(AA) is the total money earned by Employee A from Project A.

I can generate this report. But it lay down horizontally too long.

What I want is Something like this.


Page 1.

 

 Case A

 Case B

 A

 Sum(AA)

 

 B

 

 

 C

 

 

 

 

 

 

Page 2

 

 Case X

 Case Y

 A

 Case(AX)

 

 B

 

 

 C

 

 

 

 

 

 

I tried in many ways, but failed. PLease help me.

PS. Sorry for my English.


Edited by Geeshan - 31 Aug 2009 at 3:47am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Sep 2009 at 3:57pm
Unfortunately, there's nothing you can do to get the format you want - this is the way cross tabs work.  You can do some things to make it narrower - change font size and column widths, but how wide the final table is depends on how much data you have.
 
-Dell
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Sep 2009 at 4:00pm

I just had a thought, though....

You could possibly do this with subreports - use the same crosstab in each, but filter the case data in the subreport so that it's not to wide.  Whether this will work for you depends on what your case data looks like.
 
-Dell
IP IP Logged
KathyTap11
Newbie
Newbie
Avatar

Joined: 09 Nov 2009
Location: United States
Online Status: Offline
Posts: 1
Quote KathyTap11 Replybullet Posted: 09 Nov 2009 at 11:12am
Why don't you have the employees (A, B, & C) be the columns and the projects be the rows? That way it's short horizontally and you can add projects forever.
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.016 seconds.