Skip to main content
Question

Quick report parameter in Custom Menu without parameter window

  • September 13, 2022
  • 9 replies
  • 325 views

Forum|alt.badge.img+8

Hi All,

Is it possible to run a Quick Report from a Custom Menu without showing the parameter window ?

Just to be more clear. It is a SQL Quick Report. The SQL command is something like select a,b,c from view where d=’&parameter’.

Now my question is: when it is invoked by a Custom Menu, I don’t want to see the window that is asking me for &parameter, I just want to run it and see the results.

Is this possible ?

Thanks.

9 replies

Forum|alt.badge.img+13

Hi @luca.puccini,

In your SQL command, if you specify the exact parameter value instead of “&parameter” it will not ask for a parameter value.

 

Best Regards,
Bhagya


Forum|alt.badge.img+11
  • Hero (Customer)
  • 149 replies
  • September 13, 2022

…… But If you hardcode the parameter, how can you pass a value from a custom menu? I assume the user here wants to send the quick report from the object the RMB is invoked from with some sort of parameter value.


Forum|alt.badge.img+13

Hi @luca.puccini,

If you want to send a dynamic parameter value the following must be configured.

In the quick report window specify the parameter value as &SourceSQLColumnName.


In the custom menu configuration window, add the quick report parameters value section.
 

Hope this helps!
Best Regards,
Bhagya



 


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • September 13, 2022

In other words, is it possible to avoid this window ?

 


Forum|alt.badge.img+13

Yes, it is! :)


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • September 13, 2022

Yes, it is! :)

Ok, but how ?

The SQL is

as you suggested, but the window still appear

 


Forum|alt.badge.img+13

Hi @luca.puccini,

In the custom menu configuration, under quick report parameters , specify the source key name and destination key name in CAPITALS.

BR,
Bhagya


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 28 replies
  • September 14, 2022

Hi @luca.puccini,

In the custom menu configuration, under quick report parameters , specify the source key name and destination key name in CAPITALS.

BR,
Bhagya

It remains exactly the same


ADNAN
Sidekick
Forum|alt.badge.img+8
  • Sidekick
  • 56 replies
  • July 4, 2023
Hello,When you set your parameters, run the report after saying reload.