Hello IFS Community,
Could I get the SQL or any idea to build the logic to create the SQL behind the report on the Screenshot?
We are using IFS 9
Hello IFS Community,
Could I get the SQL or any idea to build the logic to create the SQL behind the report on the Screenshot?
We are using IFS 9
Hi,
You can query the report definition window to get the report view/ID. For this report it’s SHOP_ORD_WIP_REP. You can check the view definition from the view SHOP_ORD_WIP_REP.
However, for a report view, if you want to check the report method, you have to remove the _REP of the report view and use RPI instead. For this report, it’s SHOP_ORD_WIP_RPI.
Hope this answers your question.
Thanks,
Kasun
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.