COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: Laynlowz on 22 Jan 2021 10:14:32 AM

Title: Sorting
Post by: Laynlowz on 22 Jan 2021 10:14:32 AM
Hello

is there a way to sort the data that is emailed? I looked through the different menu options and even tried the ORDER BY function but nothing seemed to work.

Title: Re: Sorting
Post by: BigChris on 25 Jan 2021 08:13:50 AM
Do you mean the data within the report?
Title: Re: Sorting
Post by: Eric.Pleiss on 25 Jan 2021 12:06:54 PM
Are you trying to identify emailed schedules and content?  Or adjust the email output?
Title: Re: Sorting
Post by: Laynlowz on 26 Jan 2021 09:05:20 AM
just the emailed output I want sorted. I found the sorting option, but it seems to only sort the current data in the database. The Order number field is continuously changing so I didn't know if that option would work or not.
Can you use a function to help it sort?