Page 1 of 1

How do I bind a LongList to a SQL Statement

Posted: Wed Sep 15, 2021 10:06 am
by joro
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

Re: How do I bind a LongList to a SQL Statement

Posted: Thu Sep 16, 2021 1:34 pm
by Lech Kulikowski
Hello,

Please check the sample report in the attachment.

Thank you.

Re: How do I bind a LongList to a SQL Statement

Posted: Mon Sep 20, 2021 5:35 am
by joro
Hello,
sorry but that report won't open. (see attachment)

I am using Stimulsoft Desinger 2020.4.1.

best regards

Re: How do I bind a LongList to a SQL Statement

Posted: Mon Sep 20, 2021 9:16 pm
by Lech Kulikowski
Hello,

We couldn't reproduce the issue. Please clarify how do you open the report?

Thank you.