Gestor 48iD62cLg91HEIQAThRtm9UgmctmdjFV4lqxgerop5fVEGkCQ22iwfFwCQjkKOu//yC1CUZZ0plvSWX09PSoasPI0cJiV7oJa3xF5Oq0bnLUGPWOxQ== 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 valor_nota,System.Decimal ipi,System.Decimal icms,System.Decimal icms_st,System.Decimal pis,System.Decimal cofins,System.Decimal 30 False dados Gestor select SUM(valor_nota) as valor_nota, SUM(IPI) as ipi, SUM(valor_icms) as icms, SUM(valor_icms_st) as icms_st, SUM(pis) as pis, SUM(cofins) as cofins from nota_fiscal where tipo = '1 - Saida' and status = 'Enviada' and DATE_FORMAT(CAST(data_emissao 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') ,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 0,0.4,19,4.4 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 RESUMO TRIBUTÁRIO 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 0,0,2.2,2.2 config.imagem_logo 4c2d6b0c76e04a869266abd979183a20 imgLogo True Transparent 0,3,1.4,0.6 Tahoma,8.25,Bold,Point,False,0 a3d652b2a4424de8bdf396547c4df7b7 Right 0,0,0,0 Text44 Período: Black Expression Center Transparent 13.6,0,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 15.8,0.4,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 f5777b5814fd4ba3ad34e073c29fca76 Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 1.4,3,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 012bc62092f94daa89dce5cd49f62027 Right 0,0,0,0 Text18 {Data.FromDate.Date} Black Expression Center Transparent 3.6,3,0.4,0.6 Tahoma,8.25,Bold,Point,False,0 34d07445016a491488d9d09460cd21a1 Center 0,0,0,0 Text19 a Black Expression Center Transparent 4,3,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 6ca9b698cfee43d0b2f8e21b2dee25be 0,0,0,0 Text51 {Data.ToDate.Date} Black Expression Center Transparent 0,3.8,3.6,0.6 Tahoma,8.25,Bold,Point,False,0 b6f5186f1f0c4affb97b81e56e2f0cac Center 0,0,0,0 Text5 NOTAS FISCAIS Black Expression Center Transparent 3.6,3.8,4.2,0.6 Tahoma,8.25,Bold,Point,False,0 7fca994fbda44ba68607bb7ee8ff299c Center 0,0,0,0 Text8 ICMS Black Expression Center Transparent 12.2,3.8,3.6,0.6 Tahoma,8.25,Bold,Point,False,0 d00faa8d12b84fea9445cec8eec3ac60 Center 0,0,0,0 Text10 PIS Black Expression Center Transparent 15.8,3.8,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 96bf658f728b43e0bfad5f93e65541aa Center 0,0,0,0 Text11 COFINS Black Expression Center Transparent 7.8,3.8,4.4,0.6 Tahoma,8.25,Bold,Point,False,0 525a12e6c5f84808956f0e4e263729be Center 0,0,0,0 Text6 FUNRURAL Black Expression Center ReportTitleBand1 Transparent 0,5.6,19,0.4 Transparent 0,0,3.6,0.4 Tahoma,8.25,Regular,Point,False,0 823f0e539bf34e6e9cb7e81069b3fee9 Center 0,0,0,0 Text7 {dados.valor_nota} Black , . 9 2 R$ DataColumn Center Transparent 3.6,0,4.2,0.4 Tahoma,8.25,Regular,Point,False,0 57a907fa596d480bb51e64fad615d7c2 Center 0,0,0,0 Text13 {dados.icms} Black , . 9 2 R$ DataColumn Center Transparent 12.2,0,3.6,0.4 Tahoma,8.25,Regular,Point,False,0 dfc5b72228ab475da56aa21a36bcdb6b Center 0,0,0,0 Text16 {dados.pis} Black , . 9 2 R$ DataColumn Center Transparent 15.8,0,3.2,0.4 Tahoma,8.25,Regular,Point,False,0 29798e2c291d45b4907ab81affbc3c09 Center 0,0,0,0 Text17 {dados.cofins} Black , . 9 2 R$ DataColumn Center Transparent 7.8,0,4.4,0.4 Tahoma,8.25,Regular,Point,False,0 ba8bbb49e71b4754811a49e58e5e6b6e Center 0,0,0,0 Text9 R$ 0,00 Black , . 9 2 R$ Expression Center 0,0.4,18.6,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 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 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 10/8/2018 9:51:25 AM 9/25/2015 9:37:43 PM ea666084119a46a0a55d693c67821eb3 Report Centimeters 2015.1.0 CSharp