The page_by function adds a page by variable to a report, table,
or plot.
The page by will generate a page break for each value of the page by variable.
A label will appear above the content showing the page
by variable value. You must be sort the data by the
page by variable prior to reporting.
page_by( x, var, label = NULL, align = "left", blank_row = "below", borders = "none" )
| x | The report specification to assign the page by to. |
|---|---|
| var | The page by variable. There can be only one page by per report, and one page by variable. The page by can be passed either quoted or unquoted. |
| label | A label to be used as a prefix to the page by variable value. By default, the label will be assigned to the variable name. Alternatively, you may specify a string value to use for the label. |
| align | How to align the page by. Default value is 'left'. Valid values are 'left', 'right', 'center', or 'centre'. |
| blank_row | Indicates whether a blank row is desired above or below the page by. Default value is 'none'. Valid values are 'above', 'below', 'both', or 'none'. |
| borders | Whether and where to place a border. Valid values are 'top', 'bottom', 'left', 'right', 'all', 'outside', or 'none'. Default is "none". The 'left' and 'right' border specifications only apply to RTF, HTML, PDF, and DOCX reports. |
Only one page by is allowed per report, table, or plot. The page by
label will
appear on all pages of the object. The page by label may be aligned on the
left, right, or center. Use the align parameter to specify the
alignment.
You must sort the data by the page by variable prior to reporting. The page by labels will appear in the sorted order. Failure to sort the page by variable prior to reporting may produce unexpected results.
create_table to create a table, and
create_plot to create a plot.
Other report:
add_content(),
create_report(),
footnotes(),
options_fixed(),
page_footer(),
page_header(),
print.report_spec(),
set_margins(),
title_header(),
titles(),
write_report()
library(reporter) library(magrittr) # Create temp file path tmp <- file.path(tempdir(), "iris.txt") # Sample and sort iris data frame dat <- iris[sample(1:150, 50), ] dat <- dat[order(dat$Species), ] # Create table tbl <- create_table(dat) %>% page_by(Species, "Species: ") %>% define(Species, visible = FALSE) # Create the report object rpt <- create_report(tmp, orientation = "portrait") %>% page_header("Sponsor: Iris Society", "Study: flowers") %>% titles("Table 2.0", "IRIS Sample Report with Page By") %>% add_content(tbl) %>% page_footer(Sys.time(), right = "Page [pg] of [tpg]") # Write the report to the file system write_report(rpt) # Write report to console writeLines(readLines(tmp, encoding = "UTF-8")) # Sponsor: Iris Society Study: flowers # Table 2.0 # IRIS Sample Report with Page By # # Species: setosa # # Sepal.Length Sepal.Width Petal.Length Petal.Width # ------------------------------------------------- # 5.4 3.9 1.7 0.4 # 4.9 3.1 1.5 0.1 # 4.8 3.1 1.6 0.2 # 5.1 3.5 1.4 0.3 # 5 3.5 1.6 0.6 # 5 3.3 1.4 0.2 # 4.4 3 1.3 0.2 # 5.1 3.5 1.4 0.2 # 5.4 3.4 1.5 0.4 # 4.9 3.6 1.4 0.1 # 4.6 3.1 1.5 0.2 # 4.6 3.2 1.4 0.2 # 5.1 3.3 1.7 0.5 # ... # 2020-10-25 19:33:35 Page 1 of 3 # # Sponsor: Iris Society Study: flowers # Table 2.0 # IRIS Sample Report with Page By # # Species: versicolor # # Sepal.Length Sepal.Width Petal.Length Petal.Width # ------------------------------------------------- # 4.9 2.4 3.3 1 # 6.3 3.3 4.7 1.6 # 6.1 2.8 4.7 1.2 # 6 2.9 4.5 1.5 # 6.7 3 5 1.7 # 5.6 3 4.5 1.5 # 5.8 2.7 4.1 1 # 6.7 3.1 4.7 1.5 # 6.1 2.9 4.7 1.4 # 5 2 3.5 1 # 5.9 3.2 4.8 1.8 # 5.5 2.5 4 1.3 # 7 3.2 4.7 1.4 # 6.3 2.3 4.4 1.3 # 6.1 2.8 4 1.3 # 6 2.2 4 1 # 5.5 2.6 4.4 1.2 # 6 3.4 4.5 1.6 # 5 2.3 3.3 1 # 5.5 2.4 3.7 1 # ... # 2020-10-25 19:33:35 Page 2 of 3 # # Sponsor: Iris Society Study: flowers # Table 2.0 # IRIS Sample Report with Page By # # Species: versicolor # # Sepal.Length Sepal.Width Petal.Length Petal.Width # ------------------------------------------------- # 6.3 3.4 5.6 2.4 # 7.9 3.8 6.4 2 # 6.7 3.1 5.6 2.4 # 6.2 2.8 4.8 1.8 # 6.7 3.3 5.7 2.5 # 6.2 3.4 5.4 2.3 # 5.6 2.8 4.9 2 # 7.7 3.8 6.7 2.2 # 7.7 2.6 6.9 2.3 # 6.9 3.1 5.4 2.1 # 6.5 3.2 5.1 2 # 6.1 2.6 5.6 1.4 # 5.7 2.5 5 2 # 6.5 3 5.8 2.2 # 6.3 2.8 5.1 1.5 # 7.6 3 6.6 2.1 # 6.3 2.5 5 1.9 # ... # 2020-10-25 19:33:35 Page 3 of 3