creating a pdf version of a complicated form, populated with data from a database

[Christopher W. Ryan]

I dream of using R, Rmarkdown, knittr, and pdflatex to pull individual
records from a database and generate a form like page 1 here:

https://www.cigna.com/static/www-cigna-com/docs/form-cms1500.pdf

one pdf form per database record, with the form fields populated. Then I
could print them, and mail the bills to patients' insurers.

The contents of many of the fields will be static: all records in the
database pertain to the same lab test, all are ordered by the same
physician (me), and all tests are conducted in the same place.

The R coding seems straightforward, but using pdflatex to reproduce this
complex layout strikes me as daunting--even before trying! Opinions: is
this a fool's errand? Should I not even try?

Thanks.

--Chris Ryan