Solved

Schedule a quick report with parameter

+5

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?

Best answer by Abdul

Hi @AMACBARADEL,

I successfully replicated this.

Please check with SQL statement below.

SELECT *
FROM INVENTORY_PART
WHERE PART_NO = ‘&PartNo’

Regards

Abdul Rehman

+20

Hi @AMACBARADEL,

I successfully replicated this.

Please check with SQL statement below.

SELECT *
FROM INVENTORY_PART
WHERE PART_NO = ‘&PartNo’

Regards

Abdul Rehman

https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/

+23

I think it should be

SELECT  *
FROM INVENTORY_PART
WHERE PART_NO = '&PartNo'

Kind regards

+5

Thank you,

Yes it works better now.

Sign up