end-user sorting?

[woodrg]

Is there a way to allow the end-user to choose the sort column? I'm sure it's very common to create a list report that might be used for several purposes, and as in my case with employees, being able to sort by ID or Name or Supervisor at the end-users descretion would certainly make for a more useable report. I've tried doing so with conditional formating, but oddly the sort function is not present in the properties box while in conditional formatting "mode".

I've searched and i did find where it might be possible to sort according to a prompt, but there are no responses to the thread and no indication as to how they accomplished sorting according to prompt in the first place.


thread401-1084992

Sorting Aggregated columns
goitz (TechnicalUser) 29 Jun 05 18:59
I want to sort based on a users prompt. I am able to do it without a problem for columns that are not aggregated...

Any guidance would be greatly appreciated. I'm using Cognos Report Studio.

Thanks in advance for any assistance you might be able to offer!


Becky,
Ft. Rucker

 

[GJParker]

To do this using a prompt and a calculated column is quite simple

create a calculated column in the report something like

If (?Column To Sort? = 'ID' ) Then ([ID]) Else ([Name])

Use this calculated column to sort and then when you run the report if the user enters ID the calculated column will contain ID's and the report will e sorted by ID's.

HTH



Gary Parker
MIS Data Analyst
Manchester, England

 

[Hsiao]

Hi,

I read quite a few solutions using this method. However, after we upgraded to Impromptu 7.1 (from 7.0 MR1). I have been having trouble with any comparison using prompt value. I got the following error:

[!]Error retrieving data from the database.

DMS-E-TYPENOTSUPPORTED, The data type 'unknown type' is not supported by this gateway.[/!]

Have you experienced this error? How can I get around it?

Thank you for your help on this!

Regards,
Hsiao