In your expression method of the textbox, instead of:
=Parameters!someParameter.Value
Do this instead:
=Join(Parameters! someParameter .Value, ", ")
This will join all the values, separated by a comma.…
Category: SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS) – Multiple IIf statements in an expression behind a textbox
Instead of using a code behind for simple decisions, you can use unlimited multiple IIf statements in an expression behind a textbox.
For example, let’s say you have a parameter called HoldType that can have 3 different values, (1, 2, …
SQL Server Reporting Services (SSRS) – How to Receive an Image into a Report Parameter to a SSRS Report
In this example, I will demonstrate how to convert an image in an Windows Form Application to a Base64 String that can be used to populate a report parameter that will be received into a SQL Server Reporting Services report …