Gestor 48jNAk1PQ6jifu3s6Xglp9Vw9e/VSqIdaVqxwGQlYxPHeOFMT0vTyGtDbYXqAHdn39ZzbNl2eglvE7mt4oTrRpDeZYnbS/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 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 from configuracao c left join cidade on cidade.id = c.cidade_id dados nome_cliente,System.String cliente_id,System.Int32 vendedor_id,System.Int32 data_emissao,System.DateTime valor_bruto,System.Decimal valor_desconto,System.Decimal valor_liquido,System.Decimal orcamento_id,System.Int32 30 False dados Gestor SELECT orc.id as orcamento_id, orc.nome_cliente, orc.cliente_id, orc.vendedor_id, orc.data_emissao, orc.valor_bruto, orc.valor_desconto, orc.valor_liquido FROM orcamento orc WHERE orc.status = 'Faturado' AND orc.cliente_id = {id} 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') itens id,System.Int32 descricao,System.String valor_unitario,System.Decimal quantidade,System.Decimal valor_liquido,System.Decimal orcamento_id,System.Int32 produto_id,System.Int32 valor_desconto,System.Decimal 30 False itens Gestor SELECT item.id, item.descricao, item.valor_unitario, item.quantidade, item.valor_liquido, item.orcamento_id, item.produto_id, item.valor_desconto FROM orcamento_item item; cliente id,System.Int32 tipo_pessoa,System.String nome_fantasia,System.String razao_social,System.String contato,System.String data_nascimento,System.DateTime cep,System.String endereco,System.String numero,System.String bairro,System.String uf,System.String cpf_cnpj,System.String rg_ie,System.String telefone,System.String celular,System.String fax,System.String email,System.String limite_credito,System.Decimal data_cadastro,System.DateTime observacoes,System.String cliente,System.Boolean funcionario,System.Boolean fornecedor,System.Boolean estado_civil,System.String inativo,System.Boolean usuario,System.String senha,System.String liberador,System.Boolean seq_sincronizacao,System.Int64 codigo_retaguarda,System.String fun_limite_desconto,System.Decimal ddd_telefone,System.String ddd_celular,System.String limite_credito_utilizado,System.Decimal limite_credito_saldo,System.Decimal complemento,System.String inscricao_municipal,System.String filiacao_mae,System.String filiacao_pai,System.String conjuge_nome,System.String conjuge_telefone,System.String conjuge_celular,System.String conjuge_local_trabalho,System.String trabalho_empresa,System.String trabalho_cargo,System.String trabalho_data_admissao,System.DateTime trabalho_renda,System.Decimal senha_venda,System.String nao_contribuinte_icms,System.Boolean ie_produtor_rural,System.String codigo_geral,System.String bairro_id,System.Int32 cidade_id,System.Int32 grupo_usuario_id,System.Int32 grupo_correntista_id,System.Int32 pais_id,System.Int32 id_temp,System.String cidade_temp,System.String imagem,System.Byte[] 30 False cliente Gestor select * from correntista where cliente = 1 and inativo = 0 rel_itens orcamento_id False rel_itens rel_itens orcamento_id ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,id,id,System.Int32,_x0030_,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0036__x005F_x002F_17_x005F_x002F_2019_x005F_x0020_10:07:50_x005F_x0020_AM_x002C__x005F_x0036__x005F_x002F_17_x005F_x002F_2019_x005F_x0020_10:07:50_x005F_x0020_AM,False,False ,Produto,Produto,System.String,,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,15.6,1.6,0.4 Tahoma,8 8c84d3d06d734821b41fdbfc37ed4432 Right 0,0,0,0 Text46 Black , . 1 Expression Center Transparent 24,15.6,2,0.4 Tahoma,8 a4b7df62d2114d788ea96e7bba28304d Right 0,0,0,0 Text64 Black , . 1 Expression Center Transparent 26,15.6,1.6,0.4 Tahoma,8 f61cc11b8bc849f882b73b2edf16dd85 Right 0,0,0,0 Text65 Black , . 1 Expression Center 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 32fcfe6cb44346faa56d0ab4459ef577 Center 0,0,0,0 Text1 VENDAS POR PRODUTO Black Expression 4c6a4053e22b45a08cd86e38ff590dc3 Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 2701cf8d53154cbc83df5c54d5e56e36 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 153d69fa8067494d9cdea54640126859 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 47116c593046488ca547f97e20ef2bcf 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 3bfa00ed32e643b7b393ced7fd1432a3 Right 0,0,0,0 Text11 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 c44815fb27a84ee5b1e37e997d4616bb imgLogo Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a1df6857f70d4ebe85448eabedceaf40 0,0,0,0 Text44 {descricao_filtros} Black Expression Center ReportTitleBand1 Top;Black;1;Dot;False;4;Black Transparent 0,4.8,19,0.6 GlassBrush,Gainsboro,True,0.2 0,0,19,0.6 Transparent 0,0,1.2,0.6 Arial,6.75,Bold,Point,False,0 0,0,0,0 Text10 Nº Venda: Black Expression Center Transparent 13.2,0,0.8,0.6 Arial,6.75,Bold,Point,False,0 b86e761584a04373b79a63bd6f6be4c9 0,0,0,0 Text16 Data: Black Expression Center Transparent 14,0,2,0.6 Arial,6.75,Regular,Point,False,0 e3b51e6320cb4ca5a6caf74e3fd12591 0,0,0,0 Text17 {dados.data_emissao} Black DataColumn Center Transparent 16,0,1.2,0.6 Arial,6.75,Bold,Point,False,0 1ff89b51ca0148ba96f3c70dbe960fde 0,0,0,0 Text18 Valor liq.: Black Expression Center Transparent 17.2,0,1.8,0.6 Arial,6.75,Regular,Point,False,0 328b9a14479e4d9bbabf4f6328b521bb 0,0,0,0 Text19 {dados.valor_liquido} Black , . 1 0 R$ DataColumn Center Transparent 1.2,0,1.4,0.6 Arial,6.75,Regular,Point,False,0 f31053703ae94c07a6e564d0a98a3442 0,0,0,0 Text12 {dados.orcamento_id} Black 000000 Expression Center Transparent 2.6,0,1,0.6 Arial,6.75,Bold,Point,False,0 8ccd5adc3cb44d8089e741830aa13119 0,0,0,0 Text13 Cliente: Black Expression Center Transparent 3.6,0,9.6,0.6 Arial,6.75,Regular,Point,False,0 579186ca05c84ee3a92662a0a6554c32 0,0,0,0 Text15 {dados.nome_cliente} Black 000000 DataColumn Center 0,0,0,0 StartPointPrimitive1 0e327e50c2b44df7b75ab6609c869d98 4db9f117d8cb43739de60f4e8c12b72f Panel2 19,0.6,0,0 EndPointPrimitive1 0e327e50c2b44df7b75ab6609c869d98 dados DataBand1 ASC codigo None;Black;2;Dot;False;4;Black Transparent 0,6.2,19,0.4 Left;Black;1;Dot;False;4;Black Transparent 0,0,1.2,0.4 Arial,6.75,Bold,Point,False,0 cf7562448bdd48609fba3fae19e1193e 0,0,0,0 Text23 Código Black Expression Left;Black;1;Dot;False;4;Black Transparent 12.4,0,2,0.4 Arial,6.75,Bold,Point,False,0 a3e909581f254bfb9c44e06d6348e204 Right 0,0,0,0 Text25 Valor unit. Black Expression Left;Black;1;Dot;False;4;Black Transparent 14.4,0,1.4,0.4 Arial,6.75,Bold,Point,False,0 ebc2a6a26d2c437fa2ec0d6437a63d59 Right 0,0,0,0 Text26 Quantidade Black Expression Left;Black;1;Dot;False;4;Black Transparent 15.8,0,1.4,0.4 Arial,6.75,Bold,Point,False,0 60028ae96c2a45d797bab64b66fa7a3d Right 0,0,0,0 Text27 Desc. Black Expression Left, Right;Black;1;Dot;False;4;Black Transparent 17.2,0,1.8,0.4 Arial,6.75,Bold,Point,False,0 e6f9535a1efb45778ed6dd568ed94c73 Right 0,0,0,0 Text28 Valor líq. Black Expression Left;Black;1;Dot;False;4;Black Transparent 1.2,0,11.2,0.4 Arial,6.75,Bold,Point,False,0 6878e571f7984459b1c145c2d0881f2d 0,0,0,0 Text24 Descrição Black Expression GroupHeaderBand1 All;Black;1;Dot;False;4;Black EmptyBrush 0,7.4,19,0.4 Transparent 17.2,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 9cfc156dd3944e68a8635bdf704fdbc9 Right 0,0,0,0 Text5 {itens.valor_liquido} Black , . 9 2 R$ DataColumn Center Transparent 15.8,0,1.4,0.4 Arial,6.75,Regular,Point,False,0 80dd76eeb9644780906b8122210a1ecd Right 0,0,0,0 Text6 {itens.valor_desconto} Black , . 9 2 R$ DataColumn Center Transparent 14.4,0,1.4,0.4 Arial,6.75,Regular,Point,False,0 885341e4f18c4d1ea224066b0840a96c Right 0,0,0,0 Text7 {itens.quantidade} Black , . 1 DataColumn Center Transparent 12.4,0,2,0.4 Arial,6.75,Regular,Point,False,0 f90c4a4b8d0540cdb963764f3e66e1a3 Right 0,0,0,0 Text8 {itens.valor_unitario} Black , . 9 2 R$ DataColumn Center Transparent 1.2,0,11.2,0.4 Arial,6.75,Regular,Point,False,0 b467aca8190f44878237e245c7d4657b 0,0,0,0 Text9 {itens.descricao} Black , . 9 2 R$ DataColumn Center Transparent 0,0,1.2,0.4 Arial,6.75,Regular,Point,False,0 687940a733c34e14b7656c01c40acd17 Right 0,0,0,0 Text29 {itens.id} Black DataColumn Center rel_itens itens DataBand2 All;Black;1;Dot;False;4;Black Transparent 0,8.6,19,0.6 Transparent 14.4,0,1.4,0.6 Arial,6.75,Regular,Point,False,0 1c2c3d1764c14788889d4333ec3eb656 Right 0,0,0,0 Text20 {Sum(DataBand2,itens.quantidade)} Black , . 1 Totals Center Transparent 12.4,0,2,0.6 Arial,6.75,Regular,Point,False,0 8c030e5470dd450c9a8d066311831eda Right 0,0,0,0 Text22 TOTAIS: Black , . 1 Expression Center Transparent 17.2,0,1.8,0.6 Arial,6.75,Regular,Point,False,0 a4c5fb46df41499ab2271fef7631f68d Right 0,0,0,0 Text30 {Sum(DataBand2,itens.valor_liquido)} Black , . 9 2 R$ Totals Center GroupFooterBand1 Transparent 0,10,19,0.8 Transparent 12.4,0,2,0.8 Tahoma,8.25,Bold,Point,False,0 51fa51ce4ce14a0e937d44d5c2ab2530 Right 0,0,0,0 Text42 Total Geral: Black Expression Center Transparent 14.4,0,1.4,0.8 Arial,6.75,Regular,Point,False,0 6c7eb42647f746f2a041b7bafcc3be23 Right 0,0,0,0 Text31 {SumRunning(DataBand2,itens.quantidade)} Black , . 1 Totals Center Transparent 17.2,0,1.8,0.8 Arial,6.75,Regular,Point,False,0 7a4ddd4210cc463eb6ba3e69496ba933 Right 0,0,0,0 Text32 {SumRunning(DataBand2,itens.valor_liquido)} Black , . 9 2 R$ Totals Center 9fd6e8c6c54149028538b63408fc786e ReportSummaryBand1 False 0,4.8,19,0.6 Black 0e327e50c2b44df7b75ab6609c869d98 RectanglePrimitive1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 32,40,96,20 Microsoft Sans Serif,8 Black Short 5db2c69bbed04017976b74bbca3f855b 32, 40 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,40,96,20 Microsoft Sans Serif,8 Black Short 1ca469d7194a451dbcdbc67f804a4555 168, 40 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,16,96,24 Microsoft Sans Serif,8 Black 4a48d78d75c84841abe82832b208f4cd 32, 16 LabelControl1 96, 24 Data Inicial Control 168,16,96,24 Microsoft Sans Serif,8 Black 43294794c17c421b82f27ec4473f0569 168, 16 LabelControl2 96, 24 Data Final 40,144,96,24 Cancel Microsoft Sans Serif,8 Black b330fcf93832492cb47810ac22f87f3c 40, 144 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; int.TryParse(txtProduto.SelectedValue.ToString(), out id); 168,144,96,24 OK Microsoft Sans Serif,8 Black 53f90c80d067483997c2b1eff3bd62c5 168, 144 btnGerar 96, 24 Gerar Window 32,96,232,20 Microsoft Sans Serif,8 Black b84a274a84f3413787665811bb9cbc07 32, 96 txtProduto 232, 20 Control 32,80,96,16 Microsoft Sans Serif,8 Black 7e97e325b0a843db807be77487cfc74d 32, 80 LabelControl3 96, 16 Cliente Microsoft Sans Serif,8 c81bc2bb8a7240afab4ae26057ed8665 txtProduto.Control.Items.Clear(); txtProduto.Control.DisplayMember = "razao_social"; txtProduto.Control.ValueMember = "id"; txtProduto.Control.DataSource = this.Dictionary.DataSources["cliente"].DataTable; 0, 0 Form1 304, 208 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 Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Report 6/17/2019 11:07:59 AM 9/25/2015 9:37:43 PM Report.mrt 688f754236d04c268a66f9c4b033c010 Report Centimeters 2015.1.0 CSharp