Design Report—Exercises

IMPORTANT
The exercise scenarios in this document uses data from the RACE version of the database released with App75 SP4 as example data.

Add a parameter to your report

Purpose: The purpose of this exercise is to show you how to create a parameter and use this as a filter criteria in your report.

Scenario: For this exercise we will create a parameter using Parameter Type 'DisplayItem'.

Windows:
IFS Business Analytics/Go to Design/Report Book/Parameters

  1. Open IFS Business Analytics
  2. Open the report created in Design Basic Report exercise
  3. Click Go to Design and click Report Book
  4. Click Parameters and click the New Parameter.  By default Visible and Editable check boxes will be selected for the New Parameter.  
  5. Select 'DisplayItem' from the List of Values as the Parameter Type. By default this will be selected.
  6. Enter Company as the Parameter Name. Note: Spaces are not allowed when giving a name for the parameter.
  7. Enter Company as the Description for the parameter.
  8. Enter Company as the Prompt Text. This is the guide text that will be used when selecting the parameter values from  the executed report.
  9. Select Company from Display Item List of Values.
  10. Select company '900' as the Default Value.  
  11. Select Name as an additional value from the Optional Display Items List of Values.
  12. Click Save Parameter.
  13. Drag Parameter Name, Parameter Value and Company Name from Display Parameters to cells A1, A2 and B2 respectively. Refer to the figure below:


     
  14. Select the report sheet and change the filter criteria to use the parameter created.
  15. Click Execute.
  16. You will be prompted to enter the value for the company.

Using Zoom In

Purpose: The purpose of this exercise is to show you how to use Zoom In for a design report.

Windows:
IFS Business Analytics/Design Mode/Zoom In

  1. Click Go to Design to get back to the design.
  2. Select Balance Amount from C6
  3. Select Zoom In tab and Select Enable Zoom In check box.
    Note: The display area for Zoom In items will be populated for the relevant data once it is selected. The fields defined as Mandatory to support the related URL option will be in bold and colored in Red. Deselecting any one of these items will raise a message stating that the URL option will be lost. The Display Items included in the design will be in bold and colored in Green.
  4. Deselect all other display items leaving Description, Company, Year Period, Account, Balance, Quantity, Year and Period.
  5. Click Execute.
  6. Select 'Account 4021' in the report and right click and click Select Zoom In. Refer to the figure below:

Copy design row and add a filter criteria for the design row

Purpose: The purpose of this exercise is to show you how to copy a design row.

Windows:
IFS Business Analytics/Go to Design

  1. Click Go to Design to switch to the design.
  2. For the design row select Filter Criteria tab and add a Filter Criteria where Account Type ='REVENUES'.
  3. Select cell A5 enter 'Revenue' as the title and change the Total in A7 to 'Revenue Total'.
  4. Select rows 5 to 7 and copy and paste into row 9 to 11.
  5. Select row 6 right click and select Copy Design Row and paste design row into row 10.
  6. Select cell A9 and enter 'Cost' as the title and change the 'Total Revenue' title to 'Total Cost'.
  7. Select Filter Criteria tab and select the second design row and change the account type where Account Type='COST'.
  8. Add* -1 to cell C6 in order the display the Revenue values as positive figures.
  9. Select the fist design row and enter a filter criteria  to exclude(<>) Account 3732. (This is done to make sure that the net profit does not equal to 0).
  10. Add a net profit row in row 13 and add  simple formula in C13(C7-C11)and D13(D7-D11) as shown below:


     
  11. Click Execute.
  12. Save report with name DESIGNXX (where XX is your initials).

Adding a Repeater to the the design row (Optional)

Purpose: The purpose of this exercise is to show you how to add a repeater level to your repeater.

Windows:
IFS Business Analytics/Go to Design/Repeater

  1. Open DESIGNXX (the report that was created in the previous exercise).
  2. Insert new rows between row 5-6  drag Account Group to row 6 , select and change the design rows to include the account group as shown below.


     
  3. Repeat step 2 for the second design row.
  4. Click Execute. Refer to the figure below:


     
  5. Save the report.