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 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 OUTRAS,System.Decimal 30 False dados Gestor select nf.id, nf.numero, nfi.aliquota_icms, 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(IF(RIGHT(nfi.cst, 2) = '40', nfi.valor_total, 0)) as ISENTAS, IF(RIGHT(nfi.cst, 2) != '40' && aliquota_icms = 0, SUM(nfi.valor_total), IF(nfi.base_icms > 0 && aliquota_icms>0, SUM(nfi.valor_total) - SUM(nfi.base_icms), 0)) as OUTRAS, nf.serie_nfe, IF(nf.modelo is null, "55", nf.modelo) as modelo, nf.data_emissao, nf.data_ent_sai, nf.destinatario_nome, nf.destinatario_uf, nfi.cfop 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.aliquota_icms, nf.numero 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,18.2,27.7,0.8 Transparent 24,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,27.7,3.8 GlassBrush,Gainsboro,True,0.2 0,2.2,27.6,0.8 Transparent 0.2,0.1,27,0.6 Tahoma,14.25,Bold,Point,False,0 781d2eafa39f4cfd8624172f344d8295 Center 0,0,0,0 Text1 DADOS FISCAIS POR CFOP - ENTRADAS 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 22.2,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 24.4,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,5,27.7,0.6 Transparent 0,0,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 Data Black Expression Center Transparent 1.8,0,2,0.6 Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f 0,0,0,0 Text6 Núm. Black Expression Center Transparent 12.8,0,1.2,0.6 Tahoma,8.25,Bold,Point,False,0 1885cf49561e4aabb12f83214133b841 Right 0,0,0,0 Text10 CFOP Black Expression Center Transparent 5.8,0,7,0.6 Tahoma,8.25,Bold,Point,False,0 0ac0cf4b438e42e2a01d80e7b7f4dfdf 0,0,0,0 Text9 Destinatário/Emitente Black Expression Center Transparent 14,0,1,0.6 Tahoma,8.25,Bold,Point,False,0 de97fa4781c146b690ef97da5f48062a Right 0,0,0,0 Text16 UF Black Expression Center Transparent 15,0,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 0e7ccfe8cc0b4dd3803ca70f4e9d2df2 Right 0,0,0,0 Text17 Valor Black Expression Center Transparent 17.2,0,2,0.6 Tahoma,8.25,Bold,Point,False,0 e74f4d5f68174e738bd1566bde892605 Right 0,0,0,0 Text22 Base Cálc. Black Expression Center Transparent 20.6,0,1.6,0.6 Tahoma,8.25,Bold,Point,False,0 67d9ba5440b04b2e8d825566a57871b8 Right 0,0,0,0 Text23 ICMS Black Expression Center Transparent 22.2,0,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 d2ae10d0b8f64bbb85a0a97654f365c8 Right 0,0,0,0 Text24 ICMS ST Black Expression Center Transparent 3.8,0,0.8,0.6 Tahoma,8.25,Bold,Point,False,0 c83380825e744a989b99d4bb4cd955a8 0,0,0,0 Text52 Série Black Expression Center Transparent 4.6,0,1.2,0.6 Tahoma,8.25,Bold,Point,False,0 5862d8d23c104a82a432c308e84734a6 Right 0,0,0,0 Text54 Modelo Black Expression Center Transparent 24,0,2,0.6 Tahoma,8.25,Bold,Point,False,0 8a30b5654a6c4c56a56803dfdf348622 Right 0,0,0,0 Text58 ISENTA Black Expression Center Transparent 26,0,1.6,0.6 Tahoma,8.25,Bold,Point,False,0 257903dafcd34c89b31c2b0f994f2463 Right 0,0,0,0 Text61 OUTRAS Black Expression Center Transparent 19.2,0,1.4,0.6 Tahoma,8.25,Bold,Point,False,0 4e110e30667e4a44a94a5aa06752db60 Right 0,0,0,0 Text25 Alíquota Black Expression Center {dados.numero} GroupHeaderBand1 None Transparent 0,6.4,27.7,0.4 Transparent 0,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 823f0e539bf34e6e9cb7e81069b3fee9 0,0,0,0 Text7 {dados.data_ent_sai} Black Expression Center Transparent 1.8,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 db8253923816400da5eb4ac8cd73fb4b 0,0,0,0 Text8 {dados.numero} Black Expression Center Transparent 5.8,0,7,0.4 Tahoma,8.25,Regular,Point,False,0 e9317893e27840ea9b99275038026714 0,0,0,0 Text11 {dados.destinatario_nome} Black DataColumn Center Transparent 12.8,0,1.2,0.4 Tahoma,8.25,Regular,Point,False,0 679beaa6363541f9a86e69a935c77866 Right 0,0,0,0 Text12 {dados.cfop} Black DataColumn Center Transparent 14,0,1,0.4 Tahoma,8.25,Regular,Point,False,0 c26ed60e6ff94888a322e49740d3a9ad Right 0,0,0,0 Text28 {dados.destinatario_uf} Black DataColumn Center Transparent 15,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 00b731607dca480d88a3d1b0d8066af2 Right 0,0,0,0 Text29 {dados.valor_total} Black , . 1 DataColumn Center Transparent 17.2,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 ad401051c3d34b80a1a294701dec620e Right 0,0,0,0 Text30 {dados.base_icms} Black , . 1 DataColumn Center Transparent 20.6,0,1.6,0.4 Tahoma,8.25,Regular,Point,False,0 ebb41a953aa64ff1b8fc6ac46d1a9c2e Right 0,0,0,0 Text31 {dados.valor_icms} Black , . 1 DataColumn Center Transparent 22.2,0,1.8,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 3.8,0,0.8,0.4 Tahoma,8.25,Regular,Point,False,0 0ce6d918b7b74da8aa1772b47749a922 0,0,0,0 Text53 {dados.serie_nfe} Black DataColumn Center Transparent 4.6,0,1.2,0.4 Tahoma,8.25,Regular,Point,False,0 5c4de7439f5042b1901855ddca7441ec 0,0,0,0 Text55 {dados.modelo} Black DataColumn Center Transparent 19.2,0,1.4,0.4 Tahoma,8.25,Regular,Point,False,0 06d4f2a260644c73a8424076dd87df11 Right 0,0,0,0 Text57 {dados.aliquota_icms} Black , . 1 DataColumn Center Transparent 24,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 1b390f3a3a6b451fa5f47ec747117111 Right 0,0,0,0 Text59 {dados.ISENTAS} Black , . 1 DataColumn Center Transparent 26,0,1.6,0.4 Tahoma,8.25,Regular,Point,False,0 73eaf40f7b4049599e945c998b60a7c4 Right 0,0,0,0 Text60 {dados.OUTRAS} Black , . 1 Expression Center 0,0.4,27.6,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC destinatario_nome Transparent 0,7.6,27.7,0.8 Transparent 13,0.2,2,0.4 Tahoma,8.25,Bold,Point,False,0 fe836a0d4c6740aeb70ff8b11921ea01 Right 0,0,0,0 Text13 Totais: Black Expression Center Transparent 15,0.2,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 2438af700ca54ceba36ba22d43f62be3 Right 0,0,0,0 Text15 {Sum(DataBand1,dados.valor_total)} Black , . 1 Totals Center Transparent 17.2,0.2,2,0.4 Tahoma,8.25,Regular,Point,False,0 21262bdbe7914d83ba964ce12b783585 Right 0,0,0,0 Text36 {Sum(DataBand1,dados.base_icms)} Black , . 1 Totals Center Transparent 20.6,0.2,1.6,0.4 Tahoma,8.25,Regular,Point,False,0 3599974077dd45539aeafc61382ff739 Right 0,0,0,0 Text37 {Sum(DataBand1,dados.valor_icms)} Black , . 1 Totals Center Transparent 22.2,0.2,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 2642d1a02ba24d0ea8e9589807f32a1f Right 0,0,0,0 Text38 {Sum(DataBand1,dados.valor_icms_st)} Black , . 1 Totals Center Transparent 24,0.2,2,0.4 Tahoma,8.25,Regular,Point,False,0 e621f383ddfb46ba85d4faa44ce95440 Right 0,0,0,0 Text62 {Sum(DataBand1,dados.ISENTAS)} Black , . 1 Totals Center Transparent 26,0.2,1.6,0.4 Tahoma,8.25,Regular,Point,False,0 beb862e27eff44288abcabd0d8e2f050 Right 0,0,0,0 Text63 {Sum(DataBand1,dados.OUTRAS)} Black , . 1 Totals Center GroupFooterBand1 Transparent 0,9.2,27.7,0.8 Transparent 12,0.2,3,0.4 Tahoma,8.25,Bold,Point,False,0 be319b991da34c4abaf3919ef6702ec9 Right 0,0,0,0 Text42 Total Geral: Black Expression Center Transparent 15,0.2,2.2,0.4 Tahoma,8 389b7d5c44f344ff91b319bdfc1bc504 Right 0,0,0,0 Text43 {Sum(DataBand1,dados.valor_total)} Black , . 1 Totals Center Transparent 17.2,0.2,2,0.4 Tahoma,8 2853cdbbcb70447f9efc27011f57deb4 Right 0,0,0,0 Text45 {Sum(DataBand1,dados.base_icms)} Black , . 1 Totals Center Transparent 20.6,0.2,1.6,0.4 Tahoma,8 0e00723d73ad45878b5ec306e5c689e0 Right 0,0,0,0 Text46 {Sum(DataBand1,dados.valor_icms)} Black , . 1 Totals Center Transparent 22.2,0.2,1.8,0.4 Tahoma,8 93bc0ebb943f4cd1b95eca16df2fadaa Right 0,0,0,0 Text47 {Sum(DataBand1,dados.valor_icms_st)} Black , . 1 Totals Center Transparent 24,0.2,2,0.4 Tahoma,8 ac52a1b8c57d48d89e0c058ee345df96 Right 0,0,0,0 Text64 {Sum(DataBand1,dados.ISENTAS)} Black , . 1 Totals Center Transparent 26,0.2,1.6,0.4 Tahoma,8 2c055a0056a74d41bb6bfc09911f7203 Right 0,0,0,0 Text65 {Sum(DataBand1,dados.OUTRAS)} Black , . 1 Totals Center ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 Landscape 21 29.7 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:07:55 AM 9/25/2015 9:37:43 PM c949f515519a40fdbd6e9246792fec6a Report Centimeters 2015.1.0 CSharp