Schedule a quick report with parameter

Hello,

I’m using IFS CLoud 24R1.

I’m trying to schedule a SQL Quick report.

The result is conform without parameter:

SQL is :

SELECT *
FROM INVENTORY_PART
WHERE PART_NO = 'G1201500'

The result is a correct excel file.

if I define a paramater:

SQL is :

SELECT *
FROM INVENTORY_PART
WHERE PART_NO = &PartNo

And I put the same value on the Schedule Report:

the result is a empty excel file.

Do you have an explanation?

Page 1 / 1

Hi @AMACBARADEL,

I successfully replicated this.

Please check with SQL statement below.

SELECT *
FROM INVENTORY_PART
WHERE PART_NO = ‘&PartNo’

Regards

Abdul Rehman

I think it should be

SELECT  *
FROM INVENTORY_PART
WHERE PART_NO = '&PartNo'

Thank you,

Yes it works better now.

Sign up