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

Report Studio Sorting

Status
Not open for further replies.
UcfMike

UcfMike

IS-IT--Management
Joined
Mar 29, 2007
Messages
184
Location
US
I have a column that for testing purposes contains two values.

B13
B1000

If I sort Ascending on this column the result is:

B1000
B13

Why isn't report studio sorting this as:

B13
B1000

 
Sort by date Sort by votes
Because its a string, not a number, and '0' comes before '3' in the collating sequence. If you want to sort numerically you'll need to convert the numeric substring to a number and sort on the result...something like to_number(substr([yourcolumn],2))
 
Upvote 0 Downvote
Thank You
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Magnus_03
  • Locked
  • Question Question
Cognos 10.2.2 Workspace Advanced Errors (Failed...request, the report server..., and annotation...)
Replies
0
Views
600
Magnus_03
Magnus_03
Emperatriz Stredel
  • Locked
  • Question Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
502
Emperatriz Stredel
Emperatriz Stredel
donape
  • Locked
  • Question Question
TM1 Cafe - Copy Report, but change CUBE data source.
Replies
0
Views
507
donape
donape
LearnToCognos
  • Locked
  • Question Question
Report Studio report and Framework Mgr test "out of sync"
Replies
0
Views
245
LearnToCognos
LearnToCognos
sandippk
  • Locked
  • Question Question
FM create detail filter with parameter which will be provided in Report Studio
Replies
0
Views
224
sandippk
sandippk

Part and Inventory Search

Sponsor

Back
Top