Hi,
It is my where clause in Quick Report(SQL statement type)
spr.MANAGER = '&MANAGER'
I need result when parameter(&MANAGER) is empty
getting no data found message
When I use where clause like
spr.MANAGER is null
I’m getting result as expected
Any ideas to get result with where parameter is empty?
Thanks,
Narsi.
+18Can you change the WHERE clause to be WHERE spr.MANAGER = '&MANAGER' OR spr.MANAGER is NULL?
Hi
It works where '&MANAGER' is empty but doesn’t work where '&MANAGER' is not empty
getting result as empty records + MANAGER2 records when '&MANAGER' is MANAGER2
Thanks,
Narsi.
+21Hi
You can write a query for a quick report like the one below and you’ll be able to leave fields blank or enter something to filter the data.
1SELECT part_no, 2 description, 3 part_status,4 part_product_code,5 part_product_family,6 prime_commodity,7 second_commodity8FROM IFSAPP.INVENTORY_PART ip9WHERE UPPER(contract) LIKE NVL(UPPER('&SITE'),'OM1SH')10 AND part_status IN ('A', 'D')11 AND type_code_db IN ('1','2')12 AND part_product_code LIKE NVL(UPPER('&PRODUCT_CODE'),'%')13 AND part_product_family LIKE NVL(UPPER('&PRODUCT_FAMILY'),'%')14 AND prime_commodity LIKE NVL(UPPER('&PRIME_COMMODITY'),'%')15 AND second_commodity LIKE NVL(UPPER('&SECOND_COMMODITY'),'%')16ORDER BY part_no17
William
+10where spr.MANAGER like nvl('&MANAGER','%')
This will definitely work…!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
