Hello techies-
Currently I have a web form that allows users to enter 1 value in the text box along with a button that triggers a report from our DataWarehouse based on the value entered in the text box.
Issue - I would like to allow the user to add multiple values in the text box and then obviously have the report results show all values.
The delimiter is a comma with no spaces.
I tried a split function but the report is not recognizing that the multiple values are seperated by a comma therefore returning a blank report..
Oh by the way my query and parameter in Reporting Services is using an "equals" instead of an "In" --> I was thinking that maybe that is the issue but I'm not too sure....
Any brilliant thoughts..
Currently I have a web form that allows users to enter 1 value in the text box along with a button that triggers a report from our DataWarehouse based on the value entered in the text box.
Issue - I would like to allow the user to add multiple values in the text box and then obviously have the report results show all values.
The delimiter is a comma with no spaces.
I tried a split function but the report is not recognizing that the multiple values are seperated by a comma therefore returning a blank report..
Oh by the way my query and parameter in Reporting Services is using an "equals" instead of an "In" --> I was thinking that maybe that is the issue but I'm not too sure....
Any brilliant thoughts..
