List variable not appearing on rendered report
Re: List variable not appearing on rendered report
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?
-
- Posts: 7336
- Joined: Tue Mar 20, 2018 5:34 am
Re: List variable not appearing on rendered report
Hello,
To use List variable in the query, you should use an additional variable. Please check the sample from the previous reply.
Thank you.
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
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.
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
Your previous example does not even function properly, I followed exactly and get zero outcomes.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.
Re: List variable not appearing on rendered report
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?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.
Edit: Nm, I figured it out, thanks. This is much easier to perform that the original suggestion.
-
- Posts: 7336
- Joined: Tue Mar 20, 2018 5:34 am
Re: List variable not appearing on rendered report
Hello,
Please check the sample report in the attachment.
Thank you.
Please check the sample report in the attachment.
Thank you.
- Attachments
-
- ListInQueryID.mrt
- (6.76 KiB) Downloaded 302 times