Gestor 49T1CeMLG+3CFYRUZHTvXoYajyvnA8tt4kOhCE1MrWPHwM/rQ12jpO1tpeToKOEv6BSNLVpLAfXtWxUAYwBhe8PIaStPXfvdcUCs 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 CASE WHEN '{cliente_id}' <> '0' THEN orc.cliente_id = {cliente_id} ELSE 1 = 1 END 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 where CASE WHEN {Todos_os_produtos} = 1 THEN 1 = 1 ELSE item.descricao like '{Produto}' END produto produtos,System.String id_produto,System.Int32 30 False produto Gestor select DISTINCT(p.descricao) as produtos, p.id as id_produto from orcamento orc inner join orcamento_item orc_item on orc_item.orcamento_id = orc.id inner join produto p on p.id = orc_item.produto_id inner join unidade un on un.id = p.unidade_id where orc.status = 'Faturado' order by p.descricao 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 ,cliente_id,cliente_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_x0031_1_x005F_x002F_19_x005F_x002F_2018_x005F_x0020_3:57:18_x005F_x0020_PM_x002C__x005F_x0031_1_x005F_x002F_19_x005F_x002F_2018_x005F_x0020_3:57:18_x005F_x0020_PM,False,False ,Produto,Produto,System.String,,False,False ,Todos_os_produtos,Todos_os_produtos,System.Boolean,false,False,False EngineV2 // Se existir imagem de logo string arquivoLogo = System.IO.Path.Combine(Application.StartupPath, "Relatorios", "logo_empresa.png"); if (System.IO.File.Exists(arquivoLogo)) { imgLogo.Image = System.Drawing.Image.FromFile(arquivoLogo); } dbNaoEncontrado.Enabled = Totals.Count(DataBand1) == 0; 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 32fcfe6cb44346faa56d0ab4459ef577 Center 0,0,0,0 Text1 VENDAS DETALHADO 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 Transparent 0,4.8,19,0.4 Transparent 0,0,1.2,0.4 Arial,6.75,Bold,Point,False,0 0,0,0,0 Text10 Nº Venda: Black Expression Transparent 1.2,0,1.4,0.4 Arial,6.75,Regular,Point,False,0 f31053703ae94c07a6e564d0a98a3442 0,0,0,0 Text12 {dados.orcamento_id} Black 000000 Expression Transparent 2.6,0,1,0.4 Arial,6.75,Bold,Point,False,0 8ccd5adc3cb44d8089e741830aa13119 0,0,0,0 Text13 Cliente: Black Expression Transparent 3.6,0,9.6,0.4 Arial,6.75,Regular,Point,False,0 579186ca05c84ee3a92662a0a6554c32 0,0,0,0 Text15 {dados.nome_cliente} Black 000000 DataColumn Transparent 13.2,0,0.8,0.4 Arial,6.75,Bold,Point,False,0 b86e761584a04373b79a63bd6f6be4c9 0,0,0,0 Text16 Data: Black Expression Transparent 14,0,2,0.4 Arial,6.75,Regular,Point,False,0 e3b51e6320cb4ca5a6caf74e3fd12591 0,0,0,0 Text17 {dados.data_emissao} Black DataColumn Transparent 16,0,1.2,0.4 Arial,6.75,Bold,Point,False,0 1ff89b51ca0148ba96f3c70dbe960fde 0,0,0,0 Text18 Valor liq.: Black Expression Transparent 17.2,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 328b9a14479e4d9bbabf4f6328b521bb 0,0,0,0 Text19 {dados.valor_liquido} Black , . 1 0 R$ DataColumn 0,0,0,0 StartPointPrimitive1 0e327e50c2b44df7b75ab6609c869d98 19,0.4,0,0 EndPointPrimitive1 0e327e50c2b44df7b75ab6609c869d98 dados DataBand1 ASC codigo Transparent 0,6,19,0.4 Transparent 0,0,1.2,0.4 Arial,6.75,Bold,Point,False,0 cf7562448bdd48609fba3fae19e1193e 0,0,0,0 Text23 Código Black Expression 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 Transparent 12.4,0,1.8,0.4 Arial,6.75,Bold,Point,False,0 a3e909581f254bfb9c44e06d6348e204 Right 0,0,0,0 Text25 Valor unit. Black Expression 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 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 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 0,0,0,0 StartPointPrimitive2 962dfd4de817421cac0292f111677af1 19,0.4,0,0 EndPointPrimitive2 962dfd4de817421cac0292f111677af1 HeaderBand1 Transparent 0,7.2,19,0.4 Transparent 0,0,1.2,0.4 Arial,6.75,Regular,Point,False,0 ff206d8131ae4a329119c67b57c9b225 0,0,0,0 Text20 {itens.produto_id} Black 000000 DataColumn Transparent 1.2,0,11.2,0.4 Arial,6.75,Regular,Point,False,0 5de993c4a5614e6ba410b90324723ee4 0,0,0,0 Text22 {itens.descricao} Black DataColumn 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 , . 1 DataColumn 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 , . 1 DataColumn 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 Transparent 12.4,0,1.8,0.4 Arial,6.75,Regular,Point,False,0 f90c4a4b8d0540cdb963764f3e66e1a3 Right 0,0,0,0 Text8 {itens.valor_unitario} Black , . 1 DataColumn 0,0,0,0 StartPointPrimitive3 e2043fc1d8844e27a5a143fec34ca8b6 19,0.4,0,0 EndPointPrimitive3 e2043fc1d8844e27a5a143fec34ca8b6 rel_itens itens DataBand2 Transparent 0,8.4,19,0.4 0,0,19,0.0254 Black Black HorizontalLinePrimitive1 Black FooterBand1 Transparent 0,9.6,19,1.8 Transparent 0.2,0,1.2,1.6 Arial,36,Regular,Point,False,0 0f4dff5fc8484990a26a72f3e0be2875 0,0,0,0 Text9 :( Black Expression Transparent 1.4,0.4,17.6,1 Calibri,20.25,Regular,Point,False,0 80e663d7c3af4281aca045a0c2fdc795 0,0,0,0 Text29 Nenhum registro encontrado com os parâmetros informados. Black Expression dbNaoEncontrado False 0,4.8,19,0.4 Black 0e327e50c2b44df7b75ab6609c869d98 RectanglePrimitive1 False 0,6,19,0.4 Black 962dfd4de817421cac0292f111677af1 RectanglePrimitive2 False False 0,7.2,19,0.4 Black e2043fc1d8844e27a5a143fec34ca8b6 RectanglePrimitive3 False 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 85e9fec4649d4d7da5ea14473e299dde 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 08dcfee395e446a783d35ac56d1059c6 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 29219039acfc4f938a4406d9b5c65853 32, 16 LabelControl1 96, 24 Data Inicial Control 168,16,96,24 Microsoft Sans Serif,8 Black 56a311c019e946b3b14d443c5547188c 168, 16 LabelControl2 96, 24 Data Final 32,160,96,24 Cancel Microsoft Sans Serif,8 Black a903c72c292f4c039a118c23a8e52122 32, 160 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; Produto = txtProduto.Text; Todos_os_produtos = tdProdutos.Checked; 168,160,96,24 OK Microsoft Sans Serif,8 Black 74a4e67974e04e24901c28ddee531f75 168, 160 btnGerar 96, 24 Gerar Window 32,120,232,20 Microsoft Sans Serif,8 Black 63728222a16e425082967c3d76fc3974 32, 120 txtProduto 232, 20 Control 32,104,96,16 Microsoft Sans Serif,8 Black b79694a393914e4bb23647b5b2e2fea5 32, 104 LabelControl3 96, 16 Produto Control 32,72,232,24 Microsoft Sans Serif,8 Black 1f8ef422af494d629a139b3f95922499 32, 72 tdProdutos 232, 24 Todos os Produtos Microsoft Sans Serif,8 4b284ec95a1747aaa2a0c18056bcb5cf txtProduto.Control.Items.Clear(); txtProduto.Control.DisplayMember = "produtos"; txtProduto.Control.ValueMember = "id_produto"; txtProduto.Control.DataSource = this.Dictionary.DataSources["produto"].DataTable; 0, 0 periodo 304, 232 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 10:21:36 AM 9/25/2015 9:37:43 PM D:\Kinyx\Relatórios\vendas_detalhado_por_produto.mrt d4bccf61c4bc4afe831695fa97918ac3 Report Centimeters 2015.1.0 CSharp