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

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

Post by Lech Kulikowski » Thu Sep 16, 2021 1:34 pm

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 » Mon Sep 20, 2021 5:35 am

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 1840 times
Lech Kulikowski
Posts: 4055
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski » Mon Sep 20, 2021 9:16 pm

Hello,

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

Thank you.
Post Reply