Hi to all,
I create a RMB in the customer order line that open a quick report.
I need to pass 2 parameters the item code and the site code so the users is not obliged to copy and paste it.
Is possible to pass parameters to quick report and how?
Thanks
Calling a quick report from a rmb menu passing parameters
+3
Userlevel 4
+8
Hello
You can use quick report parameters like below; you should match the source and destinations columns.
Kind Regards
Ozgun Bal
Userlevel 7
+31
Hi
To add something to Ozgun Bal’s response above, you can find the documentation related to this here.
For IEE:
For Aurena:
Hope this helps!
+3
Thank you very much for your suggestions.
We made the menu according to the indication but is not working.
So in the customer order line we add the custom menu
The quick report SQL is below
Userlevel 4
+8
Dear
I am not familiar with using square brackets but when I tested the statement below in PL/SQL, it did not ask me the PART_NO as a parameter, and query result has no value.
SELECT * FROM CUSTOMER_ORDER_LINE WHERE PART_NO = '&[M----]PART_NO'
That may be the reason why your custom menu doesn’t work.
Kind Regards
Ozgun Bal
+3
Dear
I am not familiar with using square brackets but when I tested the statement below in PL/SQL, it did not ask me the PART_NO as a parameter, and query result has no value.
SELECT * FROM CUSTOMER_ORDER_LINE WHERE PART_NO = '&[M----]PART_NO'
That may be the reason why your custom menu doesn’t work.
Kind Regards
Ozgun Bal
You are right Ozgun, i removed the square brackets, even if the syntax is correct, and the parameters are not correctly passed
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.