List variable not appearing on rendered report

Stimulsoft Reports.WEB discussion
semaphore
Posts: 19
Joined: Fri Jul 24, 2020 12:53 pm

Re: List variable not appearing on rendered report

Post by semaphore »

I see the nuget has been released, but now the option "Allow using as SQL parameter" has been disabled, am I to follow the example you outlined above in order to facilitate my needs?
Lech Kulikowski
Posts: 7336
Joined: Tue Mar 20, 2018 5:34 am

Re: List variable not appearing on rendered report

Post by Lech Kulikowski »

Hello,

To use List variable in the query, you should use an additional variable. Please check the sample from the previous reply.

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

Re: List variable not appearing on rendered report

Post by HighAley »

Hello,

It's impossible to use the List variable as a parameter.
You could add it in the curly brackets like in this article.

Thank you.
semaphore
Posts: 19
Joined: Fri Jul 24, 2020 12:53 pm

Re: List variable not appearing on rendered report

Post by semaphore »

Lech Kulikowski wrote: Tue Sep 15, 2020 6:45 am Hello,

To use List variable in the query, you should use an additional variable. Please check the sample from the previous reply.

Thank you.
Your previous example does not even function properly, I followed exactly and get zero outcomes.
semaphore
Posts: 19
Joined: Fri Jul 24, 2020 12:53 pm

Re: List variable not appearing on rendered report

Post by semaphore »

HighAley wrote: Tue Sep 15, 2020 6:46 am Hello,

It's impossible to use the List variable as a parameter.
You could add it in the curly brackets like in this article.

Thank you.
If I'm understanding the article you linked I can link the variable selected from the list item to the parameter in sql ? I do not want to have to use C# code behind in order to achieve what I'm wanting, the entire objective is to feed variables selected directly from the report generator to the stored procedure, is this feasible?

Edit: Nm, I figured it out, thanks. This is much easier to perform that the original suggestion.
Lech Kulikowski
Posts: 7336
Joined: Tue Mar 20, 2018 5:34 am

Re: List variable not appearing on rendered report

Post by Lech Kulikowski »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
ListInQueryID.mrt
(6.76 KiB) Downloaded 302 times
Post Reply