Gestor 48jNAk1PQ6jifu3s6Xglp9Vw9e/VSqIdaVqxwGQlYxPHeOFMT0vTyGtDbYXqAHdn39ZzLNl2eglvE7mt4oTrRpDeZYnbS/Md/WcpbHk9K3/0GPcJZ1wxDUUVpWhKzKc/wizLTsNU Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String razao_social,System.String cidade,System.String ie_rg,System.String imagem_logo,System.Byte[] 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg, c.imagem_logo from configuracao c left join cidade on cidade.id = c.cidade_id dados id,System.Int32 situacao,System.String data_cadastro,System.DateTime data_vencimento,System.DateTime comp,System.String agencia,System.String conta,System.String numero,System.String valor,System.Decimal titular,System.String tipo_pessoa_titular,System.String cpf_cnpj,System.String codigo_cmc7,System.String cliente,System.String banco,System.String 30 False dados Gestor select c.id, c.situacao, c.data_cadastro, c.data_vencimento, c.comp, c.agencia, c.conta, c.numero, c.valor, c.titular, c.tipo_pessoa_titular, c.cpf_cnpj, c.codigo_cmc7, cor.razao_social as cliente, b.descricao as banco From cheque c left join correntista cor on cor.id = c.cliente_id left join banco b on b.id = c.banco_id where DATE_FORMAT(CAST(c.data_vencimento as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') order by c.data_vencimento ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False ,produto_id,produto_id,System.String,_x0030_,False,False ,grupo_id,grupo_id,System.String,_x0030_,False,False ,subgrupo_id,subgrupo_id,System.String,_x0030_,False,False ,familia_id,familia_id,System.String,_x0030_,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,agrupar_produtos,agrupar_produtos,System.String,,False,False ,tipo_mercadoria,tipo_mercadoria,System.String,,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False ,agrupar_por,agrupar_por,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_8_x005F_x002F_2018_x005F_x0020_11:26:13_x005F_x0020_AM_x002C__x005F_x0038__x005F_x002F_8_x005F_x002F_2018_x005F_x0020_11:26:13_x005F_x0020_AM,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 22.4,0.6,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 e765e1718f9b42739e82d794b7030864 Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 24.6,1,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 f5777b5814fd4ba3ad34e073c29fca76 Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0.4,19,4.2 Transparent 0,3.6,1.2,0.6 Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 Código Black Expression Center Transparent 1.2,3.6,2,0.6 Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f Center 0,0,0,0 Text6 Situação Black Expression Center Transparent 16.4,3.6,2.6,0.6 Tahoma,8.25,Bold,Point,False,0 1885cf49561e4aabb12f83214133b841 Right 0,0,0,0 Text10 Valor Black Expression Center GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 781d2eafa39f4cfd8624172f344d8295 Center 0,0,0,0 Text1 CHEQUES Black Expression 300f366621684f32953b76a2d6198877 Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 d087582087324b43b26b933783e54715 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 bb9274ce219d404b9b7c76e7c06192c3 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 08f13c99801d43d8a8d329504e224755 Right 0,0,0,0 Text18 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 6fb81d3b212e44629b8a45ea3312aead Right 0,0,0,0 Text19 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4c2d6b0c76e04a869266abd979183a20 imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a3d652b2a4424de8bdf396547c4df7b7 0,0,0,0 Text44 {descricao_filtros} Black Expression Center Transparent 13.8,3.6,2.6,0.6 Tahoma,8.25,Bold,Point,False,0 0ac0cf4b438e42e2a01d80e7b7f4dfdf Center 0,0,0,0 Text9 Vencimento Black Expression Center Transparent 5.2,3.6,5.2,0.6 Tahoma,8.25,Bold,Point,False,0 fa92d6b2f57541309271253568e069a6 0,0,0,0 Text17 Titular Black Expression Center Transparent 10.4,3.6,3.4,0.6 Tahoma,8.25,Bold,Point,False,0 5e7f4c2f91fa4bdaaf494c96ae9e0639 Center 0,0,0,0 Text22 Banco Black Expression Center Transparent 3.2,3.6,2,0.6 Tahoma,8.25,Bold,Point,False,0 a557c8c796f04390a3d1f36401623b44 Center 0,0,0,0 Text24 Número Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.4 Transparent 0,0,1.2,0.4 Tahoma,8.25,Regular,Point,False,0 823f0e539bf34e6e9cb7e81069b3fee9 0,0,0,0 Text7 {dados.id} Black Expression Center Transparent 1.2,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 db8253923816400da5eb4ac8cd73fb4b Center 0,0,0,0 Text8 {dados.situacao} Black Expression Center Transparent 16.4,0,2.6,0.4 Tahoma,8.25,Regular,Point,False,0 e52c597148f9466f868f815d9acf72f2 Right 0,0,0,0 Text12 {dados.valor} Black , . 1 False Expression Center Transparent 13.8,0,2.6,0.4 Tahoma,8.25,Regular,Point,False,0 87c402a41ac0495f9c3130e08df51483 Center 0,0,0,0 Text11 {dados.data_vencimento} Black Expression Center Transparent 5.2,0,5.2,0.4 Tahoma,8.25,Regular,Point,False,0 b2f5d539e24e4124a18c78398e6404c2 0,0,0,0 Text16 {dados.titular} Black DataColumn Center Transparent 10.4,0,3.4,0.4 Tahoma,8.25,Regular,Point,False,0 c688255bc5e8470f84a8f66b2be4ae46 Center 0,0,0,0 Text23 {dados.banco} Black DataColumn Center Transparent 3.2,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 73d65c0068a94c208feefa38cbb91d47 Center 0,0,0,0 Text25 {dados.numero} Black DataColumn Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC data Transparent 0,6.6,19,0.8 Transparent 14.4,0.2,2,0.4 Tahoma,8.25,Regular,Point,False,0 fe836a0d4c6740aeb70ff8b11921ea01 Right 0,0,0,0 Text13 Valor total: Black Expression Center Transparent 16.4,0.2,2.6,0.4 Tahoma,8.25,Bold,Point,False,0 949cfc4fa2d64f75bf386fc03d9051d1 Right 0,0,0,0 Text15 {Sum(DataBand1,dados.valor)} Black , . 9 2 R$ Totals Center ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 32,56,96,20 Microsoft Sans Serif,8 Black Short a7c7a4bcc2eb4955ab6cde4a0ba5af86 32, 56 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtInicial 96, 20 2/6/2018 4:30:02 PM Window 168,56,96,20 Microsoft Sans Serif,8 Black Short 2087dd10db564b3dabe2b8659e1572a1 168, 56 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtFinal 96, 20 2/6/2018 4:30:08 PM Control 32,32,96,24 Microsoft Sans Serif,8 Black 111fc3783c724ebcbcf857beb5908fba 32, 32 LabelControl1 96, 24 Data Inicial Control 168,32,96,24 Microsoft Sans Serif,8 Black de88df2b281a471aa8f07ab4a1b5c075 168, 32 LabelControl2 96, 24 Data Final 32,104,96,24 Cancel Microsoft Sans Serif,8 Black 6c3cf1854d00406fad372515b17e3607 32, 104 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; 168,104,96,24 OK Microsoft Sans Serif,8 Black 97f51dccb0ac45afaa711d0ba0f9c951 168, 104 btnGerar 96, 24 Gerar Microsoft Sans Serif,8 5d4d0cf488d64308b56087b76ba501c7 0, 0 periodo 304, 192 Informe o período do vencimento System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 8/1/2019 9:19:06 AM 9/25/2015 9:37:43 PM 504eea2412454b239d02201601605d24 Report Centimeters 2015.1.0 CSharp