Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a "month" field from a key, in my script, using the make date feature. When I created the list box to show the months (01, 02, 03, etc) I used an expression to show the months as Jan, Feb, Mar, etc. Now, the list box sorts correctly when I use the sort by expression, = Month expression. When users are accessing the document (via accesspoint) the sorting is all mixed up.
When I re-sort the qvw file it seems to fix it, but only temporarily.
Anyone else experience this problem, or know how I can solve this issue?
hi,
Instead of doint it in expression do it at script level and bring it as a field.
Deepak
hi,
Instead of doint it in expression do it at script level and bring it as a field.
Deepak
Hi Mike,
In the sort expression use Only function with a set analysis and ignore the selections users are making.
which helps you to remain the sort order same.
hope this helps
thank you
Meher
suggest you create a calendar master data....or at least a field of MMM YYYY, so when you need 2011 June to 2012 June, it will be sorted properly... just use date(date, 'MMMYYYY')