Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Is there a limitation of chartacters for an SSRS parameter

I have a multiselect parameter for customer.  Is there a space limitation on how long the string can be in SSRS?  I have 3400 records, the average is a length of 36.
After selecting all  of the records, nothing is returned in the texbox to visibley see
what was selected. It also takes a very long time to process. Any suggestions?
0
Laura2112
Asked:
Laura2112
  • 2
1 Solution
 
raulggonzalezCommented:
Hi,

For SQL server the limit is 128 (sometimes 116)

http://msdn.microsoft.com/en-us/library/ms175874.aspx

not sure if applies to SSRS



Cheers
0
 
Laura2112Author Commented:
thanks
0
 
pssandhuCommented:
Are you trying to print all the selection from a parameter that the user selected and print them in a text box? In that case you do something like this:

Join(Parameters!Product.Label, ",")

Where Product is the name of the parameter.

Hope this helps.

P.
0
 
Laura2112Author Commented:
No, my string is very long if they select ALL and the text does not get populated does not populate the text box. The parameter itself works, it is just that they can't see that they selected anything, the text box remains bland, thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now