Hello,
I would like to use a Variable from type 'LongList' in my report.
I define a variable of type long and list and add some items manually. (see screenshot1.jpg)
I add an SQL statement select * from xy where id in ( {variableName} ); (screenshot2.jpg)
The preview doesn't work because I get an error message: The multi-part identifier "Stimulsoft.Report.LongList" could not be bound.
Can you please provide a hint or a sample report?
I basically want do add items to the variable (LongList) at runtime and then render the report.
br
How do I bind a LongList to a SQL Statement
How do I bind a LongList to a SQL Statement
- Attachments
-
- screenshot1.jpg (35.33 KiB) Viewed 2442 times
-
- screenshot2.jpg (23.9 KiB) Viewed 2442 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: How do I bind a LongList to a SQL Statement
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 137 times
Re: How do I bind a LongList to a SQL Statement
Hello,
sorry but that report won't open. (see attachment)
I am using Stimulsoft Desinger 2020.4.1.
best regards
sorry but that report won't open. (see attachment)
I am using Stimulsoft Desinger 2020.4.1.
best regards
- Attachments
-
- listinquery.jpg (39.61 KiB) Viewed 2396 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: How do I bind a LongList to a SQL Statement
Hello,
We couldn't reproduce the issue. Please clarify how do you open the report?
Thank you.
We couldn't reproduce the issue. Please clarify how do you open the report?
Thank you.