object relRecibosEmitidos: TrelRecibosEmitidos Left = 0 Top = 0 BorderStyle = bsNone ClientHeight = 1133 ClientWidth = 809 Color = clBtnFace Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11 Font.Name = 'Tahoma' Font.Style = [] OldCreateOrder = False PixelsPerInch = 96 TextHeight = 13 object fr_recibosemitidos: TRLReport Left = 8 Top = 8 Width = 794 Height = 1123 DataSource = dtsqryReport Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [] AfterPrint = fr_recibosemitidosAfterPrint BeforePrint = fr_recibosemitidosBeforePrint object frbnd_header: TRLBand Left = 38 Top = 38 Width = 718 Height = 143 AutoExpand = False BandType = btHeader Borders.Sides = sdCustom Borders.DrawLeft = True Borders.DrawTop = True Borders.DrawRight = True Borders.DrawBottom = False object frpnl_logo: TRLPanel Left = 1 Top = 0 Width = 160 Height = 143 Align = faLeftOnly Borders.Sides = sdCustom Borders.DrawLeft = False Borders.DrawTop = True Borders.DrawRight = True Borders.DrawBottom = False object frdbimg_logo: TRLDBImage Left = 0 Top = 1 Width = 159 Height = 142 Align = faClient AutoSize = True Borders.Sides = sdCustom Borders.DrawLeft = False Borders.DrawTop = False Borders.DrawRight = False Borders.DrawBottom = False DataField = 'IMG_LOGO' Stretch = True end end object frlbl_titulorel: TRLLabel Left = 167 Top = 52 Width = 222 Height = 24 Caption = 'Relat'#243'rio de Recibos:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -21 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object frlbl_datas: TRLLabel Left = 167 Top = 82 Width = 78 Height = 24 Caption = 'DATAS' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -21 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end end object frbnd_columnheader: TRLBand Left = 38 Top = 181 Width = 718 Height = 16 BandType = btColumnHeader Borders.Sides = sdCustom Borders.DrawLeft = True Borders.DrawTop = True Borders.DrawRight = True Borders.DrawBottom = True object frlbl_nrrecibo: TRLLabel Left = 1 Top = 1 Width = 18 Height = 16 Align = faLeftTop Caption = 'N'#186 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object frlbl_nomerecibo: TRLLabel Left = 228 Top = 1 Width = 118 Height = 16 Align = faTopOnly Caption = 'NOME DO RECIBO' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object frlbl_cpf: TRLLabel Left = 112 Top = 1 Width = 30 Height = 16 Align = faTopOnly Caption = 'CPF' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object frlbl_vltotal: TRLLabel Left = 495 Top = 1 Width = 96 Height = 16 Align = faTopOnly Caption = 'VALOR TOTAL' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object frlbl_dtimpressao: TRLLabel Left = 596 Top = 1 Width = 121 Height = 16 Align = faRightTop Caption = 'DATA IMPRESS'#195'O' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object RLLabel1: TRLLabel Left = 397 Top = 1 Width = 44 Height = 16 Align = faTopOnly Caption = 'CAIXA' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end object RLLabel2: TRLLabel Left = 65 Top = 1 Width = 40 Height = 16 Align = faTopOnly Caption = 'CANC' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end end object frbnd_details: TRLBand Left = 38 Top = 197 Width = 718 Height = 16 Borders.Sides = sdCustom Borders.DrawLeft = True Borders.DrawTop = False Borders.DrawRight = True Borders.DrawBottom = True object frdblbl_nrrecibo: TRLDBText Left = 1 Top = 0 Width = 78 Height = 16 Align = faLeftTop DataField = 'NR_RECIBO' DataSource = dtsqryReport Text = '' end object frdblbl_nomerecibo: TRLDBText Left = 228 Top = 0 Width = 149 Height = 16 Align = faTopOnly AutoSize = False DataField = 'TX_NOME' DataSource = dtsqryReport Text = '' end object frdblbl_cpf: TRLDBText Left = 112 Top = 0 Width = 108 Height = 16 Align = faTopOnly DataField = 'TX_DOCUMENTO' DataSource = dtsqryReport Text = '' end object frdblbl_vltotal: TRLDBText Left = 492 Top = 0 Width = 99 Height = 16 Align = faTopOnly Alignment = taRightJustify DataField = 'VL_CORRIGIDO' DataSource = dtsqryReport Text = '' end object frdblbl_dtimpressao: TRLDBText Left = 604 Top = 0 Width = 106 Height = 16 Align = faTopOnly Alignment = taCenter DataField = 'DT_IMPRESSAO' DataSource = dtsqryReport Text = '' end object RLDBText1: TRLDBText Left = 397 Top = 0 Width = 91 Height = 16 Align = faTopOnly AutoSize = False DataField = 'TX_CAIXA' DataSource = dtsqryReport Text = '' end object RLDBText2: TRLDBText Left = 65 Top = 0 Width = 107 Height = 16 DataField = 'TP_CANCELADO' DataSource = dtsqryReport Text = '' end end object RLBand1: TRLBand Left = 38 Top = 213 Width = 718 Height = 16 BandType = btSummary Borders.Sides = sdCustom Borders.DrawLeft = True Borders.DrawTop = True Borders.DrawRight = True Borders.DrawBottom = True object frdbresult_sumvalor: TRLDBResult Left = 144 Top = 1 Width = 183 Height = 16 Align = faTopOnly Alignment = taRightJustify DataField = 'VL_CORRIGIDO' DataSource = dtsqryReport Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] Info = riSum ParentFont = False Text = 'Total: ' Visible = False end object frlbl_total: TRLLabel Left = 494 Top = 1 Width = 64 Height = 16 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] ParentFont = False end end object frbnd_footerrel: TRLBand Left = 38 Top = 229 Width = 718 Height = 20 BandType = btFooter object RLSystemInfo2: TRLSystemInfo Left = 503 Top = 7 Width = 49 Height = 13 Align = faBottomOnly Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'unifont' Font.Style = [] ParentFont = False Text = '' end object RLSystemInfo1: TRLSystemInfo Left = 605 Top = 7 Width = 49 Height = 13 Align = faBottomOnly Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Height = -13 Font.Name = 'unifont' Font.Style = [] Info = itHour ParentFont = False Text = '' end end end object dtsqryReport: TDataSource DataSet = qryReport Left = 728 Top = 32 end object qryReport: TZQuery Connection = dtmSystem.ZConnection SQL.Strings = ( 'select first 0' 'sys_recibos.*, ' 'case when tx_cpf = '#39#39' then tx_cnpj' 'when tx_cpf <> '#39#39' then tx_cpf' 'end as tx_documento from sys_recibos') Params = <> Left = 648 Top = 32 object qryReportNR_RECIBO: TWideStringField FieldName = 'NR_RECIBO' Required = True end object qryReportTX_NOME: TWideStringField FieldName = 'TX_NOME' Size = 255 end object qryReportTX_CPF: TWideStringField FieldName = 'TX_CPF' Size = 14 end object qryReportTX_CNPJ: TWideStringField FieldName = 'TX_CNPJ' Size = 18 end object qryReportDT_IMPRESSAO: TDateTimeField FieldName = 'DT_IMPRESSAO' end object qryReportID_USUARIO: TIntegerField FieldName = 'ID_USUARIO' end object qryReportTX_CAIXA: TStringField FieldKind = fkLookup FieldName = 'TX_CAIXA' LookupDataSet = dtmSystem.tblUsuariosConsulta LookupKeyFields = 'ID_USUARIO' LookupResultField = 'TX_NOME' KeyFields = 'ID_USUARIO' Size = 25 Lookup = True end object qryReportVL_CORRIGIDO: TFloatField FieldName = 'VL_CORRIGIDO' end object qryReportTP_CANCELADO: TWideStringField FieldName = 'TP_CANCELADO' Size = 1 end object qryReportTX_DOCUMENTO: TWideStringField FieldName = 'TX_DOCUMENTO' ReadOnly = True Size = 18 end end object fr_filterpdf: TRLPDFFilter DocumentInfo.Creator = 'FortesReport Community Edition v4.0 \251 Copyright '#169' 1999-2015 F' + 'ortes Inform'#225'tica' DisplayName = 'Documento PDF' Left = 584 Top = 32 end object dtsEmpresa: TDataSource DataSet = dtmSystem.tblEmpresa Left = 520 Top = 32 end end