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",
format = NULL
)The report specification to assign the page by to.
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.
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.
How to align the page by. Default value is 'left'. Valid values are 'left', 'right', 'center', or 'centre'.
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'.
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.
The format to use for the page by column data. The format can
be a string format, a formatting function, a lookup list, a user-defined
format, or a formatting list.
All formatting is performed by the fapply function from
the fmtr package. For
a list of common formatting codes, see FormattingStrings.
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