use JOIN to use part of strings
I am using Join(Parameters!aCode.Value, ",") to concatenate selections from dropdownlist and display in a label control.
I would like to only display part of the selection because some are quite long, so multiple selections can create a very big label.
I tried: Join(left(Parameters!aCode.Value,3), ",") but got error:
"Overload resolution failed because no accessible join can be called with these arguments"
A Few More Details Please?
Did you try trimming the entire function, instead of within the JOIN() statement?
Let me know if I can assist further ...
Bill
Variability is the Killer ...
What makes it difficult is the variability of the number of possible names, based upon the picklist selection criteria. I still prefer the idea of pre-formatted text from the data source - an added field, in your case, returned by the SPROC that generates the label as you wish it in the overall dataset. Then, when you use Join(), only the truncated labels show, with no further mechanics at the report level. (It might, indeed, be the only way to do this ...)
Let me know if you hit upon a report-based solution!
Bill
Alas, the Maintenance ...
Sorry that you can't simply generate the appropriate "short name" label, but it sounds like you have a plan. Hope it doesn't require too much maintenance ...
Let me know if I can help further ...
Bill