Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: To repeat the 1st column values for each row Post Reply Post New Topic
Author Message
nikhil_thrissur
Newbie
Newbie


Joined: 10 Jan 2011
Online Status: Offline
Posts: 13
Quote nikhil_thrissur Replybullet Topic: To repeat the 1st column values for each row
    Posted: 29 Aug 2012 at 11:53pm
Hi ,
 
I am using crosstab to develop a report.
I want to display the data as below
 
Group Region Month1 Month 2 Month3 Month4
A US 12 11 14 10
A Canada 0 4 3 1
B US 25 21 20 5
B Canada 1 0 4 87
B India 2 65 4 5
 
But What I actually got is as below.
The values in the first column are not repeating for the second column values.
Since second column is a subset of 1st,it appears only at the row of last region(column2) for the group(column1)
 
Group Region Month1 Month 2 Month3 Month4
US 12 11 14 10
A Canada 0 4 3 1
US 25 21 20 5
Canada 1 0 4 87
B India 2 65 4 5
 
 
I really appreciate any help on this.
This is eating my head
 
thanks
Nikhil
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 30 Aug 2012 at 4:02am
Right-click on the Cross-tab and go to the Cross-Tab Expert.  Go to the "Customize Style" tab and turn on "Repeat Row Labels".
 
-Dell
IP IP Logged
nikhil_thrissur
Newbie
Newbie


Joined: 10 Jan 2011
Online Status: Offline
Posts: 13
Quote nikhil_thrissur Replybullet Posted: 30 Aug 2012 at 10:47pm
Thanks for the support hilfy..
However,Turning on repeat row label doesn't work here.
 
I was able to find a solution for this from other websites.
Create a new formula by concatenating "@Group+",+@Region and then use this as the firstcolumn and suppress the column....
 
thats it..
 
thanks all
 
 
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.