How do I bind a LongList to a SQL Statement
Posted: Wed Sep 15, 2021 10:06 am
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
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