Is it possible to rotate a table in a generated report?

Hi all, is it possible to rotate a table that I have added to a report using Report Generator?

Simplified code so far is:

rpt = Report('Title','pdf');
tb = FormalTable(table_with_many_columns_and_some_rows);
add(rpt, tb);

My problem is that the table

table_with_many_columns_and_some_rows

has about 9 rows and 24 columns, so it does not fit the standard A4 size when generating the PDF report. Therefore, is it possible to rotate the table in the PDF so that it is read in landscape instead of portrait?

Alternatively, how could I format the font size of the table contents to shrink the table so that the whole wide table fits within the A4 page?

Thanks!

Answer 1

[Krishnan Ramkumar]

Hi,

There are multiple ways to fit a large table in a A4 size paper.

1) You can set the report layout to be landscape and then add the FormalTable to the report

For example:

rpt = Report('Title','pdf');
rpt.Layout.Landscape = true;
tb = FormalTable();
tb.RowSep = 'Solid';
tb.ColSep = 'Solid';
tb.Border = 'Solid';
add(rpt, tb);

2) Starting from R2018b we inroduced a new utility called as TableSlicer, which slices the input table into multiple chunks and add each chunk to the report. You can specify max number of columns in each chunk and also specify the number of columns to retain in each slice.

rpt = mlreportgen.report.Report('title', 'pdf');
tb = mlreportgen.dom.FormalTable(magic(25));
tb.RowSep = 'Solid';
tb.ColSep = 'Solid';
tb.Border = 'Solid';
slicer = mlreportgen.utils.TableSlicer("Table", tb, "MaxCols",...
    6, "RepeatCols", 1);
slices = slicer.slice();
for slice = slices
    % Adding title to each slice. Here am adding the Repeated column, start column and end column
    str = sprintf("Repeated Column Index: %d ,SlicedColumns: From column %d to column %d",...
        slicer.RepeatCols,slice.StartCol, slice.EndCol);
    para = mlreportgen.dom.Paragraph(str);
    para.Bold = true;
    para.Style = [para.Style,{mlreportgen.dom.KeepWithNext(true),...
        mlreportgen.dom.OuterMargin("0pt","0pt","5pt","0pt")}];
    add(rpt, para);
    add(rpt, slice.Table);
end
close(rpt);

More information about this can be found in the below documentation link

https://www.mathworks.com/help/rptgen/ug/mlreportgen.utils.tableslicer-class.html

https://www.mathworks.com/help/rptgen/ug/mlreportgen.utils.tableslice-class.html

Regarding reducing the font size of the table entries in a FormalTable, you can specify font size in table entries style property of the formal table

tb.TableEntriesStyle = {mlreportgen.dom.FontSize('20pt')}

[K W]

Thanks a lot. Some follow-up questions:

1) is it possible to format only one page, or some specific pages in the document, as <the other orientation>?

2) the code given to change the font size doesn't seem to work. I also tried

tb.Style = {Color('red'),FontSize('5pt')};

which does turn the font red but does not change the font size. This is true for both my own code and your sample code for using the TableSlicer.

Any ideas why that might be?

3) Is there a full list of what can be changed in tb.Style, tb.Header.Style etc.? I have tried to find such a list in the help pages but to no avail... (specifically am trying to set the Header font as bold, but

tb.Header.Style.FontWeight = 'bold';

and other such variants give the error

Invalid Format style.

[Krishnan Ramkumar]

Hello,

1) You can either change the portrait to landscape layout for entire report or specifc chapters

The below code changes the entire report to landscape

>> rpt.Layout.Landscape = true;

The below code changes the specific chapter to landscape

>> chapter = mlreportgen.report.Chapter();
>> chapter.Layout.Landscape = true;

More information about this can be found at the below documentation link

https://www.mathworks.com/help/rptgen/ug/mlreportgen.report.report-class.html#mw_06701051-0610-481d-87b3-ce57d10ea7da

https://www.mathworks.com/help/rptgen/ug/mlreportgen.report.chapter-class.html

2) There was a bug with regards to programmatic specification of font size not getting honored and it has been fixed in R2018b_update3. Please find the link below regarding more information about this.

https://www.mathworks.com/support/bugreports/1864851

3) With respect to changing the Header style, You can specify something like this. Here I am appending the bold style to the existing Header Style

>> tb.Header.Style = [tb.Style, {mlreportgen.dom.Bold(true)}];

[K W]

A great help, thanks!