Solved

Transpose rows to cols using Crystal Report..

Posted on 2010-08-27
6
1,737 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

910 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

23 Experts available now in Live!

Get 1:1 Help Now