pco pco dsDadosAtendimento id,System.Int32 data_cadastro,System.String paciente,System.String 30 dsDadosAtendimento pco SELECT ate.id, DATE_FORMAT(ate.dt_cadastro, '%d/%m/%Y') AS data_cadastro, pac.nome AS paciente FROM bt_paciente pac, bt_atendimento ate LEFT JOIN bt_exame_realizado er ON (er.fk_atendimento = ate.id) LEFT JOIN bt_exame_convenio ec ON (ec.id = er.fk_exame_convenio) WHERE (ate.fk_paciente = pac.id) AND (ate.fk_posto = {postoColeta}) AND (DATE_FORMAT(ate.dt_cadastro, '%Y/%m/%d') BETWEEN '{dt_inicial_fx}' AND '{dt_final_fx}') AND (ec.fk_convenio IN ({exFiltro})) GROUP BY ate.id dsDadosExames nome_convenio,System.String nome_exame,System.String codigo_exame,System.String valor_exame,System.Decimal data_assinatura,System.String id_atendimento,System.Int32 30 dsDadosExames pco SELECT conv.nome AS nome_convenio, ex.nome AS nome_exame, ec.codigo AS codigo_exame, ec.valor AS valor_exame, DATE_FORMAT(er.dt_liberado, '%d/%m/%Y %H:%i:s') AS data_assinatura, er.fk_atendimento as id_atendimento FROM bt_exame_realizado er, bt_exame_convenio ec, bt_exame ex, bt_convenio conv WHERE (er.fk_exame_convenio = ec.id) AND (ec.fk_exame = ex.id) AND (ec.fk_convenio = conv.id) AND (ec.fk_convenio IN ({exFiltro})) dsRelacao id_atendimento dsRelacao dsRelacao id ,urlTopoFx,urlTopoFx,System.String,,False,False ,additionalTitle,additionalTitle,System.String,,False,False ,dtInicial,dtInicial,System.String,,False,False ,dtFinal,dtFinal,System.String,,False,False ,idAtendimento,idAtendimento,System.String,dsDadosAtendimento_x002E_id,True,True ,postoColeta,postoColeta,System.String,,False,False ,dt_inicial_fx,dt_inicial_fx,System.String,,False,False ,dt_final_fx,dt_final_fx,System.String,,False,False ,exFiltro,exFiltro,System.String,,False,False ,nomePosto,nomePosto,System.String,,False,False ,valorTotal,valorTotal,System.Single,dsDadosExames_x002E_valor_exame,True,True EngineV2 pt None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,20,6.2 Transparent 0,0,20,2.8 {urlTopoFx} Image1 True Transparent 11.4,5.6,8.6,0.6 Arial,8 Right 0,0,0,0 Text2 Impresso em: {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm:ss")} Black dd/MM/yyyy Expression Transparent 0,3.8,2.8,0.4 Arial,10,Bold 0,0,0,0 Text7 Posto de Coleta: Black Expression Transparent 0,2.8,20,0.8 Titulo Arial,18,Bold Center 0,0,0,0 Text1 {ReportDescription} Black SystemVariables Transparent 0,4.4,1.6,0.4 Arial,10,Bold e0b58f8237b61f3005669b0397a5e7f7 0,0,0,0 Text8 Período : Black Expression Transparent 3.8,4.4,0.4,0.4 Arial,10 c5a152f071bad0ad1b179b04a37615db 0,0,0,0 Text16 à Black Expression Transparent 4.4,4.4,1.8,0.4 Arial,10 679849df2338b9f1c46d9b04f0d5e17f 0,0,0,0 Text17 {dtFinal} Black Expression Transparent 3,3.8,16.2,0.4 Arial,10 1dc2272ca26a93a9a8be9b0712d12eb0 0,0,0,0 Text20 {nomePosto} Black Expression Transparent 1.8,4.4,1.8,0.4 Arial,10 a2e80b2f4cbad322d0839ba561b6e20c 0,0,0,0 Text15 {dtInicial} Black Expression Transparent 0,5,3.2,0.4 Arial,10,Bold 01c5063201d190bed57efc3bc02a2cc8 0,0,0,0 Text9 Id dos Convênio(s): Black Expression Transparent 3.4,5,16.2,0.4 Arial,10 5d8584feb7ad5aa194d6fc3c20cef0a6 0,0,0,0 Text10 {exFiltro} Black Expression 1.2,3.6,0,0.0254 Black Black HorizontalLinePrimitive2 Black PagerHeaderBand1 Top;Black;1;Solid;False;4;Black Transparent 0,27.9,20,0.8 Transparent 1.2,0.3,1.2,0.6 Arial,10 Right 0,0,0,0 Text11 {PageNumber} Black Transparent 0,0.3,1.4,0.6 Arial,10 Right 0,0,0,0 Text12 Página: Black Expression Transparent 2.6,0.3,0.6,0.6 Arial,10 Center 0,0,0,0 Text14 de Black Expression Transparent 3.4,0.3,1.6,0.6 Arial,10 0,0,0,0 Text13 {TotalPageCount} Black SystemVariables PageFooterBand1 Transparent 0,7.4,20,0 Transparent 5.2,0,5.4,0 Arial,10 0,0,0,0 Text3 {dsDadosExames.valor_exame} Black DataColumn dsRelacao dsDadosExames DataBand3 [255:255:255] True 0,8.2,20,1.4 Transparent 2.8,0.2,1.8,0.6 Arial,9 0,0,0,0 Text4 {dsDadosAtendimento.id} Black Transparent 0,0.2,2.8,0.6 Arial,9,Bold 0,0,0,0 Text5 ID Atendimento: Black Expression Transparent 0,1,20,0.4 SubReport1 1f6c7eac2e33e385002e6a5b7e12cd32 Transparent 4.6,0.2,5,0.6 Arial,9,Bold 68832c382230580e71f76a6db555cbbc 0,0,0,0 Text18 Data de Cadastro do Atendimento: Black Expression Transparent 9.6,0.2,2.4,0.6 Arial,9 16ee01a1b6980e5b95a76a6e0ee5885b 0,0,0,0 Text29 {dsDadosAtendimento.data_cadastro} Black DataColumn Transparent 12,0.2,1.6,0.6 Arial,9,Bold 9d4f060bb8200f00ade56a6e7dad6662 0,0,0,0 Text30 Paciente: Black Expression Transparent 13.6,0.2,6.4,0.6 Arial,9 0fb05830cd5ba22df8b06a6ebeb3e668 0,0,0,0 Text31 {dsDadosAtendimento.paciente} Black DataColumn 0,0,0,0 StartPointPrimitive1 0897fcdde2e3a0b12e838bf95d1869b6 20,0.4,0,0 EndPointPrimitive1 0897fcdde2e3a0b12e838bf95d1869b6 dsDadosAtendimento False DataBand1 All;Black;1;Solid;False;4;Black Transparent 0,10.4,20,0.4 All;Black;1;Solid;False;4;Black AliceBlue 0,0,16.8,0.4 Cabeçalho Arial,8,Bold 150ee634f02fbaaeff2e6a8ec93f8799 0,0,0,0 Text34 Total Geral: Black Expression All;Black;1;Solid;False;4;Black AliceBlue 16.8,0,3.2,0.4 Cabeçalho Arial,8,Bold d22a738417221a64f86a6a8f42b4f722 Right 0,0,0,0 Text35 {Sum(ReportSummaryBand2, Text33)} Black , . 1 False Expression ReportSummaryBand1 9b0f01db5521b9448f152e93a5589f78 True False 0.5,0.5,0.5,0.5 Page1 29.7 21 A4 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent All;Black;1;Solid;False;4;Black AliceBlue 0,0.4,20,0.4 All;Black;1;Solid;False;4;Black AliceBlue 0,0,3.6,0.4 Cabeçalho Arial,8,Bold 0,0,0,0 Text21 Nome do Convênio: Black Expression All;Black;1;Solid;False;4;Black AliceBlue 3.6,0,6.6,0.4 Cabeçalho Arial,8,Bold 48ed9db94beb070af90b6a68520d5c1d 0,0,0,0 Text23 Nome do Exame: Black Expression All;Black;1;Solid;False;4;Black AliceBlue 10.2,0,4.2,0.4 Cabeçalho Arial,8,Bold cb9e931c9d516fa989ad6a6ac172793f 0,0,0,0 Text26 Data de Assinatura do Laudo: Black Expression All;Black;1;Solid;False;4;Black AliceBlue 14.4,0,2.4,0.4 Cabeçalho Arial,8,Bold 6cba8b605825d646e1246a6b7195b97d 0,0,0,0 Text27 Código: Black Expression All;Black;1;Solid;False;4;Black AliceBlue 16.8,0,3.2,0.4 Cabeçalho Arial,8,Bold 6a959ddf19c26a2b05bc6a6ba7b544c8 0,0,0,0 Text28 Valor: Black Expression HeaderBand1 Transparent 0,1.6,20,0.4 Transparent 0,0,3.6,0.4 Arial,8 0,0,0,0 Text19 {dsDadosExames.nome_convenio} Black Transparent 3.6,0,6.6,0.4 Arial,8 0,0,0,0 Text6 {dsDadosExames.nome_exame} Black Transparent 10.2,0,4.2,0.4 Arial,8 931933062242250dbe4e6a69167196c5 0,0,0,0 Text22 {dsDadosExames.data_assinatura} Black DataColumn Transparent 14.4,0,2.4,0.4 Arial,8 0f83eb865b1b3ad708486a6937a54f1f Right 0,0,0,0 Text24 {dsDadosExames.codigo_exame} Black DataColumn Transparent 16.8,0,3.2,0.4 Arial,8 19711f7f90968ee310c16a69573724bb Right 0,0,0,0 Text25 {dsDadosExames.valor_exame} Black , . 1 False DataColumn dsRelacao dsDadosExames Corpo 2 DataBand2 Corpo 1 Transparent 0,2.8,20,0.4 All;Black;1;Solid;False;4;Black AliceBlue 0,0,16.8,0.4 Cabeçalho Arial,8,Bold dd191e0ac7d629f0260c6a7d446ec9d3 0,0,0,0 Text32 Total de valores: Black Expression All;Black;1;Solid;False;4;Black AliceBlue 16.8,0,3.2,0.4 Cabeçalho Arial,8,Bold 7eaf5d3c5328ccb1d2716a7de00aeea0 Right 0,0,0,0 Text33 {Sum(DataBand2, dsDadosExames.valor_exame)} Black , . 1 False Expression ReportSummaryBand2 1f6c7eac2e33e385002e6a5b7e12cd32 1,1,1,1 Page_SubReport1 29.7 22 Arial,100 [50:0:0:0] AB SISTEMAS LTDA 09/03/2015 08:49:39 AM 05/07/2015 10:32:17 AM Relatório de Exames Listagem Completa C:\projetos\pclab_web\pclab\report_fx_php\quickstart\reports\ReportListagemCompleta.mrt f1d39959e5e60646a470930a708fa19a ReportExameListagemCompleta Centimeters 2015.1.2 True CSharp Transparent Arial,18,Bold Titulo Black All;Black;1;Solid;False;4;Black AliceBlue Arial,8,Bold Cabeçalho Black Center EmptyBrush Arial,8 Corpo 1 Black AliceBlue Arial,8 Corpo 2 Black