I'm having an issue with a prompt I'm creating for a report user (In Framework Manager). I need to give the user a list of Financial Months to pick from a drop down list.
In the Prompt Info properties I'm selecting a different display value then the filter item. The filter item will be the fin year and fin month ex. 20061,20062,...200612. However the display item would be 2006 - January, etc.
My prompt is based on a Query Subject when I order by fin year and fin month. I've tried the is unsortable set to true and false. That made no different. Is there a way to control the sorting of the displayed item. It seems to just want to ignore me. If you include the following filter...
([Presentation View].[Core].[Concat Yr-Mnth] in (#promptmany('Financial Month','integer','','','[Presentation View].[(en) Year-Month Picklist (Hidden)].[(en) Concat Yr-Mnth]')#)
...in the filter of a report, it just sorts on the display item in ascending order every time. Has anyone had success controlling the sorted of the select value list? I'd rather it sort on the filter item rather then the display item. This seems like typical picklist stuff. Thanks.
Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada
In the Prompt Info properties I'm selecting a different display value then the filter item. The filter item will be the fin year and fin month ex. 20061,20062,...200612. However the display item would be 2006 - January, etc.
My prompt is based on a Query Subject when I order by fin year and fin month. I've tried the is unsortable set to true and false. That made no different. Is there a way to control the sorting of the displayed item. It seems to just want to ignore me. If you include the following filter...
([Presentation View].[Core].[Concat Yr-Mnth] in (#promptmany('Financial Month','integer','','','[Presentation View].[(en) Year-Month Picklist (Hidden)].[(en) Concat Yr-Mnth]')#)
...in the filter of a report, it just sorts on the display item in ascending order every time. Has anyone had success controlling the sorted of the select value list? I'd rather it sort on the filter item rather then the display item. This seems like typical picklist stuff. Thanks.
Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada