Skip to main content
Question

Calling a quick report from a rmb menu passing parameters


Ivanoman
Sidekick (Customer)
Forum|alt.badge.img+5

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

5 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 101 replies
  • May 19, 2022

Hello @Ivanoman ,

 

You can use quick report parameters like below; you should match the source and destinations columns.

 

Kind Regards

Ozgun Bal


Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

Ivanoman
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 12 replies
  • May 20, 2022

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

 


Forum|alt.badge.img+10
  • Hero (Customer)
  • 101 replies
  • May 20, 2022

Dear @Ivanoman ,

 

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

 


Ivanoman
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 12 replies
  • May 20, 2022
Ozgun BAL wrote:

Dear @Ivanoman ,

 

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings