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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ordering in columns & rows of a cross-tab

Status
Not open for further replies.
winney

winney

Programmer
Jan 24, 2003
14
CY
I have a cross-tab and I want to have an ordering at the row and at the column, based on 2 fields of my table. Let say that the row is based on the field ITEM_KEY of my table and the column on field ITEMFLT, at the table there are also 2 more fields LORDER(which specifies the ordering for the filed ITEM_KEY), FORDER(which specifies the ordering for the filed ITEMFLT).When I created my table I used ORDER BY LORDER,FORDER. I also add these ordering in the Database->Show SQL Query but the results that the report gives dont respect that ordering.Is there an option of the cross-tab that specifies the ordering of the row& column of the cross-tab???
Thanks
 
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Cross Tab Sorting Columns
Replies
1
Views
157
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
156
SoftwareRT
SoftwareRT
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
220
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
270
hilfy
hilfy
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
134
RoknRole
RoknRole

Part and Inventory Search

Sponsor

Back
Top