ExportComments: Boolean;
The ExportComments property determines whether comments for data cells are exported.
Available values:
True. Comments for data cells are exported.
False. Default value. Comments for data cells are not exported.
Executing the example requires that the repository contains a regular report with the REPORT identifier. The report has a standard cube as a data source, in which storing of comments for data cells is enabled. A slice and a the Table visualizer are created based on the data source. Comments are added for data cells.
Add links to the Metabase and Report system assemblies.
Sub UserProc;
Var
Mb: IMetabase;
Report: IPrxReport;
Exp: IPrxReportExporter;
Begin
Mb := MetabaseClass.Active;
Report := Mb.ItemById("REPORT").Open(Null) As IPrxReport;
Exp := New PrxReportExporter.Create;
Exp.Report := Report;
Exp.ExportComments := True;
Exp.ExportToFile("D:\Report.xlsx", "XLSX");
End Sub UserProc;
After executing the example the regular report is exported to a Microsoft Excel file. Comments are also exported for data cells.
See also: