?
Solved

Transpose rows to cols using Crystal Report..

Posted on 2010-08-27
6
Medium Priority
?
1,794 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 60 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 101

Expert Comment

by:mlmcc
ID: 33547233
Agree.

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

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
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 101

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

801 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