Ok, I am trying to do something that I would think would be very easy. And I
guess I am just a little slow today, but I figure out how i would do this.
I have query of scores and employee names. I would like to have a header and
footer and the body looped over per dept. I also have column headings that I
would like at the top of each page. I also would like for the page break to
the next page without placing the header on the second page, but place the
column headings on the second/third pages on so on. When a new department is
looped over place the header and column headings and loop over the dept data.
With a footer on each page.
Here is the code:
<cfdocument format="pdf" overwrite="Yes" pagetype="letter"
orientation="portrait" unit="in" encryption="none" fontembed="Yes"
backgroundvisible="No">
<CFOUTPUT query="SelectEmployees">
<cfdocumentsection margintop=".01">
<cfdocumentitem type="header">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<TR align="center">
<TD colspan="5"> </TD>
</TR>
<TR align="center">
<TD colspan="5"><STRONG><DIV align="center">#TestName#</DIV></STRONG></TD>
</TR>
<TR align="center">
<TD colspan="5"><STRONG><DIV align="center">#Form.ReportType#
Report</DIV></STRONG></TD>
</TR>
<TR align="center">
<TD colspan="5"><DIV
align="center">#DateFormat(NOW(),"mm/dd/yyyy")#</DIV></TD>
</TR>
<TR>
<TD colspan="5"><STRONG>Entity:</STRONG>
#SelectEmployees.EntityName#</TD>
</TR>
<TR>
<TD colspan="5"><STRONG>DEPT##</STRONG> #SelectEmployees.DeptNumber# -
#SelectEmployees.DeptName#</TD>
</TR>
</cfdocumentitem>
<cfdocumentitem type="footer">
<cfoutput><div align="right">Page #cfdocument.currentpagenumber# of
#cfdocument.totalpagecount#</div></cfoutput>
</cfdocumentitem>
<TR>
<TD><B>Hire Date</B></TD>
<TD><B>Employee:</B></TD>
<TD><B>Name</B></TD>
<TD><cfif Form.ReportType EQ "Passed" OR Form.ReportType EQ
"Acknowledgements Passed"><B>Class Date</B><cfelse> </cfif></TD>
<TD> </TD>
</TR>
<CFSET Request.TotalNumberEmp = Request.TotalNumberEmp +1>
<TR bgcolor=###IIF(SelectEmployees.CURRENTROW MOD 2, DE ('FFFFFF'), DE
('F1F0E4'))#>
<TD>#DateFormat(HireDate,"mm/dd/yyyy")#</TD>
<TD>#EmployeeID#</TD>
<TD>#EMP_FNAME# #EMP_LNAME#</TD>
<TD><cfif Form.ReportType EQ "Passed" OR Form.ReportType EQ
"Acknowledgements
Passed">#DateFormat(DateTaken,"mm/dd/yyyy")#<cfelse> </cfif></TD>
<TD> </TD>
</TR>
</TABLE>
</cfdocumentsection>
</CFOUTPUT>
</cfdocument>
This does not seem to work at all and not even very close.
Any help would be great.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196366
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
