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

Sorting Cognos concatenated prompt

Status
Not open for further replies.
pennymail

pennymail

Programmer
Apr 9, 2012
2
0
0
US
I have an employee prompt that concatenates the office and employee. When the office shows just as Pgh-Emp name I want the know if it is possible to sort in Alpha order the Emp name.
Ex: Pgh - Jones , Pgh - Smith vs having Smith before Jones. Thanks all!
 
Sort by date Sort by votes
You can sort the prompt query any way you like (using - for instance - another dataitem) but the sortorder is applied to the full range of data:

Ascending sort order should put Pgh-Jones before Pgh-Smith

Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
130
tushargaurav
tushargaurav
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
102
wwconslt
wwconslt
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
99
Goutham3835
Goutham3835
Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
118
Emperatriz Stredel
Emperatriz Stredel
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
115
NileshDhande
NileshDhande

Part and Inventory Search

Sponsor

Back
Top