Galera eu tenho um template/relatório formato livre na minha consulta o código é este:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=us-ascii">
<TITLE></TITLE>
<META NAME="GENERATOR" CONTENT="OpenOffice.org 3.3 (FreeBSD/amd64)">
<META NAME="CREATED" CONTENT="0;0">
<META NAME="CHANGED" CONTENT="0;0">
<STYLE>
<!--
BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small }
-->
</STYLE>
</HEAD>
<BODY TEXT="#000000">
<TABLE FRAME=VOID CELLSPACING=0 COLS=12 RULES=NONE BORDER=0>
<COLGROUP><COL WIDTH=69><COL WIDTH=85><COL WIDTH=66><COL WIDTH=63><COL WIDTH=61><COL WIDTH=59><COL WIDTH=93><COL WIDTH=85><COL WIDTH=82><COL WIDTH=85><COL WIDTH=58><COL WIDTH=458></COLGROUP>
<TBODY>
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=69 HEIGHT=32 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Tipo</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=85 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Data</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=66 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Entrada</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=2 WIDTH=124 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Intervalo</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=59 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Saída</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=93 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Total</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=85 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Desloca-mento*</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=82 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Refeição</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=85 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Estadia</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=58 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">RAT</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=2 WIDTH=458 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Resumo</FONT></TD>
</TR>
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Entrada</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Saída</FONT></TD>
</TR>
<!-- BEGIN bl2 -->
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=16 ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_TIPO}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM SDNUM="1033;1033;M/D/YYYY"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_DATA}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;0;H:MM;@"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_HR_ENTRADA}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;0;H:MM;@"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_HR_EINTER}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;0;H:MM;@"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_HR_SINTER}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;0;H:MM;@"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_HR_SAIDA}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM SDVAL="0" SDNUM="1033;0;H:MM;@"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_HR_TOTAL}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM SDNUM="1033;0;#,##0_ ;-#,##0 "><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_QTD_DESLOCA}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM SDNUM="1033;0;#,##0_ ;-#,##0 "><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_QTD_REFEICAO}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_QTD_ESTADIA}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM SDVAL="31" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_ID}</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">{rat.RAT002_OBS}</FONT></TD>
</TR>
<!-- END bl2 -->
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=6 HEIGHT=16 ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Total de Eventos:</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="3.2875" SDNUM="1033;0;[H]:MM:SS;@"><B><FONT FACE="Calibri" COLOR="#000000">{SOMA_HORA_EVENTOS}</FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="20" SDNUM="1033;0;#,##0_ ;-#,##0 "><B><FONT FACE="Calibri" COLOR="#000000">{SOMA_QTD_DESLOCA}</FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="0" SDNUM="1033;0;#,##0_ ;-#,##0 "><B><FONT FACE="Calibri" COLOR="#000000">{SOMA_REFEICAO}</FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="0" SDNUM="1033;1033;General"><B><FONT FACE="Calibri" COLOR="#000000">{SOMA_ESTADIA}</FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ROWSPAN=4 ALIGN=CENTER VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000"><BR></FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000"><BR></FONT></TD>
</TR>
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=6 HEIGHT=16 ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Valor Unitário:</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="60" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><FONT FACE="Calibri" COLOR="#000000"> {VALOR_HORA} </FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="29.4" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><FONT FACE="Calibri" COLOR="#000000"> {VALOR_DESLOCA} </FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="15" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><FONT FACE="Calibri" COLOR="#000000"> {VALOR_REFEICAO} </FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="15" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><FONT FACE="Calibri" COLOR="#000000"> {VALOR_ESTADIA} </FONT></TD>
<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000"><BR></FONT></TD>
</TR>
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=6 HEIGHT=16 ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">SubTotal Financeiro:</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="4734" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><B><FONT FACE="Calibri" COLOR="#0070C0"> {SOMA_HORA_VALOR} </FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="588" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><B><FONT FACE="Calibri" COLOR="#0070C0"> {SOMA_DESLOCA_VALOR} </FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="500" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><B><FONT FACE="Calibri" COLOR="#0070C0"> {SOMA_REFEICAO_VALOR} </FONT></B></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="500" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><B><FONT FACE="Calibri" COLOR="#0070C0"> {SOMA_ESTADIA_VALOR} </FONT></B></TD>
<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000"><BR></FONT></TD>
</TR>
<TR>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=6 HEIGHT=17 ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">Total Financeiro:</FONT></TD>
<TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=4 ALIGN=RIGHT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDVAL="5822" SDNUM="1033;0;_-"R$" * #,##0.00_-;-"R$" * #,##0.00_-;_-"R$" * "-"??_-;_-@_-"><B><FONT FACE="Calibri" COLOR="#FF0000"> {SOMA_TOTAL_VALOR} </FONT></B></TD>
<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=BOTTOM BGCOLOR="#D7E4BD" SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000"><BR></FONT></TD>
</TR>
<TR>
<TD STYLE="border-top: 1px solid #000000" COLSPAN=12 HEIGHT=16 ALIGN=LEFT VALIGN=BOTTOM SDNUM="1033;1033;General"><FONT FACE="Calibri" COLOR="#000000">* DESLOCAMENTO - Percuso {KILOMETRAGEM} KM x R$ 0,60 = {Nº KM}</FONT></TD>
</TR>
</TBODY>
</TABLE>
<!-- ************************************************************************** -->
</BODY>
</HTML>
Eu fiz um export do excel para html até ai tudo bem funciona legal, só que na consulta ao invés dele incrementar a linha ele repete o template o número de registros, é a primeira vez que estou usando Formato Livre, se tiver algum lugar que eu tenha que trocar pra funcionar me digam.
Obrigado galera.