Variable of type list returns improperly delimited value

Stimulsoft Reports.WEB discussion
Post Reply
ryanr.eventpalette
Posts: 11
Joined: Tue Apr 21, 2015 11:12 am

Variable of type list returns improperly delimited value

Post by ryanr.eventpalette »

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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable of type list returns improperly delimited value

Post by HighAley »

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.
ryanr.eventpalette
Posts: 11
Joined: Tue Apr 21, 2015 11:12 am

Re: Variable of type list returns improperly delimited value

Post by ryanr.eventpalette »

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.
Attachments
VariableListSample.zip
(284.21 KiB) Downloaded 408 times
ryanr.eventpalette
Posts: 11
Joined: Tue Apr 21, 2015 11:12 am

Re: Variable of type list returns improperly delimited value

Post by ryanr.eventpalette »

This is what MyVariable.ToQueryString() returns on the sample report.
Attachments
variablelistvalue.png
variablelistvalue.png (15.57 KiB) Viewed 3055 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable of type list returns improperly delimited value

Post by HighAley »

Hello.

Please, specify which our viewer do you use?

Thank you.
ryanr.eventpalette
Posts: 11
Joined: Tue Apr 21, 2015 11:12 am

Re: Variable of type list returns improperly delimited value

Post by ryanr.eventpalette »

StiWebViewer
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable of type list returns improperly delimited value

Post by HighAley »

Hello.

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
Untitled.png (34.66 KiB) Viewed 3033 times
ryanr.eventpalette
Posts: 11
Joined: Tue Apr 21, 2015 11:12 am

Re: Variable of type list returns improperly delimited value

Post by ryanr.eventpalette »

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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable of type list returns improperly delimited value

Post by HighAley »

Hello.

We have reproduced your issue now.
We need some time to solve it.
We will get in touch with any news.

Thank you.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable of type list returns improperly delimited value

Post by HighAley »

Hello.

We have fixed the issue.
The patch will be available in our next prerelease build tomorrow.

Thank you.
Post Reply