Solved

Transpose rows to cols using Crystal Report..

Posted on 2010-08-27
6
1,757 Views
Last Modified: 2012-05-10
Hi All,
I have table data in the following format:
Tno      Name                              Value
Beg      MVD                              1
Beg      Results EU/µg                              2
Beg      Test Dilution                              3
Beg      Mean Onset Time                              4
Beg      CV%                              5
Beg      % Spike Recovery                              6
Mid      MVD                              1
Mid      Results EU/µg                              2
Mid      Test Dilution                              3
Mid      Mean Onset Time                              4
Mid      CV%                              5
Mid      % Spike Recovery                              6
End      MVD                              1
End      Results EU/µg                              2
End      Test Dilution                              3
End      Mean Onset Time                              4
End      CV%                              5
End      % Spike Recovery                              6

I would like to be able to display it in the following fashion,
      MVD      Results EU/µg      Test Dilution      Mean Onset Time      CV%      % Spike Recovery
Beg      1      2      3      4      5      6
Mid      1      2      3      4      5      6
End      1      2      3      4      5      6

Any help will be greatly appreciated. Thanks,
-VS
0
Comment
Question by:vsdotnet
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 20 total points
ID: 33543900
This looks like a standard crosstab report. Use the wizard to create the report.
0
 

Author Comment

by:vsdotnet
ID: 33545272
peter57r, I am a newbee to cross tab, sorry not able to figure out how or what to setup @ the cross -tab row and cols. because i am ending up bizarre table where rows are up and down. Thanks,
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33547233
Agree.

Insert a cross tab
Row - TNO
Col - Name
Summary value - Value

mlmcc
0
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
LVL 2

Expert Comment

by:Venkatgvi
ID: 33548543
TO add up with mlmcc,
in the summary value, for summary type choose max or min
ensure that for each tno, name you have only one row of data
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33550078
Actually since there is only 1 value the default of SUM will also work.

mlmcc
0
 

Author Closing Comment

by:vsdotnet
ID: 33551260
The solution did give me an idea, after working thru the i figured out the solution. Thanks for all the responding.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Not Exists 3 74
Insert timestamp data field of max summary 8 45
Crystal - variable evaluate after with criteria 4 58
Crystal Reports 13 5 71
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question