We use macros to build the columns since the column count is variable, based on user input (columns headers are dates).
We use \include to insert our content.
Code: Select all
\documentclass[12pt]{report}
% set margins
\usepackage[]{geometry}
\geometry{landscape, headsep=1cm,headheight=2.5cm,letterpaper, top=1.75in, bottom=0.75in, left=0.75in, right=0.75in }
\usepackage{longtable}
\usepackage{fancyhdr} % A header / footer management package
\usepackage{lastpage}
\usepackage{multirow} % Used for multicolumn stuff
\include{data/property_guestpasses_per_day} %include%
% Header / Footer Setup
\pagestyle{fancy}
\fancyhf{}
\fancyfoot[L]{Printed on \today}
\fancyfoot[R]{Page \thepage\ of \pageref{LastPage}}
\fancyhead[C]{ \fontfamily{ptm}\selectfont \Huge \CommunityName \\ \Large \ReportTitle }
\advance\ColCount by 2
\usepackage{array}
% Main Document
\begin{document}
\widesplit{blah}{ %
\begin{longtable}[12pt]{\TableSpec}
\endfirsthead
\multicolumn{5}{r}%
{ \textit{Continued from previous page}} \\
\hline
\hline
\endhead
\hline \multicolumn{5}{r}{\textit{Continued on next page}} \\
\endfoot
\endlastfoot
% Table Data
\cline{3-\the\ColCount}
\CrossTabColumns
\CrossTabData
\end{longtable} }
\end{document}