Variable of type list returns improperly delimited value
Posted: Thu Apr 23, 2015 5:05 pm
I am using Stimulsoft Reports.Web 2014.3 Trial.
I used a variable of type list to filter my report by one or multiple selected items.
To do this, I passed MyVariable.ToQueryString() as a parameter to my SQL stored procedure which I used as a data source.
Upon the initial submit of the report, all items in the list are selected as should be.
However when I checked the passed parameter (MyVariable.ToQueryString()) in the stored procedure, the value that was passed looked something like this:
ItemA,ItemB,ItemC,ItemD,ItemE,ItemFItemGItemHItemIItemJ
When I make any changes in the selected items in the list, the value that is passed looks correct:
ItemA,ItemB,ItemC,ItemD,ItemE,ItemF,ItemG,ItemH,ItemI,ItemJ
For some reason, if I don't make any changes to the initial selections (all are selected by default) in the list,
the value that is returned is not delimited properly.
I have to click the list, then uncheck and check an item to make it return a properly delimited value.
Am I doing something wrong?
Please help.
I used a variable of type list to filter my report by one or multiple selected items.
To do this, I passed MyVariable.ToQueryString() as a parameter to my SQL stored procedure which I used as a data source.
Upon the initial submit of the report, all items in the list are selected as should be.
However when I checked the passed parameter (MyVariable.ToQueryString()) in the stored procedure, the value that was passed looked something like this:
ItemA,ItemB,ItemC,ItemD,ItemE,ItemFItemGItemHItemIItemJ
When I make any changes in the selected items in the list, the value that is passed looks correct:
ItemA,ItemB,ItemC,ItemD,ItemE,ItemF,ItemG,ItemH,ItemI,ItemJ
For some reason, if I don't make any changes to the initial selections (all are selected by default) in the list,
the value that is returned is not delimited properly.
I have to click the list, then uncheck and check an item to make it return a properly delimited value.
Am I doing something wrong?
Please help.