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 vendedor,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 vendedor_id,System.Int32 razao_social,System.String data_emissao,System.DateTime valor_pago,System.Decimal 30 False dados Gestor select orc.id, orc.vendedor_id, cor.razao_social, orc.data_emissao, SUM(orc.valor_pago) AS valor_pago From orcamento orc left join correntista cor on cor.id = orc.vendedor_id where orc.status = 'Faturado' AND DATE_FORMAT(CAST(orc.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 vendedor_id ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False ,data_inicial,data_inicial,System.String,_x0032_016-03-01,False,False ,data_final,data_final,System.String,_x0032_016-03-31,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031_0_x005F_x002F_18_x005F_x002F_2018_x005F_x0020_3:13:14_x005F_x0020_PM_x002C__x005F_x0031_0_x005F_x002F_18_x005F_x002F_2018_x005F_x0020_3:13:14_x005F_x0020_PM,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.2 Transparent 15.2,3.6,3.8,0.6 Tahoma,8.25,Bold,Point,False,0 ac4b7201fffa419b9ffc0e7eb6a45a8e Right 0,0,0,0 Text16 Total Vendido 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 b477fa6ca8314ffa84101e90adebd93d Center 0,0,0,0 Text1 VENDAS Black Expression 5ec57d6d6fbe4b22832fe900eedd309a Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 e3190c0b3e734bae98aaceae2c9ffb0f 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 4e7cbdc300ca4665802434919c3f2389 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 bffdaccca0f24554a72a6fec6963f170 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 4bc9fbfe1a76416ca43ed1d751c7b3dc Right 0,0,0,0 Text5 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4de07384d7b7483a9f15ace801a7cd10 imgLogo True Transparent 0,3.6,15.2,0.6 Tahoma,8.25,Bold,Point,False,0 7c7db95f5a7c4550ad0cd9026aae8930 0,0,0,0 Text6 Funcionário Black Expression Center Transparent 0,3,1.4,0.6 Tahoma,8.25,Bold,Point,False,0 3921eb403ef44513b0fa756d3824800e Right 0,0,0,0 Text7 Período: Black Expression Center Transparent 1.4,3,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 28956585452c4ae9b35ec84dc035b69c 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 48914c94353143838b759dd2c39ff5ca Center 0,0,0,0 Text19 a Black Expression Center Transparent 4,3,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 0e8baf05333342309c9c0e085ea76f7d 0,0,0,0 Text51 {Data.ToDate.Date} Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.6 Transparent 15.2,0,3.8,0.6 Tahoma,8.25,Regular,Point,False,0 cf214530264f4906bf43027dac9e5104 Right 0,0,0,0 Text22 {dados.valor_pago} Black , . 9 2 R$ DataColumn Center Transparent 0,0,15.2,0.6 Tahoma,8.25,Regular,Point,False,0 f6b6eb8ac266473e8db59b30b31394f2 0,0,0,0 Text9 {dados.razao_social} Black DataColumn Center 0,0.6,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados False ,GreaterThan,_x0030_,,Numeric DataBand1 ASC data ASC orcamento Transparent 0,6.8,19,1.6 Transparent 11.4,0,3.8,0.6 Tahoma,8.25,Bold,Point,False,0 b25f2a3ca5cf455f910d4f3da8ae0a9c Right 0,0,0,0 Text8 Total Geral Black Expression Center Transparent 15.2,0,3.8,0.6 Tahoma,8.25,Regular,Point,False,0 fb9687665ef7478da8ea4e9a98568231 Right 0,0,0,0 Text10 {Sum(DataBand1,dados.valor_pago)} 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 010a81f8126e4a2a80f502af3446754c 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 0555bc1438004f848f0d855ea17094a4 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 545d21f209ad4f82ab82188b62ec1a76 32, 32 LabelControl1 96, 24 Data Inicial Control 168,32,96,24 Microsoft Sans Serif,8 Black 62f60a8b8ce24623a6bb78346615b962 168, 32 LabelControl2 96, 24 Data Final 32,104,96,24 Cancel Microsoft Sans Serif,8 Black 45ee86d3aade416391be3505189174d2 32, 104 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; 168,104,96,24 OK Microsoft Sans Serif,8 Black 329d1857a03f45f6af375ae76879a411 168, 104 btnGerar 96, 24 Gerar Microsoft Sans Serif,8 0cbc187c775843f4b19a0484f6bc6792 0, 0 periodo 304, 192 Selecione 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/18/2018 3:15:44 PM 9/25/2015 9:37:43 PM ffc10bc956f24bbfa3496c9dfdb8b037 Report Centimeters 2015.1.0 CSharp