Print Page | Close Window

To repeat the 1st column values for each row

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=17456
Printed Date: 06 May 2024 at 2:48am


Topic: To repeat the 1st column values for each row
Posted By: nikhil_thrissur
Subject: To repeat the 1st column values for each row
Date 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
 


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: nikhil_thrissur
Date 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+", mailto:+@Region - +@Region and then use this as the firstcolumn and suppress the column....
 
thats it..
 
thanks all
 
 


Print Page | Close Window