Do the following to start customizing your report:
-
In , click Reports > New to open the New Report Template dialog box.
-
Select All Feeder Load Summary (Enhanced) as your source template.
-
Enter a name for the new report and click OK.
-
When prompted to edit the report, click Yes.
-
Edit the report template as you require.
-
Open the Visual Basic Editor.
-
The start point is in ThisWorkBook.EndReport.
When working in the Visual Basic Editor, the following restrictions apply to ensure that the report engine functions properly:
-
Do not modify the ReportEngine module.
-
Do not modify the properties, content, or data in the following sheets:
-
Sheet1(Template)
-
Sheet2(SPReport_Definition)
-
When working with ThisWorkBook, do not modify, rename, or delete any of the following variables, subs and functions:
-
Public SPReport As Object
-
Private m_objXLAgent As Object
-
Private Sub Workbook_Deactivate()
-
Public Sub BeginReport(vParam As Variant)
-
Public Sub FinalReport(vParam As Variant)
-
Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window)
-
Public Sub ReleaseReference()
-
Public Sub GetSPReportSheets(sSheet1 As String, sSheet2 As String)
-
You can modify the contents of the EndReport sub; however, do not add any parameters to it, do not rename or delete it.
See The EndReport Sub to learn about the customization entry point.