I'm working on a .rdl report in VS2008/SQL server 2008 R2.
Please see the attached file. When I preview the report, the Year filter contains all year options (Fig 1). If "Select All" is selected, all drop down items (2009,2010,2010,2012) are displayed in the box (Fig 2). I would like to display the word 'All' instead of all year values when 'Select All' is selected.
Is there a way to do it? How can I achieve it?
Thanks for any help.