Link to home
Start Free TrialLog in
Avatar of Laura2112
Laura2112Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of raulggonzalez
raulggonzalez

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Laura2112

ASKER

thanks
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.
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