Lobby Link to Excel Quick Report

Hi @Matthew ,

Lobby is a representation of data. There you would be able to navigate to data such as;

• Navigating to a form
• Provide aggregate value such as count, or a matrix  or a chart                                                                                    
  
  So as you mentioned you could link to a quick report, but at the same time you would not be able to have the ‘Export to Excel’ functionality to be appended to a lobby tile. You could find this option on ‘Create New Quick Report’  , ‘Quick Report Categories’, ‘Quick Reports’ overview page or on the Quick Report itself.
  
  So the export to excel can not be attached to a lobby tile to export a quick report from a lobby element at one click.       

Hello, I’m trying to open a Quick Report with a link from a Lobby. In the original question you mention that you were able to do this. Can you explain how you are linking to quick reports from lobbies and how you’re passing parameters to them? I’m using ifsapf:tbwQuickReport? as a starting point but am having no luck passing the report Id and project id as parameters.

Thanks

Sam

Hello there. I have a lot of experience with lobby screens. Set the quick report parameter for the report as in the example below.  error 1.where t.emp_no = '& EMP_NO'  successful 1.where t.emp_no = &EMP_NO   URLs  ifsrep: qr.79991  and parameter

1

2

3

Thank you, that was exactly what I was looking for!

Thanks @ADNAN its very usefull syntax usage.

Hi @ADNAN 

I’ve tried with this link 

ifsrep: qr.79991 

to get quick report form lobby

but no luck 

getting this screen when pressing a column on lobby

Could you please help?

Thanks,

Narsi.

hi @Narsi 

Can you send the sql sentence of the report?

Hi @ADNAN 

Quick Report SQL:

select 
PART_NO,
CONTRACT,
WAREHOUSE,
LOCATION_NO,
Inventory_Location_API.Get_Location_Name(CONTRACT, LOCATION_NO) as "Location Name",
INVENTORY_PART_API.Get_Description(contract,part_no) as "Part Description",
CONFIGURATION_ID,
LOT_BATCH_NO,
SERIAL_NO,
CONDITION_CODE_MANAGER_API.Get_Condition_Code (PART_NO,SERIAL_NO,LOT_BATCH_NO )  as "Condition",
Condition_Code_API.Get_Description(CONDITION_CODE_MANAGER_API.Get_Condition_Code (PART_NO,SERIAL_NO,LOT_BATCH_NO )) as "Condition Description",
ENG_CHG_LEVEL,
Inventory_Part_API.Get_Unit_Meas(CONTRACT, PART_NO)  as UoM
from INVENTORY_PART_IN_STOCK_UIV
where CONTRACT = ‘101’ and PART_NO = &PART_NO

Lobby Element Screen:

Lobby Data Source:

Thanks,

Narsi.

hi @Narsi 

Lobby Element Screen:

just write this code   ifsrep: qr.448404  

Make sure the report id information is correct.

Hi @ADNAN ,

I have written as ifsrep: qr.448404 

Checked report ID

but no luck still getting same screen 

Thanks,

Narsi.

Hi, 

Is it possible to open a quick report with a link from a Lobby and passing user input parameters, for example date, to the quick report? 

And is it possible to pass parameters from all Lobby element, for example a counter? 

Thanks,

Emma

Emma wrote:

Hi, 

Is it possible to open a quick report with a link from a Lobby and passing user input parameters, for example date, to the quick report? 

 

And is it possible to pass parameters from all Lobby element, for example a counter? 

Thanks,

Emma

Hi, yes it’s possible. In navegation you put like this:

ifsrep:qr.778207?Year=$Ano$&Start_month=$Start month$

Year= (this is the quickreport parameter)

$Ano$ (this is the element parameter

If you need to add more than one, you put &

hope it helps

Br