Is it possible to use an existing quick report (sql query) in data source designer ?
The name in quick report is CUSTOMER_ORDER. It works fine in quick report.
select CSL.* from ifsapp.Customer_Order CS
INNER JOIN ifsapp.Customer_Order_line CSL ON CS.ORDER_NO = CSL.ORDER_NOWHERE CS.order_ID = 'ERS'
AND CSL.QTY_ASSIGNED > 0 AND CS.state = 'Partially Delivered'
I saw this link. I tried to use ifsinfo.Customer_Order in data source designer, but would not work.
+11Hello!
Have you created an IAL within the application containing the SQL within your Quick Report?
You should be able to reference the IAL within the view in the data source.
Hi
in Lobby Data Source you can’t use a quick report as source. But if it based on an IAL then you can use it directly.
Alternatively, the user can use a personalised lobby.
Hi, I am not familiar with an IAL. Do you have link? Please see the image attached. This is what I have so far. I joined to views and it works fine in Quick Report. How can I reference the IAL within the view in the data source?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
