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!

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

Changing row order in a crosstab 1

Status
Not open for further replies.
dday01

dday01

Technical User
Feb 1, 2002
138
US
Hi All,

I have a crosstab report, and the row headings show up in alphabetical order. This is not the order I want them in. Is there any way to change the order other than putting a number in front of each column head? Any help is greatly appreciated.

Thanks,

D
 
Sort by date Sort by votes
Go into format crosstab and select the row field and then choose "Group Options" and then you can use "Specified Order" to order your rows.

-LB
 
Upvote 0 Downvote
LB,

Thanks for the tip, thats exactly what I was looking for.

D
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
614
hilfy
hilfy
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
324
lbass
lbass
Lucy_G
  • Locked
  • Question
Highlight whole row in a crosstab based on non crosstab info
Replies
2
Views
197
Lucy_G
Lucy_G
cursedkorok
  • Locked
  • Question
Transpose Columns into Rows?
Replies
1
Views
344
hilfy
hilfy
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
440
LauraW
LauraW

Part and Inventory Search

Sponsor

Back
Top