PivotSection object, ResultsSection object, TableSection object, OLAPQuerySection object
Sets the type of unit (row, pixel or none) to use for the vertical page break on a HTML page. This property is used with the BqHTMLPageBreakUnits constant group and the HTMLExportBreakRowCount (Property).
This property references the BqHTMLPageBreakUnits constants group, which consists of these values:
This example shows how to print the names of all the columns in the Results section to the Console window; export the section in HTML format; enable the vertical page break unit to the row option; and set the number of rows per HTML page to one hundred:
MyResults = ActiveDocument.Sections["Results"] ColumnCount = MyResults.Columns.Count for (I=1;I<= ColumnCount;I++) Console.Write("Column#"+I+":"+MyResults.Columns[I].Name+"\r\n") MyResults.Export("c:\\temp\\Sample.htm", bqExportFormatHTML) MyResults.HTMLVerticalPageBreakUnits = bqHTMLPageBreakUnitsRows MyResults.HTMLExportBreakRowCount = 100