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

Sorting in crosstab report

Status
Not open for further replies.
dm21

dm21

Programmer
Feb 6, 2003
74
CA
Hi

I have a crosstab report where my columns are month and year i.e. Dec 02 | Jan 03 | Feb 03 etc.

But when I apply the date format to column, it is not applying the date format.

How can I do this?
 
Sort by date Sort by votes
The function Str_To_Date is not available in Impromptu hence sorting is not possible.Impromptu treat this as Varchar and sort accordingly


Regards
 
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
250
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
216
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
231
wwconslt
wwconslt
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
215
Goutham3835
Goutham3835
sreevp2020
  • Locked
  • Question
dynamic deafult date in date prompt calandar
Replies
0
Views
232
sreevp2020
sreevp2020

Part and Inventory Search

Sponsor

Back
Top