Forum Discussion
Report Builder Textfield multiple values
Thank you very much and have a great weekend
DerMainzer wrote:
1. Whatever I choose in the drop down the Report says #Error
This is because when you turn on the multiple values option the parameter returns an array instead of a single scalar value.
So instead of just referencing the parameter directly
eg.
=Parameters!ReportParameter1.Value
You need to right click on the text box which is showing #Error then edit the expression to wrap the parameter reference in the Join() function.
eg.
=Join(Parameters!ReportParameter1.Value,",")
DerMainzer wrote:
2. If Í don't choose anything the Report Builder forces me to choose
If you want to allow people to run the report without selecting a value you need to configure a default value and you will also need to add this default value to your allowed values.
Hi,
thanks for your help - the Join did work.
Unfortunately the default value I typed in doesn't show up, I think it's because it's not a value from the list the parameter is pointing at, right?. I also don't understand why there is a check box for "accept empty value" if it doesn't work....
Thanks again,
Tim
DerMainzer wrote:
Unfortunately the default value I typed in doesn't show up, I think it's because it's not a value from the list the parameter is pointing at, right?
Yes, unfortunately once you specify an allowed list then only values from that list are accepted. If you don't have an allowed list the user can type any text they like, but then you loose the multiple items option.
DerMainzer wrote:
I also don't understand why there is a check box for "accept empty value" if it doesn't work....
It's conflicting with the Allowed Values property. If you also had an empty string as an allowed value it would work.
Thank you very much and have a great weekend