Variable List of type String

Stimulsoft Reports.JAVA discussion
Post Reply
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Variable List of type String

Post by Manuel Costa »

Hello gentlemen, I have the following scenario I have a variable of type List, in which both the "Values" and the "Key" with a column of type string, in the data source the query was like this as in the print:

AT.TP_ATENDIMENTO IN ('{V_TP_ATENDIME_AUX}')

I understand that with the quotes it doesn't work correctly, but when I remove the single quotes and run the report, there is an invalid identifier error in the String values.

So I would like to know in the List variable the "KEY" field only accepts values ​​of the integer type so that it works normally?

Or does the "KEY" field accept String values?

Attached the report.
Attachments
Capturar1.JPG
Capturar1.JPG (107.64 KiB) Viewed 1561 times
Capturar.JPG
Capturar.JPG (83.22 KiB) Viewed 1561 times
ATENDIMENTO VS MOVDOC (1).mrt
(28.41 KiB) Downloaded 182 times
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Variable List of type String

Post by Lech Kulikowski »

Hello,

Please check the sample report in the attachment.

Thank you.
Attachments
ListInQueryStringMySQL.mrt
(7.26 KiB) Downloaded 216 times
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Re: Variable List of type String

Post by Manuel Costa »

Hi Lech, sorry for the delay in returning, so I was recently validating the sample report you sent me and I came across this error:
" class com.stimulsoft.base.exception.StiException java.sql.SQLException: IN or OUT parameter missing from index:: 1"
Can you guide me on this?
Attachments
lista string.mrt
(7.93 KiB) Downloaded 186 times
LIST.JPG
LIST.JPG (67.03 KiB) Viewed 1375 times
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Variable List of type String

Post by Lech Kulikowski »

Hello,

Please check the modified report.

Thank you.
Attachments
lista string.mrt
(8.27 KiB) Downloaded 221 times
Post Reply