Variable of type list returns improperly delimited value
-
- Posts: 11
- Joined: Tue Apr 21, 2015 11:12 am
Variable of type list returns improperly delimited value
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.
Re: Variable of type list returns improperly delimited value
Hello.
Sorry, but we couldn't reproduce the issue.
Please, send us a sample project with all necessary data that will help us to reproduce the issue.
Thank you.
Sorry, but we couldn't reproduce the issue.
Please, send us a sample project with all necessary data that will help us to reproduce the issue.
Thank you.
-
- Posts: 11
- Joined: Tue Apr 21, 2015 11:12 am
Re: Variable of type list returns improperly delimited value
I've attached a sample report to demonstrate the issue.
Upon clicking submit (without making any changes to the selected items),
the value returned by MyVariable.ToQueryString() is not delimited properly.
We have purchased Stimulsoft Reports.Web 2015.1 and this issue still persists.
Please advise. Thanks.
Upon clicking submit (without making any changes to the selected items),
the value returned by MyVariable.ToQueryString() is not delimited properly.
We have purchased Stimulsoft Reports.Web 2015.1 and this issue still persists.
Please advise. Thanks.
- Attachments
-
- VariableListSample.zip
- (284.21 KiB) Downloaded 408 times
-
- Posts: 11
- Joined: Tue Apr 21, 2015 11:12 am
Re: Variable of type list returns improperly delimited value
This is what MyVariable.ToQueryString() returns on the sample report.
- Attachments
-
- variablelistvalue.png (15.57 KiB) Viewed 3056 times
Re: Variable of type list returns improperly delimited value
Hello.
Please, specify which our viewer do you use?
Thank you.
Please, specify which our viewer do you use?
Thank you.
-
- Posts: 11
- Joined: Tue Apr 21, 2015 11:12 am
Re: Variable of type list returns improperly delimited value
Hello.
Sorry, but we still couldn't reproduce the issue.
Could you send us a sample project which reproduce the issue.
Thank you.
Sorry, but we still couldn't reproduce the issue.
Could you send us a sample project which reproduce the issue.
Thank you.
- Attachments
-
- Untitled.png (34.66 KiB) Viewed 3034 times
-
- Posts: 11
- Joined: Tue Apr 21, 2015 11:12 am
Re: Variable of type list returns improperly delimited value
Steps to reproduce the issue:
1. Load the report using StiWebViewer.
2. Click submit (do not make any changes to the selected items).
Based on your screenshot, I think you only did step 1.
Because if you did, "Selected Countries" should not have repeated values.
You can use the sample report I've attached to reproduce the issue.
Please advise. Thanks.
1. Load the report using StiWebViewer.
2. Click submit (do not make any changes to the selected items).
Based on your screenshot, I think you only did step 1.
Because if you did, "Selected Countries" should not have repeated values.
You can use the sample report I've attached to reproduce the issue.
Please advise. Thanks.
Re: Variable of type list returns improperly delimited value
Hello.
We have reproduced your issue now.
We need some time to solve it.
We will get in touch with any news.
Thank you.
We have reproduced your issue now.
We need some time to solve it.
We will get in touch with any news.
Thank you.
Re: Variable of type list returns improperly delimited value
Hello.
We have fixed the issue.
The patch will be available in our next prerelease build tomorrow.
Thank you.
We have fixed the issue.
The patch will be available in our next prerelease build tomorrow.
Thank you.