How do I bind a LongList to a SQL Statement

Stimulsoft Reports.Net discussion
Post Reply
joro
Posts: 61
Joined: Wed Jan 27, 2010 7:35 am

How do I bind a LongList to a SQL Statement

Post 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
Attachments
screenshot1.jpg
screenshot1.jpg (35.33 KiB) Viewed 1896 times
screenshot2.jpg
screenshot2.jpg (23.9 KiB) Viewed 1896 times
Lech Kulikowski
Posts: 4059
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
ListInQueryID.mrt
(6.76 KiB) Downloaded 48 times
joro
Posts: 61
Joined: Wed Jan 27, 2010 7:35 am

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

Post by joro »

Hello,
sorry but that report won't open. (see attachment)

I am using Stimulsoft Desinger 2020.4.1.

best regards
Attachments
listinquery.jpg
listinquery.jpg (39.61 KiB) Viewed 1850 times
Lech Kulikowski
Posts: 4059
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply