Print Page | Close Window

rotate or pivot

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=1947
Printed Date: 29 Apr 2024 at 3:48pm


Topic: rotate or pivot
Posted By: devvas
Subject: rotate or pivot
Date Posted: 28 Dec 2007 at 7:33am
I have the data from the database(through add command)  in such a way ,
 
time    measure1     measure2         measure 3
 
jan       1000               1500                 1700
 
feb       2000                2500                 2700
 
I want to convert into the following format in the report level,
 
                                   jan                     feb
 
measure1                  1000                  2000
 
measure2                  1500                  2500
 
measure3                  1700                  2700
 
 
( without using cross tab),
Is there any rotate option/ pivot option ( for non cross tab) available in crystal reports ,
 
 
thanks
 
 
 
 


Replies:
Posted By: Lugh
Date Posted: 28 Dec 2007 at 10:31am
The short answer is, no.  That's actually the point of cross-tab, is to accomplish that sort of manipulation.  Why are you so set against cross-tab?

There are some really tricky ways to accomplish this with SQL.  But, they are extremely tricky, and generally unfriendly, and your columns have to be hard-coded.

Posted By: tconway
Date Posted: 28 Dec 2007 at 10:38am
Is the reason you are not able to use a cross tab because it will only show summary rather than the details?
 
If so, maybe there is some way to still use the crosstab. 
 
Tim


Print Page | Close Window