Quick Report Custom Menu Sample (app75)

admin

Foundation1 / Configuration Guide / User Experience / Admin Configure Custom Menues / Quick Report Custom Menu Sample / This page

[url=][/url][url=][/url][url=][/url]

Foundation1 Configuration Guide - Configure User Experience - Configure  Custom MenusQuick Report Custom Menu SampleThis page describe how to create a custom menu that executes a quick report.
This information is useful when you add a menu item that runs a quick report.
[url=]!2009-12-08[/url] Page added.
Contents

• Define the Custom Menu
• Specify Report Parameters
  

Define the Custom Menu

• Start IFS Base Server Administration tool (Admin.exe) and open the window:         Configuration/Custom Menu/Custom Menu.
• Press New.
• Enter the window where you will use the custom menu.
• Enter an ordering.
• Set Action Type to         Quick Report.
• Check the Bundle Execution checkbox. By         default Bundle Execution is unchecked.         
  [url=]!2012-02-26[/url]          Explanation updated Bundle execution means that one to many         selected rows are used as input values to a quick report. Bundle execution         is only possible in tables, where you have the option to select several         records and launch the quick report. The         section Quick         Report Custom Menu using Bundle Execution explains how to use this         functionality.   
  
• Enter the name of the quick report to be executed in the         Parameter field. The name is the number         that identifies a quick report. The quick report number can be found in         the Quick Report feature. To open the         Quick Report feature you start IFS Enterprise         Explorer and navigate to: Info Services/Quick         Reports using the navigator. Select the quick report, choose menu         item Show Details and you will navigate to         the Quick Report feature. The quick report         number is appended to the value of the Presentation         Object field. For example "repQUICK_REPORT183" is quick report number         "183".
• Presentation object will be added automatically. The user must be         granted to the PO to be able to run the custom menu item.
• Press the Save button to save the         custom menu header.
• Enter the menu text. The menu text is the name of the menu for a given         language code.
  

Specify Report ParametersEnter the report parameter in the Key Translations tab. The report parameters are the substitution variables within the sql  expression of the quick report. The value to map to the report parameter is the  corresponding database column name in the window where the custom menu is used.
Quick Report  Custom Menu using Bundle ExecutionCustom menus of type Quick Report that  support bundled execution, requires a Sql quick report. The sql where statement  on the quick report must use the IN operator. It shall look like the following  example:

SELECT * FROM IFSAPP.SUPPLIER_INFO WHERE (SUPPLIER_ID, NAME) IN ([&SUPPLIERVALUES])

The where statement above have a substitution variable (quick report  parameter) which is surrounded by square brackets. The square brackets indicate  that it is an expandable report parameter and the syntax will slip through sql  parser validation.
In the custom menu window you specify the columns that shall be used as  values in the substitution variable in the where statement. That is a dynamic  value list that expands depending on how many rows you have selected when  executing the custom menu. It will look like this in the custom menu form:

Source Key Names stores the column(s) to use in the window for the custom menu.

Parameter stores the QR parameter (substitution variable) to use. The tab Expandable  Parameter will only be enabled when the checkbox Bundle Execution is checked.

When the quick report is executed the substitution variable  will be replaced with the column values of the select rows in the window of the  custom menu. The sql will for example look like this if the custom menu was  executed on two selected rows:

SELECT * FROM IFSAPP.SUPPLIER_INFO WHERE (SUPPLIER_ID, NAME) IN (('1','SUPPLIER 1'),('2','SUPPLIER 2'))