SAVEASEXCEL Function (TestRequestPage)
Saves a report as a Microsoft Excel (.xls) file.
The TestRequestPage from which you want to test saving the report as an Excel file.
The path and file name to which the report is saved. The file name extension should be .xls.
All filters and options that have been set on the TestRequestPage are respected in the saved report.
After you run this function, you cannot continue to interact with the TestRequestPage. If you want to continue to use the TestRequestPage variable, you must run a report again.
The following example shows the code for a test function to run a report and a request page handler function to test the request page. This example requires that you create the following:
A test codeunit called SaveAsExcel. For more information, see How to: Create Test Codeunits and Test Functions.
A test function in the test codeunit called TestSaveAsExcel. For more information, see How to: Create Test Codeunits and Test Functions.
A handler function of type RequestPageHandler called ReqPageHandler. This handler function has one parameter called RequestPage of Type TestRequestPage and Subtype Customer – Top 10 List. The RequestPage parameter is specified as VAR and is passed by reference to the handler function. For more information, see How to: Create Handler Functions.
This example also requires that you create the following variable in the C/AL Globals window of the SaveAsExcel codeunit.
//Test function: TestSaveAsExcel Filename := TEMPORARYPATH + 'MyRep.xls'; MESSAGE(Filename); IF NOT FILE.ERASE(Filename) THEN ERROR('Cannot erase %1',Filename); REPORT.RUN(111); IF NOT FILE.EXISTS(Filename) THEN ERROR('File should exist!'); //Request Page Handler function RequestPage.Customer.SETFILTER("No.", '20000'); RequestPage.ChartType.VALUE('Pie chart'); RequestPage.SAVEASEXCEL(Filename);