Equivalent to clicking the Report Manager command on the View menu and then clicking the Add option in the Report Manager dialog box. Creates or replaces a report definition. If this function is not available, you must install the Report Manager add-in.
Syntax
REPORT.DEFINE(report_name, sections_array, pages_logical)
Report_name specifies the name of the report. If the workbook already contains a report with report_name, the new report replaces the existing one.
Sections_array is an array that contains one or more rows of view, scenario, and sheet name that define the report. The sheet name is the sheet on which the view and scenario are defined. If the sheet name is not specified, the current sheet is used when REPORT.DEFINE is run.
Pages_logical is a logical value that, if TRUE or omitted, specifies continuous page numbers for multiple sections or, if FALSE, resets page numbers to 1 for each new section.
Remarks
REPORT.DEFINE returns the #VALUE error value if report_name is invalid or if the workbook is protected.
If there are no reports defined, this function will bring up the Add Report dialog box.
Related Functions
REPORT.DELETE Removes a report from the active workbook
REPORT.PRINT Prints a report
REPORT.GET Returns information about reports defined for the active workbook
Return to index