Solved

Transpose rows to cols using Crystal Report..

Posted on 2010-08-27
6
1,722 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video discusses moving either the default database or any database to a new volume.

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now