Solved

Quick Report Parameter Questions

  • 25 November 2019
  • 27 replies
  • 10828 views

Userlevel 4
Badge +10
  • Sidekick (Customer)
  • 119 replies

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.

icon

Best answer by Banu Liyanapathirana 26 November 2019, 01:35

View original

27 replies

Userlevel 7
Badge +22

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:

 

Userlevel 5
Badge +11

@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 '&[-C--L]Param1' AS str FROM DUAL) d__
CONNECT BY LEVEL <= REGEXP_COUNT(d__.str, ';') + 1)

 

Reply