Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slihp
Yak Posting Veteran
61 Posts |
 Posted - 2009-09-08 : 11:25:22
|
| I have a string multi-value parameter in one of my reports, this provides the user with a list of clients name they can select from which is then passed to a Table value function inside the sp.in some instance the client name list can be as large as 800 client names, now when this is the case and the user selects "all" and trys to run the report the paramater box blanks out and nothing else happens.i get the felling this is because the string parameter maximum limit has been reached within report manager. i am using varchar(max) within my sp but i do belive it is ssrs side that is failing.any ideas. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-08 : 11:55:58
|
| I have had same issue but not nearly as drastic. What I did was created the list with a stored procedure that forced a single blank record and used a user select of BLANK to indicate all. It didn't stop them from clicking ALL though.To return a single blank row with all departments:Select ' ' AS DeptUnionSELECT DISTINCT ED_Dept.Rn_Descriptor AS DeptFROM ED_DeptORDER BY Deptand then in main dataset I included:WHERE (ED_Service_Request.Dept IN (@Dept) OR @Dept = ' ')John"The smoke monster is just the Others doing barbecue" |
 |
|
|
|
|
|
Limitations of string parameters