Hi Gurus,
I have a requirement to have a value prompt in prompt page to display values directly from query subject along with static choice but the values displayed in the value prompt should be sorted, in Cognos 10.2.1 version and datasource is relational.
The problem here I am facing is, static value choice entered manually is coming as a first row, instead of the values coming from database? I tried like writing the case statement (case when (database column in (X, Y, Z)) then (1) else (2) end) and then added in the sorting property, but of no use.
Is there any option to display the static value also sorted according to precedence.
Eg:
Value Prompt database values:
A
B
C
Static choice value:
X
Actual display of value prompt:
X
A
B
C
Expected display output:
A
B
C
X
Thanks in advance, your help is much appreciated.
Thanks & Regards,
XYZ
I get the same results, so Cognos must be set up that way. I don't know if you could do something with a union query to get a consolidated output...