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.