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 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.String nome_fantasia,System.String razao_social,System.String cpf_cnpj,System.String telefone,System.String tipo_pessoa,System.String nome_cidade,System.String cidade_id,System.Int32 endereco,System.String numero,System.String celular,System.String nome,System.String 30 False dados Gestor SELECT LPAD(c.id, 6, '0') AS id, c.nome_fantasia, c.razao_social, c.cpf_cnpj, c.endereco, c.numero, c.celular, cidade.nome, c.tipo_pessoa, COALESCE(UPPER(cidade.nome), 'NÃO DEFINIDO') AS nome_cidade, c.cidade_id FROM correntista c LEFT JOIN cidade ON cidade.id = c.cidade_id WHERE CASE WHEN {cliente} = 0 THEN c.cliente = 0 ELSE 1 = 1 END AND CASE WHEN {funcionario} = 0 THEN c.funcionario = 0 ELSE 1 = 1 END AND CASE WHEN {fornecedor} = 0 THEN c.fornecedor = 0 ELSE 1 = 1 END AND CASE WHEN '{uf}' <> '' THEN c.uf = '{uf}' ELSE 1 = 1 END AND CASE WHEN {cidade_id} <> 0 THEN c.cidade_id = {cidade_id} ELSE 1 = 1 END AND CASE WHEN {grupo_id} <> 0 THEN c.grupo_correntista_id = {grupo_id} ELSE 1 = 1 END ,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 ,tipo_correntista,tipo_correntista,System.String,_x0030_,False,False ,agrupar_por,agrupar_por,System.String,_x0030_,False,False ,correntista_id,correntista_id,System.String,_x0030_,False,False ,cliente,cliente,System.String,_x0030_,False,False ,funcionario,funcionario,System.String,_x0030_,False,False ,fornecedor,fornecedor,System.String,_x0030_,False,False ,uf,uf,System.String,,False,False ,grupo_id,grupo_id,System.String,_x0030_,False,False ,cidade_id,cidade_id,System.String,_x0030_,False,False EngineV2 agrup_cidade.Enabled = agrupar_por == "1"; dadosCidade.Enabled = agrupar_por == "1"; agrup_tipo_pessoa.Enabled = agrupar_por == "2"; dadosTipoPessoa.Enabled = agrupar_por == "0" || agrupar_por == "2"; // agrupamento_cidade.Enabled = agrupar_por == "1"; // agrupamento_pessoa.Enabled = agrupar_por == "2"; // agrupamento_cidade.Condition = new StiGroupConditionExpression("dados.cidade_id"); /*if(agrupar_por != "0") { agrupamento.Condition = new StiGroupConditionExpression(agrupar_por == "1" ? "dados.cidade_id" : "dados.tipo_pessoa"); txtAgrupamento.Text = agrupar_por == "1" ? "Cidade: {dados.nome_cidade}" : "Tipo pessoa: {dados.tipo_pessoa}"; } else agrupamento.Enabled = false; */ 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 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 CORRENTISTAS 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 config.imagem_logo c44815fb27a84ee5b1e37e997d4616bb imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a1df6857f70d4ebe85448eabedceaf40 0,0,0,0 Text44 {descricao_filtros} Black Expression Center Transparent 0,3.6,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 4782b65c3eb4472f924b8629f7255751 0,0,0,0 Text5 Código Black Expression Center Transparent 1.8,3.6,5.6,0.6 Tahoma,8.25,Bold,Point,False,0 68025bd5b98a483baea08f789dc179bc 0,0,0,0 Text6 Nome fantasia Black Expression Center Transparent 16.2,3.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 8d12ae6bbf094519956e9e40bbd0b306 0,0,0,0 Text7 CPF/CNPJ Black Expression Center Transparent 12.6,3.6,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 c854891650a54db0afcf18fa0c030de2 0,0,0,0 Text9 Telefone Black Expression Center Transparent 7.4,3.6,3.8,0.6 Tahoma,8.25,Bold,Point,False,0 30ba0efbc6894dc3b7c7a8bca967b3ec 0,0,0,0 Text22 Endereço Black Expression Center Transparent 11.2,3.6,1.4,0.6 Tahoma,8.25,Bold,Point,False,0 1903b18a2bc54117b30ece51e5c45547 0,0,0,0 Text23 Nº Black Expression Center Transparent 14.4,3.6,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 471b7f1edcdd41359950bda26bedfaa3 0,0,0,0 Text24 Cidade Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.8 Transparent 0,0.2,19,0.4 Tahoma,9.75,Bold,Point,False,0 1c9a936d0a754ddeae3bbcef2bd68d5f 0,0,0,0 txtAgrupamento Cidade: {dados.nome_cidade} Black Expression Center {dados.cidade_id} agrup_cidade Transparent 0,7,19,0.4 Transparent 0,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 2a82ad00dfe64b3b8080f19443675b4f 0,0,0,0 Text8 {dados.id} Black DataColumn Center Transparent 1.8,0,5.6,0.4 Tahoma,8.25,Regular,Point,False,0 097b4ab9f0054afe89c4607646469cbf SinglePage 36fb6d66577e4b23a34cea38a6a2a5f5 0,0,0,0 Text10 asdASDSADASD {dados.nome_fantasia} Black TESTSE DataColumn Center Transparent 16.2,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 f3b2dfac673c4f23b8b9bdc6fb0078b3 0,0,0,0 Text12 {dados.cpf_cnpj} Black DataColumn Center Transparent 12.6,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 c6718ca8bc024f1dbde42ad265cbfa03 0,0,0,0 Text13 {dados.celular} Black DataColumn Center Transparent 14.4,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 4866e7f5a8e04c8fb540e47c69ba6dd2 0,0,0,0 Text25 {dados.nome} Black DataColumn Center Transparent 11.2,0,1.4,0.4 Tahoma,8.25,Regular,Point,False,0 e31b295a376a4dd3a63e85dac23aa6c1 0,0,0,0 Text26 {dados.numero} Black DataColumn Center Transparent 7.4,0,3.8,0.4 Tahoma,8.25,Regular,Point,False,0 aaafcd1373874a1ab8a53a38c3fc1d4f SinglePage 36fb6d66577e4b23a34cea38a6a2a5f5 0,0,0,0 Text27 asdASDSADASD {dados.endereco} Black TESTSE DataColumn Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados 36fb6d66577e4b23a34cea38a6a2a5f5 dadosCidade ASC id Transparent 0,8.2,19,0.8 Transparent 0,0.2,19,0.4 Tahoma,9.75,Bold,Point,False,0 869f23bfd43640e593f41d8253706179 0,0,0,0 Text15 Tipo pessoa: {dados.tipo_pessoa} Black Expression Center {dados.tipo_pessoa} 8631f1c26594442dbd4ac0167ff18403 agrup_tipo_pessoa Transparent 0,9.8,19,0.4 Transparent 0,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 9a83883fec094458bcdc44a19796989a 0,0,0,0 Text16 {dados.id} Black DataColumn Center Transparent 1.8,0,5.6,0.4 Tahoma,8.25,Regular,Point,False,0 06983f78d4984c13a573d112ec102a57 SinglePage 36fb6d66577e4b23a34cea38a6a2a5f5 0,0,0,0 Text18 asdASDSADASD {dados.nome_fantasia} Black TESTSE DataColumn Center Transparent 16.2,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 e17e77a1b27e4d52b32433d5c96b24d0 0,0,0,0 Text19 {dados.cpf_cnpj} Black DataColumn Center Transparent 12.6,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 10208435716a4069816fed0695b62a22 0,0,0,0 Text20 {dados.celular} Black DataColumn Center Transparent 14.4,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 21cbe23e094744c58b4c27236f7bbbe5 0,0,0,0 Text28 {dados.nome} Black DataColumn Center Transparent 11.2,0,1.4,0.4 Tahoma,8.25,Regular,Point,False,0 f44c33fa4add4a648bb44cfd5013905d 0,0,0,0 Text29 {dados.numero} Black DataColumn Center Transparent 7.4,0,3.8,0.4 Tahoma,8.25,Regular,Point,False,0 898aab99fdae44b5897b4c151a1e9a60 SinglePage 36fb6d66577e4b23a34cea38a6a2a5f5 0,0,0,0 Text30 asdASDSADASD {dados.endereco} Black TESTSE DataColumn Center 0,0.4,19,0.0254 Black Black 2e73b3a758b74c4d8e7ee9ed75ee76cb HorizontalLinePrimitive2 Black dados 29c2333af7224c95b98348d74f08f0b9 36fb6d66577e4b23a34cea38a6a2a5f5 dadosTipoPessoa ASC tipo_pessoa 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0,9.2,0.6 Arial,8 0,0,0,0 Text17 TESTESTESTESTSE Black Expression 36fb6d66577e4b23a34cea38a6a2a5f5 1,1,1,1 Page2 29.7 21 Arial,100 [50:0:0:0] 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 7/1/2019 4:45:32 PM 9/25/2015 9:37:43 PM f864d322fe924a17964b69a7ecf2b6f2 Report Centimeters 2015.1.0 CSharp