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 id,System.Int32 numero,System.String aliquota_icms,System.Decimal ISENTAS,System.Decimal OUTRAS,System.Decimal serie_nfe,System.String modelo,System.String data_emissao,System.DateTime data_ent_sai,System.DateTime destinatario_nome,System.String destinatario_uf,System.String cfop,System.String valor_total,System.Decimal base_icms,System.Decimal valor_icms,System.Decimal valor_icms_st,System.Decimal valor_ipi,System.Decimal valor_pis,System.Decimal valor_cofins,System.Decimal 30 False dados Gestor select nfi.cfop, SUM(IF(RIGHT(nfi.cst, 2) = '40', nfi.valor_total, 0)) as ISENTAS, SUM(IF(RIGHT(nfi.cst, 2) != '40' && nfi.aliquota_icms = 0, nfi.valor_total, IF(nfi.base_icms > 0 && nfi.aliquota_icms > 0, nfi.valor_total-nfi.base_icms, 0))) as OUTRAS, SUM(nfi.valor_total) as valor_total, SUM(nfi.base_icms) as base_icms, SUM(nfi.valor_icms) as valor_icms, SUM(nfi.valor_icms_st) as valor_icms_st, SUM(nfi.valor_ipi) as valor_ipi, SUM(nfi.valor_pis) as valor_pis, SUM(nfi.valor_cofins) as valor_cofins from nota_fiscal nf left join nota_fiscal_item nfi on nfi.nota_fiscal_id = nf.id where tipo = '0 - Entrada' and DATE_FORMAT(CAST(data_ent_sai 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') group by nfi.cfop order by nf.destinatario_nome saidas cfop,System.String ISENTAS,System.Decimal OUTRAS,System.Decimal valor_total,System.Decimal base_icms,System.Decimal valor_icms,System.Decimal valor_icms_st,System.Decimal valor_ipi,System.Decimal valor_pis,System.Decimal valor_cofins,System.Decimal 30 False saidas Gestor select nfi.cfop, SUM(IF(RIGHT(nfi.cst, 2) = '40', nfi.valor_total, 0)) as ISENTAS, SUM(IF(RIGHT(nfi.cst, 2) != '40' && nfi.aliquota_icms = 0, nfi.valor_total, IF(nfi.base_icms > 0 && nfi.aliquota_icms > 0, nfi.valor_total-nfi.base_icms, 0))) as OUTRAS, SUM(nfi.valor_total) as valor_total, SUM(nfi.base_icms) as base_icms, SUM(nfi.valor_icms) as valor_icms, SUM(nfi.valor_icms_st) as valor_icms_st, SUM(nfi.valor_ipi) as valor_ipi, SUM(nfi.valor_pis) as valor_pis, SUM(nfi.valor_cofins) as valor_cofins from nota_fiscal nf left join nota_fiscal_item nfi on nfi.nota_fiscal_id = nf.id 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') group by nfi.cfop order by nf.destinatario_nome ,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,3.6 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 DADOS FISCAIS POR CFOP - ENTRADAS E SAÍDAS 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.2,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.6,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 ReportTitleBand1 Transparent 0,4.8,19,1.2 Transparent 0,0.6,2,0.6 Tahoma,8.25,Bold,Point,False,0 1885cf49561e4aabb12f83214133b841 0,0,0,0 Text10 CFOP Black Expression Center Transparent 2,0.6,3,0.6 Tahoma,8.25,Bold,Point,False,0 0e7ccfe8cc0b4dd3803ca70f4e9d2df2 Right 0,0,0,0 Text17 Valor Black Expression Center Transparent 5,0.6,3.4,0.6 Tahoma,8.25,Bold,Point,False,0 e74f4d5f68174e738bd1566bde892605 Right 0,0,0,0 Text22 Base Cálc. Black Expression Center Transparent 8.4,0.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 67d9ba5440b04b2e8d825566a57871b8 Right 0,0,0,0 Text23 ICMS Black Expression Center Transparent 11.2,0.6,2.6,0.6 Tahoma,8.25,Bold,Point,False,0 d2ae10d0b8f64bbb85a0a97654f365c8 Right 0,0,0,0 Text24 ICMS ST Black Expression Center Transparent 13.8,0.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 8a30b5654a6c4c56a56803dfdf348622 Right 0,0,0,0 Text58 ISENTA Black Expression Center Transparent 16.6,0.6,2.4,0.6 Tahoma,8.25,Bold,Point,False,0 257903dafcd34c89b31c2b0f994f2463 Right 0,0,0,0 Text61 OUTRAS Black Expression Center Transparent 0,0,2,0.6 Tahoma,8.25,Bold,Point,False,0 34c315bf390446e99cae32de325ab772 0,0,0,0 Text5 ENTRADAS Black Expression Center HeaderBand1 Transparent 0,6.8,19,0.4 Transparent 0,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 679beaa6363541f9a86e69a935c77866 0,0,0,0 Text12 {dados.cfop} Black DataColumn Center Transparent 2,0,3,0.4 Tahoma,8.25,Regular,Point,False,0 00b731607dca480d88a3d1b0d8066af2 Right 0,0,0,0 Text29 {dados.valor_total} Black , . 1 DataColumn Center Transparent 5,0,3.4,0.4 Tahoma,8.25,Regular,Point,False,0 ad401051c3d34b80a1a294701dec620e Right 0,0,0,0 Text30 {dados.base_icms} Black , . 1 DataColumn Center Transparent 8.4,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 ebb41a953aa64ff1b8fc6ac46d1a9c2e Right 0,0,0,0 Text31 {dados.valor_icms} Black , . 1 DataColumn Center Transparent 11.2,0,2.6,0.4 Tahoma,8.25,Regular,Point,False,0 4e3dacd15e5b4dd3bb3a14ce668b1886 Right 0,0,0,0 Text32 {dados.valor_icms_st} Black , . 1 DataColumn Center Transparent 13.8,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 1b390f3a3a6b451fa5f47ec747117111 Right 0,0,0,0 Text59 {dados.ISENTAS} Black , . 1 DataColumn Center Transparent 16.6,0,2.4,0.4 Tahoma,8.25,Regular,Point,False,0 73eaf40f7b4049599e945c998b60a7c4 Right 0,0,0,0 Text60 {dados.OUTRAS} Black , . 1 DataColumn Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC destinatario_nome Transparent 0,8,19,0.8 Transparent 0,0.4,2,0.4 Tahoma,8.25,Bold,Point,False,0 be319b991da34c4abaf3919ef6702ec9 Right 0,0,0,0 Text42 Total Geral: Black Expression Center Transparent 2,0.4,3,0.4 Tahoma,8 389b7d5c44f344ff91b319bdfc1bc504 Right 0,0,0,0 Text43 {Sum(DataBand1,dados.valor_total)} Black , . 1 Totals Center Transparent 5,0.4,3.4,0.4 Tahoma,8 2853cdbbcb70447f9efc27011f57deb4 Right 0,0,0,0 Text45 {Sum(DataBand1,dados.base_icms)} Black , . 1 Totals Center Transparent 8.4,0.4,2.8,0.4 Tahoma,8 0e00723d73ad45878b5ec306e5c689e0 Right 0,0,0,0 Text46 {Sum(DataBand1,dados.valor_icms)} Black , . 1 Totals Center Transparent 11.2,0.4,2.6,0.4 Tahoma,8 93bc0ebb943f4cd1b95eca16df2fadaa Right 0,0,0,0 Text47 {Sum(DataBand1,dados.valor_icms_st)} Black , . 1 Totals Center Transparent 13.8,0.4,2.8,0.4 Tahoma,8 ac52a1b8c57d48d89e0c058ee345df96 Right 0,0,0,0 Text64 {Sum(DataBand1,dados.ISENTAS)} Black , . 1 Totals Center Transparent 16.6,0.4,2.4,0.4 Tahoma,8 2c055a0056a74d41bb6bfc09911f7203 Right 0,0,0,0 Text65 {Sum(DataBand1,dados.OUTRAS)} Black , . 1 Totals Center FooterBand1 Transparent 0,9.6,19,1.6 Transparent 0,1,2,0.6 Tahoma,8.25,Bold,Point,False,0 211d2694217c4119a8c48ff69ad5fa4c 0,0,0,0 Text6 CFOP Black Expression Center Transparent 2,1,2.6,0.6 Tahoma,8.25,Bold,Point,False,0 f5469d2c3d4447bcb1505734a88e5331 Right 0,0,0,0 Text7 Valor Black Expression Center Transparent 4.6,1,2,0.6 Tahoma,8.25,Bold,Point,False,0 98a260d25ca0440da2f92081afc07bb5 Right 0,0,0,0 Text8 Base Cálc. Black Expression Center Transparent 6.6,1,2,0.6 Tahoma,8.25,Bold,Point,False,0 7d63d275002243b9a6c2321c737cfac5 Right 0,0,0,0 Text9 ICMS Black Expression Center Transparent 8.6,1,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 24fdcbd6fd50413ab2d00d14599bb4a7 Right 0,0,0,0 Text11 ICMS ST Black Expression Center Transparent 15,1,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 57ce4d381c454fcfa34cfbf1f456aa6c Right 0,0,0,0 Text15 PIS Black Expression Center Transparent 17.2,1,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 7586da374a67471d93f9d9c6acd6893a Right 0,0,0,0 Text16 COFINS Black Expression Center Transparent 10.8,1,2,0.6 Tahoma,8.25,Bold,Point,False,0 15b6943c083f4d6e8bc6d732e2d2a3f5 Right 0,0,0,0 Text28 ISENTA Black Expression Center Transparent 12.8,1,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 6d815067c1f042ebb33893c1d760709f Right 0,0,0,0 Text36 OUTRAS Black Expression Center Transparent 0,0.4,2,0.6 Tahoma,8.25,Bold,Point,False,0 88097e19ec854c6da499ce520490ada6 0,0,0,0 Text37 SAÍDAS Black Expression Center HeaderBand2 Transparent 0,12,19,0.4 Transparent 0,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 b66553b188bc430a956b5474d58868fb 0,0,0,0 Text38 {saidas.cfop} Black DataColumn Center Transparent 2,0,2.6,0.4 Tahoma,8.25,Regular,Point,False,0 92e9365a698d44479f7c7df1ece52d60 Right 0,0,0,0 Text39 {saidas.valor_total} Black , . 1 DataColumn Center Transparent 4.6,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 056c9de4370f4ebf87ecbf92ce350f98 Right 0,0,0,0 Text40 {saidas.base_icms} Black , . 1 DataColumn Center Transparent 6.6,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 6fb9ec8561b34929adc1f0a20c9dd789 Right 0,0,0,0 Text41 {saidas.valor_icms} Black , . 1 DataColumn Center Transparent 8.6,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 fa52fbd4a7cd4209b87c8c98403ca3e1 Right 0,0,0,0 Text52 {saidas.valor_icms_st} Black , . 1 DataColumn Center Transparent 15,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 5b0dc112fdf4443e92ba4646ffc30d9c Right 0,0,0,0 Text54 {saidas.valor_pis} Black , . 1 DataColumn Center Transparent 17.2,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 4aa8d75e20f74bb3a7e5b4dd145e6e9d Right 0,0,0,0 Text55 {saidas.valor_cofins} Black , . 1 DataColumn Center Transparent 10.8,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 8b8b7023598f4d148a95ae1dd2605eec Right 0,0,0,0 Text56 {saidas.ISENTAS} Black , . 1 DataColumn Center Transparent 12.8,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 e90caf2b481544f8ae4c799546f2af77 Right 0,0,0,0 Text57 {saidas.OUTRAS} Black , . 1 DataColumn Center 0,0.4,19,0.0254 Black Black fceb5862fc2045d1b4147407cff83240 HorizontalLinePrimitive2 Black saidas DataBand2 Transparent 0,13.2,19,0.8 Transparent 0,0.4,2,0.4 Tahoma,8.25,Bold,Point,False,0 19a409d264b343429e2158e84fe72404 Right 0,0,0,0 Text62 Total Geral: Black Expression Center Transparent 2,0.4,2.6,0.4 Tahoma,8 fd8bd3277aee45d5a29b16f17c90a10b Right 0,0,0,0 Text63 {Sum(DataBand2,saidas.valor_total)} Black , . 1 Totals Center Transparent 4.6,0.4,2,0.4 Tahoma,8 7b2ba1a4277649a48bd606bb46264430 Right 0,0,0,0 Text66 {Sum(DataBand2,saidas.base_icms)} Black , . 1 Totals Center Transparent 6.6,0.4,2,0.4 Tahoma,8 f628f803ea124d759594313b56f1467a Right 0,0,0,0 Text67 {Sum(DataBand2,saidas.valor_icms)} Black , . 1 Totals Center Transparent 8.6,0.4,2.2,0.4 Tahoma,8 cb3402502b1545fdb2cc699e908ac48b Right 0,0,0,0 Text68 {Sum(DataBand2,saidas.valor_icms_st)} Black , . 1 Totals Center Transparent 15,0.4,2.2,0.4 Tahoma,8 beff378b2f0c444ba2e13bcf3954a519 Right 0,0,0,0 Text70 {Sum(DataBand2,saidas.valor_pis)} Black , . 1 Totals Center Transparent 17.2,0.4,1.8,0.4 Tahoma,8 87348ca08ed84972aea856259a9056e4 Right 0,0,0,0 Text71 {Sum(DataBand2,saidas.valor_cofins)} Black , . 1 Totals Center Transparent 10.8,0.4,2,0.4 Tahoma,8 d1c04b3238684cf7b18497b0ce2d5adc Right 0,0,0,0 Text72 {Sum(DataBand2,saidas.ISENTAS)} Black , . 1 Totals Center Transparent 12.8,0.4,2.2,0.4 Tahoma,8 674efbd1f85d4cc49f334fbedc03763d Right 0,0,0,0 Text73 {Sum(DataBand2,saidas.OUTRAS)} Black , . 1 Totals Center FooterBand2 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/9/2018 10:31:12 AM 9/25/2015 9:37:43 PM 1e3e191c3704406fad6f99d3cc97d17e Report Centimeters 2015.1.0 CSharp