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 rows/cols of a result set?
Yep, got that one sorted too... Column/Row heights and widths are adjusted by changing the widths of the headings.- pardey
- Post #7
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Transpose rows/cols of a result set?
Sorry, I just realised that I can edit the row label, so that one is sorted. Is it possible to adjust the row and column widths?- pardey
- Post #6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Transpose rows/cols of a result set?
The solution proposed by synapsevampire produces the following table. It is close, but I need the row labels to be in place otherwise the numbers are meaningless. +---------+--------+---------+---------+-----+--------+ | Band | 0 - 30 | 30 - 60 | 60 - 90 | 90+ | Totals |...- pardey
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Transpose rows/cols of a result set?
The stored procedure returns just the summaries. We're using Sybase 11.9 and Crystal Reports 8.0.1.0- pardey
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Transpose rows/cols of a result set?
Hi, I have a result set returned from a stored procedure that has always has the same no. of rows and colummns. I use this stored procedure for two reports, but one of them needs the results transposed. For example +---------+-------+-----+-----+ | Band | Count | Avg | Min |...- pardey
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 4 Other topics
