Creating reports and dashboards | Stimulsoft community forum

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.

Hello,

Please check the sample report in the attachment.

Thank you.

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?

Hello,

Please check the modified report.

Thank you.