Page 2 of 2

Re: List variable not appearing on rendered report

Posted: Mon Sep 14, 2020 6:44 am
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?

Re: List variable not appearing on rendered report

Posted: Tue Sep 15, 2020 6:45 am
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.

Re: List variable not appearing on rendered report

Posted: Tue Sep 15, 2020 6:46 am
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.

Re: List variable not appearing on rendered report

Posted: Wed Sep 16, 2020 2:41 pm
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.

Re: List variable not appearing on rendered report

Posted: Wed Sep 16, 2020 2:42 pm
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.

Re: List variable not appearing on rendered report

Posted: Sat Sep 19, 2020 8:49 am
by Lech Kulikowski
Hello,

Please check the sample report in the attachment.

Thank you.