Skip to main content

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.

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

…… 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.

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



 

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

 

Yes, it is! :)

Yes, it is! :)

Ok, but how ?

The SQL is

as you suggested, but the window still appear

 

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

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

Hello,When you set your parameters, run the report after saying reload.

 

 

 

Reply


Terms & ConditionsCookie settings