Skip to main content

Does anyone know how to make a parameter mandatory? By default they are all optional.

Also, is there a way to set a default value for a parameter?

Lastly, is there IFS documentation or a manual on details like this? I’ve seen IFS pages that have general  info, but nothing on technical details like the above or what else is doable/possible. As we start to develop our company’s custom reports I’m getting ideas and would like to know the capabilities and what’s possible with QuickReports.

Does anyone know how to make a parameter mandatory? By default they are all optional.

Also, is there a way to set a default value for a parameter?

Lastly, is there IFS documentation or a manual on details like this? I’ve seen IFS pages that have general  info, but nothing on technical details like the above or what else is doable/possible. As we start to develop our company’s custom reports I’m getting ideas and would like to know the capabilities and what’s possible with QuickReports.


It is interesting.

Is it possible to use this in lobbies?

For example:

 


@durette nice approach! 

I used your regex and placed it in a query like this. 
Thanks again

SELECT order_no
FROM IFSAPP.SHOP_ORD

where order_no IN
(SELECT REGEXP_SUBSTR(d__.str, ',^;]+', 1, LEVEL) AS val_
FROM (SELECT '&m-C--L]Param1' AS str FROM DUAL) d__
CONNECT BY LEVEL <= REGEXP_COUNT(d__.str, ';') + 1)

 


Reply