Skip to main content
Question

Passing a parameter to a quick report from a lobby element silently

  • December 6, 2024
  • 0 replies
  • 55 views

Forum|alt.badge.img+1

Hi!

I have been attempting to pass a couple of parameters to a quick report via a lobby element, but I need this to happen without the Quick Report Query prompt where the user has to press “OK”. 

In other word, is it possible to pass the parameters silently/suppress the window prompt? 

 

For context: I am making ~20 quick reports that are all based off of the same logic.

Simplified query below:

Select * from ifsapp.absence_registration where absence_type_id = “X” having sum(abs_duration)>Y”

and instead of having to copy/paste this to 20 different reports, changing these 2 variables and making it a nightmare to maintain if any changes were to happen, I’d like to have one report where I simply pass these 2 variables via the lobby elements navigation url doing the following:

 

Changing the query to: 

Select * from ifsapp.absence_registration where absence_type_id = ‘&ABSENCE_TYPE_ID’ having sum(abs_duration)>’&ABS_DURATION’

and in the lobby element I am then using the URL of:

ifsrep:qr.123456?ABSENCE_TYPE_ID=TestID&ABS_DURATION=8

 

Which populates the parameter as expected, but I get the window prompt up which I want to suppress

Is this at all possible? Having attempted to look this up for a few hours I’ve hit a dead end. Documentation mentions nothing of it, and the only thing I found was mention of Custom Menu -- but I have been unable to find the connection between the report running with suppressed prompt and a custom menu which seems to just straight up run the report from somewhere.

 

Overall I got over 50 reports that has to be made, but it can be reduced down to maybe 4 or 5 different quick reports for ease of maintenance if I can achieve this. 

 

Thank you!

0 replies

Be the first to reply!

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