Challenge XIV

<< Click to Display Table of Contents >>

 

Challenge XIV

Create a button to export a report to an Excel file

 

TIP

Use Report's Export method.

 

1.Insert another button on Event_Screen, with the text "Export".

2.Select the Scripts tab of this object and create a script.

3.Use AppBrowser to select Report's Export method. Notice that all parameters of this method are explained on Elipse Power Reference and Scripts Manual, which is opened on AppBrowser's right panel.

Export method

Export method

4.Paste and adapt the script, which must be as follows:

Sub CommandButton2_Click()
  Set Report = Application.LoadReport("AlarmReport")
  Report.Export "EXCEL", "C:\Elipse_Power_Tutorial\ExcelReport.xls"
End Sub

 

5.Execute the application and test this new functionality.

Was this page useful?