Express > Express Assembly Interfaces > IEaxSheets > IEaxSheets.Add
Add(Value: IEaxAnalyzer): IEaxSheet;
Value. Express report that is the basis to create a sheet.
The Add method creates the sheet that is based on the current express report.
The child object is added when executing the Add method for the source express report. The child object is the copy of the express report passed by the Value parameter.
Executing the example requires two express reports with the EXPRESS_REPORT, EXPRESS_REPORT_2 identifiers and a cube with the CUBE identifier.
Sub UserProc;
Var
MB: IMetabase;
Eax: IEaxAnalyzer;
Sheet: IEaxSheet;
CubeInst: ICubeInstance;
Begin
MB := MetabaseClass.Active;
Eax := MB.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
//Create a sheet based on the current express report
Eax.Sheets.Add(MB.ItemById("EXPRESS_REPORT_2").Bind As IEaxAnalyzer);
//Create a sheet based on a new express report
Sheet := Eax.Sheets.AddNew;
//Specify the source for a new sheet
CubeInst := MB.ItemById("CUBE").Open(Null) As ICubeInstance;
Sheet.Analyzer.OpenCube(CubeInst);
(Eax As IMetabaseObject).Save;
End Sub UserProc;
On executing the example two sheets are created in the EXPRESS_REPORT express report. The first sheet is based on the existing EXPRESS_REPORT_2 express report, the second is based on the new express report with the CUBE cube as the source.
See also:
