odfWeave - A loop of the "same" data

Before I go and do this another way - can I check if anyone has a way of 
looping through data in odfWeave (or possibly sweave) to do a repeating 
analysis on subsets of data?

For simplicity lets use mtcars dataset in R to explain.  Dataset looks like this:

mtcars

              mpg cyl disp  hp drat   wt ...
Mazda RX4     21.0   6  160 110 3.90 2.62 ...
Mazda RX4 Wag 21.0   6  160 110 3.90 2.88 ...
Datsun 710    22.8   4  108  93 3.85 2.32 ...
              ............

Say I wanted to have a 'catalogue' style report from mtcars, where on 
each page I would perhaps have the Rowname as a heading and then plot a 
graph of mpg highlighting that specific car

Then add a page break and *do the same for the next car*.  I can manually do this of course, but it is effectively a loop something like this:

for (n in length(mtcars$mpg)) {
barplot (mtcars$mpg, col=c(rep(1,n-1),2,rep(1,length(mtcars$mpg)-n)))
}

There is a odfWeave page break function so I can do that sort of thing 
(I think).  But I don't think I can output more than one image can I? 
In reality I will want several images and a table per "catalogue" page.

At the moment I think I need to create a master odt document, and create 
individual catalogue pages.  And merge them into one document - but that 
feels clunky (unless I can script the merge!)

Anyone got a better way?

On Thu, 1 Jun 2017, POLWART, Calum (COUNTY DURHAM AND DARLINGTON NHS
FOUNDATION TRUST) via R-help wrote:

Before I go and do this another way - can I check if anyone has a way of
looping through data in odfWeave (or possibly sweave) to do a repeating
analysis on subsets of data?

For simplicity lets use mtcars dataset in R to explain.  Dataset looks
like this:

mtcars

              mpg cyl disp  hp drat   wt ...
Mazda RX4     21.0   6  160 110 3.90 2.62 ...
Mazda RX4 Wag 21.0   6  160 110 3.90 2.88 ...
Datsun 710    22.8   4  108  93 3.85 2.32 ...
              ............

Say I wanted to have a 'catalogue' style report from mtcars, where on each
page I would perhaps have the Rowname as a heading and then plot a graph of
mpg highlighting that specific car

Then add a page break and *do the same for the next car*.  I can manually
do this of course, but it is effectively a loop something like this:

for (n in length(mtcars$mpg)) {
barplot (mtcars$mpg, col=c(rep(1,n-1),2,rep(1,length(mtcars$mpg)-n)))
}

There is a odfWeave page break function so I can do that sort of thing (I
think).  But I don't think I can output more than one image can I? In
reality I will want several images and a table per "catalogue" page.

At the moment I think I need to create a master odt document, and create
individual catalogue pages.  And merge them into one document - but that
feels clunky (unless I can script the merge!)

Anyone got a better way?

For a complex template inside a loop, I'd probably do as Jeff suggests and
use a knitr child document for ease of developing and debugging the
template.

But for the simple case you describe I'd use a brew script to
unroll the loop.

You would write your input file as usual, but put a brew script in the
right place, then run brew on the input file to produce an
intermediate file that unrolls the loop, then weave the intermediate
file to get your desired result.  Here is a simple example of such you can
run in an R session (assuming the brew package is installed) and see the
results printed out.

--8<---------------cut here---------------start------------->8---

brew::brew(text="

Everything before the loop

<% for (i in 1:10) { %>
Print the value of i
<% print(i) %> or better yet
\\Sexpr{<%= i %>}
<% } %>

everything after

")

--8<---------------cut here---------------end--------------->8---

The double backslash is needed in the literal string used here.  If
you put that script in a file using an editor, you would just use a
single backslash.

HTH,

Chuck