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 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.id NOT IN (SELECT orcamento_id FROM nota_fiscal nf WHERE nf.orcamento_id = orc.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; 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_0_x005F_x002F_16_x005F_x002F_2018_x005F_x0020_8:38:59_x005F_x0020_AM_x002C__x005F_x0031_0_x005F_x002F_16_x005F_x002F_2018_x005F_x0020_8:38:59_x005F_x0020_AM,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 - SEM FISCAL 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,9.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.2,0,2,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.4,1 Calibri,18.75,Bold 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,56,96,20 Microsoft Sans Serif,8 Black Short 615540b872444009964d4f5f9afcd411 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 a8c722eae6d9409aa7567a6c010cb811 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 556177ade62c4d79a8f99358f54e1274 32, 32 LabelControl1 96, 24 Data Inicial Control 168,32,96,24 Microsoft Sans Serif,8 Black b3ff53b9946542a7bd0e24e2ff546d93 168, 32 LabelControl2 96, 24 Data Final 32,104,96,24 Cancel Microsoft Sans Serif,8 Black 76ecd45bbc6548d1bd3b894cc55b3e79 32, 104 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; 168,104,96,24 OK Microsoft Sans Serif,8 Black d40656d52f9749e79d87966400bc93ba 168, 104 btnGerar 96, 24 Gerar Microsoft Sans Serif,8 c407f5ec13524f828931e2e0bbd881b8 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 Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Report 10/16/2018 8:39:26 AM 9/25/2015 9:37:43 PM 72adc3d218b8456094cb964f152dfa87 Report Centimeters 2015.1.0 CSharp