Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TRANSPOSE 1

Status
Not open for further replies.

GG007

Programmer
Jan 18, 2001
3
ZA
I NEED TO TRANSPOSE MY INFO TABLES ON MY REPORT?
 
Like in EXCELL you have the option to copy info per row and if you paste it your info it is colum wise not row wise annymore like this.

info appears like this row sequense

1 jan
2 piet
3 gert
4 hennie
5 koos
6 graig

after transpose proses info should appear like this colum sequense

a b c d e f
jan piet gert hennie koos graig

if not clear enougt please suply me wit tel no and I will phone please.
 
Crystal doesn't have the exact feature but you could use a cross tab to come pretty close.

Place the numeric as the column field.
Don't put in a row field.
Place the text as the summarized field and change the summary operation to Maximum.

Cross-tabs can be per group or per report depending on which section you put them in. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top