Transpose rows to cols using Crystal Report..

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
vsdotnetAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
This looks like a standard crosstab report. Use the wizard to create the report.
0
 
vsdotnetAuthor Commented:
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
 
mlmccCommented:
Agree.

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

mlmcc
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
VenkatgviCommented:
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
 
mlmccCommented:
Actually since there is only 1 value the default of SUM will also work.

mlmcc
0
 
vsdotnetAuthor Commented:
The solution did give me an idea, after working thru the i figured out the solution. Thanks for all the responding.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.