Report Builder filter dropdown list issues

How can I create a report in Report Builder with a date-type parameter that displays a dropdown list of month names displayed in the correct chronological order (i.e. January, February, etc.)? More generally, how does one sort filter values in the dropdown list?

On a related note, how do I get Report Builder to display (in the report) which values were selected from the dropdown list? Currently I get:

Filter: Transactions with: All of (Month = (prompted))

when what I really need is the month name(s) selected from the dropdown list.

Thanks!

Paul.

Paul Rayner wrote:

On a related note, how do I get Report Builder to display (in the report) which values were selected from the dropdown list? Currently I get:

Filter: Transactions with: All of (Month = (prompted))

when what I really need is the month name(s) selected from the dropdown list.
Thanks!
Paul.

Names will appear in dropdown if ValueSelection property of attribute Transaction is set to "Dropdown".

|||

Thanks for the reply. Perhaps I was insufficiently clear. I know how to get a dropdown list. What I don't know how to do is how to sort the date values (when displayed as month names) in a dropdown list. Month names are being displayed as April, August, etc. instead of January, February, etc.

Paul.