| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2013-06-18 : 01:49:20
|
| hi,how is the defulat could be "select all" ,when i opend the report(the data set is on SP, that get parameter)thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 02:12:56
|
| http://blogs.msdn.com/b/bimusings/archive/2007/05/07/how-do-you-set-select-all-as-the-default-for-multi-value-parameters-in-reporting-services.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-06-18 : 03:17:45
|
| i must to choose key in the value field in the parameter? and in the query ,in the where...change to keyi mean : WHERE storekey IN (SELECT * FROM (@param_StoreKey, ',')) instead (i wrote before)WHERE store IN (SELECT * FROM (@param_Store, ',')) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 03:37:40
|
| was that a question or a statement?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-06-18 : 04:09:52
|
| sorry,it is question, what is your opinion? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 04:16:59
|
| it depends on your requirement. In typical cases, key is used for filtering and decsriptions are just for displaying to users inside dropdown.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-06-18 : 05:47:35
|
| but, if i choose description in "value field" the select all is nto work automatically, unless i choose key in "value field".why? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 06:07:11
|
| hmm..if you're using description in value field, you should be setting same field in default value too. Both the places field has to be same either description or key------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-06-18 : 06:47:36
|
| this is my problem with description it is not working. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 06:57:18
|
| what have you set as default value in that case?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
select all reporting