I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections
Clearing/Unselecting Multi-Value selections made
Hot Topic
- Changing Connection string in multiple packages.
- how to use a Parameter instead like '>'or '<' in ssrs05 mdx design
- 'The selected report is not ready for viewing'?
- The connection manager 'OLEDB' is not properly installed on this computer
- How connect SQL server 2000 with c#.net .....?
- Parameters that depend on another
- URL rending vs embedded reports
- Looping over files not available in my ssis
- Right-Click Table -> Import data GONE??
- Random Failure of Lookup in Pre-Execute with 0x8007000E
SQL Server
- SQL Server 2005 uninstall problem
- Stored procedure issues...
- Which sql statement is more efficient
- Problem formatting currency to different decimal places
- SSIS Requests...
- Connection managers - OLE DB
- New Guy Question: Which came first ... the chicken or the checkpoint file?
- Impact of "Rows per batch" on OLE DB Destination?
- Unable to read local eventlog (the parameter is incorrect)
- Getting the TXs on MIRROR
Clearing/Unselecting Multi-Value selections made
Ryan Adams
Ron,
Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.
Richard Browne
Up to the top...
Come on now, where our options for this !!!
Microsoft can do better than this.
Nimble
Yes i understand and i have tried the workaround. It doesn't help with what i want.
What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this It wasn't just a select all, it was also an unselect all.