Gestor
41T1Ak1KcqlrCDGA4njsr9XEjYzZTyLda1r9zPtM4AfHEsHNTUvTccNDbczqAC1O5Nb171hR+vXqbdH44SXnRsJeZQ1IQJKMfBWlaHT4LF7EWvkJ1UqapMBu6IXlKetj38j1AtML8rx5ey0c
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
notafiscal
numero,System.String
modelo,System.String
serie,System.String
data_emissao,System.DateTime
tipo,System.String
chave_acesso,System.String
protocolo,System.String
protocolo_dh,System.String
destinatario_nome,System.String
destinatario_cnpjcpf,System.String
nota_fiscal_id,System.Int32
valor_nota,System.Decimal
justificativa_cancelamento,System.String
status,System.String
endereco,System.String
30
False
notafiscal
Gestor
SELECT CONCAT(nf.destinatario_endereco, ', ', nf.destinatario_numero, ' / ', nf.destinatario_bairro, ' / ', cid.nome, ' - ', cid.uf) as endereco, nf.numero, ser.modelo, ser.serie, nf.data_emissao, nf.tipo,
nf.chave_acesso, nf.protocolo, nf.protocolo_dh, nf.destinatario_nome, nf.destinatario_cnpjcpf,
nf.id as nota_fiscal_id, nf.valor_nota, nf.justificativa_cancelamento, nf.status
FROM nota_fiscal nf
LEFT JOIN nota_fiscal_serie ser ON ser.id = nf.serie
LEFT JOIN cidade cid on cid.id = nf.destinatario_cidade_id
WHERE (nf.status = 'Enviada' OR nf.status = 'Cancelada') AND
DATE_FORMAT(CAST(nf.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') and nf.cliente_id = {funcionario_id}
items
produto_id,System.Int32
descricao,System.String
NCM,System.String
quantidade,System.Decimal
valor_unitario,System.Decimal
cst,System.String
total_desconto,System.Decimal
valor_liquido,System.Decimal
nota_fiscal_id,System.Int32
cfop,System.String
30
False
items
Gestor
SELECT item.produto_id, item.descricao, prod.NCM, item.quantidade, item.valor_unitario,
item.cst, item.total_desconto, item.valor_liquido, item.nota_fiscal_id, item.cfop
FROM nota_fiscal_item item
INNER JOIN produto prod ON prod.id = item.produto_id;
nf_inutilizacao
numero_inicial,System.String
numero_final,System.String
justificativa,System.String
protocolo,System.String
data_inutilizacao,System.DateTime
30
False
nf_inutilizacao
Gestor
SELECT numero_inicial, numero_final, justificativa, protocolo, CAST(data_inutilizacao AS DATE) AS data_inutilizacao
FROM nota_fiscal_inutilizacao
WHERE CAST(data_inutilizacao AS DATE) BETWEEN '{data_inicial}' AND '{data_final}'
nf_total_cfop
cfop,System.String
total,System.Decimal
30
False
nf_total_cfop
Gestor
SELECT item.cfop, SUM(item.valor_total) AS total
FROM nota_fiscal_item item
INNER JOIN nota_fiscal nf ON nf.id = item.nota_fiscal_id
WHERE (nf.status = 'Enviada' AND nf.data_emissao BETWEEN '{data_inicial}' AND '{data_final}')
GROUP BY item.cfop;
funcionario
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
funcionario
Gestor
select * from correntista where cliente = 1
notafiscal
nota_fiscal_id
False
notafiscal
RelNF
nota_fiscal_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
,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_6_x005F_x002F_2018_x005F_x0020_3:43:20_x005F_x0020_PM_x002C__x005F_x0031_1_x005F_x002F_6_x005F_x002F_2018_x005F_x0020_3:43:20_x005F_x0020_PM,False,False
,funcionario_id,funcionario_id,System.Int32,,False,False
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,32.44,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
NOTAS FISCAIS EMITIDAS - 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
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
ReportTitleBand1
Transparent
0,4.8,19,0.2
GroupHeaderBand1
Transparent
0,5.8,19,0.8
Transparent
0,0,1.2,0.4
Tahoma,6.75,Bold,Point,False,0
4782b65c3eb4472f924b8629f7255751
0,0,0,0
Text5
Número:
Black
Expression
Center
Transparent
1.2,0,1.4,0.4
Tahoma,6.75,Regular,Point,False,0
449842ee94eb4819a2a3c85e23914fed
0,0,0,0
Text10
{notafiscal.numero}
Black
Expression
Center
Transparent
2.6,0,1,0.4
Tahoma,6.75,Bold,Point,False,0
5a2409e62beb4a8ca3da59db055f84c5
0,0,0,0
Text12
Modelo:
Black
Expression
Center
Transparent
3.6,0,0.6,0.4
Tahoma,6.75,Regular,Point,False,0
d0230226d318454aa0e3d57dc459578b
0,0,0,0
Text13
{notafiscal.modelo}
Black
Expression
Center
Transparent
4.2,0,0.8,0.4
Tahoma,6.75,Bold,Point,False,0
cc44da4d10324905ac31049996590869
0,0,0,0
Text6
Série:
Black
Expression
Center
Transparent
5,0,0.6,0.4
Tahoma,6.75,Regular,Point,False,0
c2ac0bc5b2e24519a139a8c967bfe468
0,0,0,0
Text7
{notafiscal.serie}
Black
Expression
Center
Transparent
0,0.4,1.2,0.4
Tahoma,6.75,Bold,Point,False,0
800027bac68a4e82a81557b5d03fab3a
0,0,0,0
Text8
Endereço:
Black
Expression
Center
Transparent
2.6,0.4,13.6,0.4
Tahoma,6.75,Regular,Point,False,0
455464985217450f92be44600fcf2d86
0,0,0,0
Text9
{notafiscal.endereco}
Black
DataColumn
Center
Transparent
8,0,1,0.4
Tahoma,6.75,Bold,Point,False,0
e87a4d301b0b4723bada9dfccc5f3533
0,0,0,0
Text17
Cliente:
Black
Expression
Center
Transparent
9,0,6.4,0.4
Tahoma,6.75,Regular,Point,False,0
e93e4af997bb4a1fa428047ab75081d0
0,0,0,0
Text18
{notafiscal.destinatario_nome}
Black
Expression
Center
Transparent
15.4,0,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
62aa85a522674966ab978d53be5aae87
0,0,0,0
Text19
CNPJ/CPF:
Black
Expression
Center
Transparent
16.8,0,2,0.4
Tahoma,6.75,Regular,Point,False,0
9ea124e5c22d46b799708a2813cc8d0a
0,0,0,0
Text20
{notafiscal.destinatario_cnpjcpf}
Black
Expression
Center
Transparent
15.4,0.4,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
e3b1c92f84834059a00ae06bd2f14685
0,0,0,0
Text41
Valor NF-e:
Black
Expression
Center
Transparent
16.8,0.4,2,0.4
Tahoma,6.75,Regular,Point,False,0
de9c23e74e4a4d6486fc9100cbcce890
0,0,0,0
Text42
{notafiscal.valor_nota}
Black
,
.
9
2
R$
DataColumn
Center
Transparent
6.4,0,1.6,0.4
Tahoma,6.75,Regular,Point,False,0
6d0e47a496fd442e9a3fa90b20d2c130
0,0,0,0
Text15
{notafiscal.data_emissao}
Black
Expression
Center
Transparent
5.6,0,0.8,0.4
Tahoma,6.75,Bold,Point,False,0
858219114b1240e48a637b2c078e475b
0,0,0,0
Text16
Data:
Black
Expression
Center
0,0,0,0
StartPointPrimitive1
86fea645ce064cc78185a82e5d56ed50
19,0.8,0,0
EndPointPrimitive1
86fea645ce064cc78185a82e5d56ed50
notafiscal
status,EqualTo,Enviada,,String
DataBand1
ASC
numero
Transparent
0,7.4,19,0.8
Transparent
13,0,4,0.6
Tahoma,8.25,Bold,Point,False,0
3dd02cae603a45598b2b546d65018773
0,0,0,0
Text39
Total emitido no período:
Black
Expression
Center
Transparent
True
16.8,0,2.2,0.6
Tahoma,8.25,Regular,Point,False,0
17da517b91764ba4a61a9ae5d27643c4
Right
0,0,0,0
Text40
{Sum(DataBand1,notafiscal.valor_nota)}
Black
,
.
9
2
R$
,,,,WordWrap=True,A=0
Totals
Center
GroupFooterBand1
Transparent
0,9,19,0.4
Transparent
0.4,0,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
80b3dd314a9f4d778cac5b468a9ff588
0,0,0,0
Text22
Código
Black
Expression
Center
Transparent
2.2,0,8.2,0.4
Tahoma,6.75,Bold,Point,False,0
a93699679a934440a10e7facdd21ce62
0,0,0,0
Text23
Descrição
Black
Expression
Center
Transparent
11.8,0,0.8,0.4
Tahoma,6.75,Bold,Point,False,0
317152fc43e546e5a5ac0308d21271d1
0,0,0,0
Text24
CST
Black
Expression
Center
Transparent
12.6,0,0.8,0.4
Tahoma,6.75,Bold,Point,False,0
45fe9cd69e9244d3a48d3dd1a5d3cdf3
0,0,0,0
Text25
CFOP
Black
Expression
Center
Transparent
13.4,0,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
ea7ffa0df7944fd495b80e274718a6f9
Right
0,0,0,0
Text26
Valor unit.
Black
Expression
Center
Transparent
14.8,0,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
034489a90ab04fc1b8c84a562c43a074
Right
0,0,0,0
Text27
Qtde
Black
Expression
Center
Transparent
16.2,0,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
08b93cf89c1742d0b37c1996776b0951
Right
0,0,0,0
Text28
Valor desc.
Black
Expression
Center
Transparent
17.6,0,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
47036449e7664c9c820f0e9fb0c58938
Right
0,0,0,0
Text29
Valor total
Black
Expression
Center
Transparent
10.4,0,1.4,0.4
Tahoma,6.75,Bold,Point,False,0
17d0b24ed0f14801b73d626222219b09
0,0,0,0
Text37
NCM
Black
Expression
Center
0,0,0,0
StartPointPrimitive2
1d8d6980cd714174b4311c34b9294341
19,0.4,0,0
EndPointPrimitive2
1d8d6980cd714174b4311c34b9294341
HeaderBand1
Transparent
0,10.2,19,0.4
Transparent
True
0.4,0,1.8,0.4
Tahoma,6.75,Regular,Point,False,0
0,0,0,0
Dataitems_produto_id
{items.produto_id}
Black
,,,,WordWrap=True,A=0
Center
Transparent
True
2.2,0,8.2,0.4
Tahoma,6.75,Regular,Point,False,0
d77c085fce094239a5fa2278fffab9dd
0,0,0,0
Text30
{items.descricao}
Black
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
11.8,0,0.8,0.4
Tahoma,6.75,Regular,Point,False,0
29bc37c6760c4531be52f2528d7a7202
0,0,0,0
Text31
{items.cst}
Black
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
12.6,0,0.8,0.4
Tahoma,6.75,Regular,Point,False,0
58f3388d63824552834be07760221a4f
0,0,0,0
Text32
{items.cfop}
Black
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
13.4,0,1.4,0.4
Tahoma,6.75,Regular,Point,False,0
3b3c66653b6e4fee9a3bd6e71af6a660
Right
0,0,0,0
Text33
{items.valor_unitario}
Black
,
.
1
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
14.8,0,1.4,0.4
Tahoma,6.75,Regular,Point,False,0
7b6c56447e6942babd61a5f06926ee78
Right
0,0,0,0
Text34
{items.quantidade}
Black
,
.
1
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
16.2,0,1.4,0.4
Tahoma,6.75,Regular,Point,False,0
94b4ff02d21e478d903a9ba4675f29bd
Right
0,0,0,0
Text35
{items.total_desconto}
Black
,
.
1
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
17.6,0,1.4,0.4
Tahoma,6.75,Regular,Point,False,0
2344d7e246f54279ae79c3302fe23514
Right
0,0,0,0
Text36
{items.valor_liquido}
Black
,
.
1
,,,,WordWrap=True,A=0
DataColumn
Center
Transparent
True
10.4,0,1.4,0.4
Tahoma,6.75,Regular,Point,False,0
8eed9838504a470b8281c20a2c18b99b
0,0,0,0
Text38
{IIF(Length(items.NCM) == 8,
String.Concat(
Substring(items.NCM,0,4),
'.',
Substring(items.NCM,4,2),
'.',
Substring(items.NCM,6,2)
)
, items.NCM)}
Black
,,,,WordWrap=True,A=0
Expression
Center
0,0,0,0
StartPointPrimitive3
f42e629bee1447918cbee05b5e5f5edb
0,0.4,19,0.0254
Black
Black
HorizontalLinePrimitive1
Black
19,0.4,0,0
EndPointPrimitive3
f42e629bee1447918cbee05b5e5f5edb
RelNF
items
Dataitems
Transparent
0,11.4,19,0.2
0,0,0,0
StartPointPrimitive4
e4f10ab7835a408a84bdbe5324b55e48
19,0.2,0,0
EndPointPrimitive4
e4f10ab7835a408a84bdbe5324b55e48
FooterBand1
Transparent
0,12.4,19,1.2
Transparent
0,0.1,19,0.6
Tahoma,14.25,Bold,Point,False,0
4333c2662d27499d912e417623ce86aa
Center
0,0,0,0
Text43
Numeração inutilizada
Black
Expression
Center
Transparent
0,0.8,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
2e909bcecb804acbbfa6b38153dca25f
0,0,0,0
Text45
Número inicial
Black
Expression
Center
Transparent
1.8,0.8,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
12d3b4a9698e4a16bb29dfd711362270
0,0,0,0
Text46
Número final
Black
Expression
Center
Transparent
3.6,0.8,2.4,0.4
Tahoma,6.75,Bold,Point,False,0
2d13c9480ac94c63beeaf768830f792e
0,0,0,0
Text47
Data de inutilização
Black
Expression
Center
Transparent
6,0.8,13,0.4
Tahoma,6.75,Bold,Point,False,0
a3967e3480234cb88a24d340631afe4f
0,0,0,0
Text48
Justificativa
Black
Expression
Center
0,0,0,0
StartPointPrimitive5
f8f238de993042d4852369cdd4f16f33
19,1.2,0,0
EndPointPrimitive5
f8f238de993042d4852369cdd4f16f33
HeaderBand2
Transparent
0,14.4,19,0.4
Transparent
0,0,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
8e79b8084d8244269cf1a2394d209ea2
0,0,0,0
Text49
{nf_inutilizacao.numero_inicial}
Black
DataColumn
Center
Transparent
1.8,0,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
a622b3d8951e4d6aacef68d847e3d1ec
0,0,0,0
Text51
{nf_inutilizacao.numero_final}
Black
DataColumn
Center
Transparent
3.6,0,2.4,0.4
Tahoma,6.75,Bold,Point,False,0
89d0e0a79db549b6b84b35b1c09333a8
0,0,0,0
Text50
{nf_inutilizacao.data_inutilizacao}
Black
DataColumn
Center
Transparent
6,0,13,0.4
Tahoma,6.75,Bold,Point,False,0
3205bdc55c9141dd90dfcfd51ddc2156
0,0,0,0
Text52
{nf_inutilizacao.justificativa}
Black
DataColumn
Center
0,0,0,0
StartPointPrimitive6
a3fb514cc0c84ee3a899673a55ac0bd2
19,0.4,0,0
EndPointPrimitive6
a3fb514cc0c84ee3a899673a55ac0bd2
nf_inutilizacao
DataBand2
Transparent
0,15.6,19,0.2
0,0,19,0.0254
Black
Black
HorizontalLinePrimitive2
Black
FooterBand2
Transparent
0,16.6,19,1.2
Transparent
0,0.1,19,0.6
Tahoma,14.25,Bold,Point,False,0
9f6cf39bb22a4eab810fc1c4a6f36156
Center
0,0,0,0
Text53
Notas canceladas
Black
Expression
Center
Transparent
0,0.8,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
836bbb63bc8a4fcda8146db975e9c772
0,0,0,0
Text54
Número
Black
Expression
Center
Transparent
1.8,0.8,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
663bb1eb53564d56be0a97ecc2f75a19
0,0,0,0
Text55
Série/Mod.
Black
Expression
Center
Transparent
3.6,0.8,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
819a0644caab42419849755f44dc6622
0,0,0,0
Text56
Data emissão
Black
Expression
Center
Transparent
5.4,0.8,13.6,0.4
Tahoma,6.75,Bold,Point,False,0
8bf79dde6bd4413a86ca7c6e97c42d59
0,0,0,0
Text57
Justificativa
Black
Expression
Center
0,0,0,0
StartPointPrimitive7
9bc04935e52646e4bbb3483060549630
19,1.2,0,0
EndPointPrimitive8
9bc04935e52646e4bbb3483060549630
edf558db148349589ccf267fafa1bb5b
HeaderBand3
Transparent
0,18.6,19,0.4
Transparent
0,0,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
b6c40949532248bc8a09b0cbb78b82ff
0,0,0,0
Text58
{notafiscal.numero}
Black
DataColumn
Center
Transparent
1.8,0,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
1e5bf471032c4d8281d3bb7259c8fc1e
0,0,0,0
Text59
{notafiscal.serie}/{notafiscal.modelo}
Black
Expression
Center
Transparent
3.6,0,1.8,0.4
Tahoma,6.75,Bold,Point,False,0
93fb384d3efe419caa7a8ba190d48f9f
0,0,0,0
Text60
{notafiscal.data_emissao}
Black
DataColumn
Center
Transparent
5.4,0,13.6,0.4
Tahoma,6.75,Bold,Point,False,0
d4ef9d4525c04a10850271a1979685b3
0,0,0,0
Text61
{notafiscal.justificativa_cancelamento}
Black
DataColumn
Center
0,0,0,0
StartPointPrimitive10
36308ba933434a7a9b05245893f9bee8
19,0.4,0,0
EndPointPrimitive10
36308ba933434a7a9b05245893f9bee8
notafiscal
status,EqualTo,Cancelada,,String
d7322a389be445b58d47983bd7663d7d
DataBand3
Transparent
0,19.8,19,0.8
Transparent
13,0,4,0.6
Tahoma,8.25,Bold,Point,False,0
aa91d3e7e90d417d9e2f75f0a77f53e7
0,0,0,0
Text62
Total notas canceladas:
Black
Expression
Center
Transparent
True
16.8,0,2.2,0.6
Tahoma,8.25,Regular,Point,False,0
0d6e76e9e7f84dcc9c3a8a3cda7e65df
Right
0,0,0,0
Text63
{Sum(DataBand3,notafiscal.valor_nota)}
Black
,
.
9
2
R$
,,,,WordWrap=True,A=0
Totals
Center
0,0,19,0.0254
Black
Black
c5593b8e3b934db1a26149f88bc1735d
HorizontalLinePrimitive3
Black
FooterBand3
False
0,5.8,19,0.8
Black
86fea645ce064cc78185a82e5d56ed50
RectanglePrimitive1
False
0,9,19,0.4
Black
1d8d6980cd714174b4311c34b9294341
RectanglePrimitive2
False
False
0,10.2,19,0.4
Black
f42e629bee1447918cbee05b5e5f5edb
RectanglePrimitive3
False
False
0,11.4,19,0.2
Black
e4f10ab7835a408a84bdbe5324b55e48
False
RectanglePrimitive4
False
False
0,14.4,19,0.4
Black
a3fb514cc0c84ee3a899673a55ac0bd2
RectanglePrimitive6
False
19.2,16,0,0
41cbccec0d7f45ac89e83adec8554d5e
EndPointPrimitive7
2b4c8d083fa54916854f13513a3f6c25
20.6,19.2,0,0
abe346674e724705bba4f3dd2685bfc5
EndPointPrimitive9
56de7fbc4fb641d791fd5c0972dafac6
False
0,12.4,19,1.2
Black
f8f238de993042d4852369cdd4f16f33
RectanglePrimitive5
False
0,16.6,19,1.2
Black
9bc04935e52646e4bbb3483060549630
RectanglePrimitive7
False
0,18.6,19,0.4
Black
36308ba933434a7a9b05245893f9bee8
RectanglePrimitive8
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
16dca92c891c4521b50d642683cf9082
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
4a04c5c8ef3b48ec9d8d6c74abb58c09
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
838abc6835a743c89fc9bb3e8cd6838e
32, 32
LabelControl1
96, 24
Data Inicial
Control
168,32,96,24
Microsoft Sans Serif,8
Black
f8f0daa02f8b41d09c458c17e57ab88c
168, 32
LabelControl2
96, 24
Data Final
32,144,96,24
Cancel
Microsoft Sans Serif,8
Black
ab3bbedd0bc5424da0042a450633123c
32, 144
btnCancelar
96, 24
Cancelar
Data.From = dtInicial.Value;
Data.To = dtFinal.Value;
int.TryParse(txtFuncionario.SelectedValue.ToString(), out funcionario_id);
168,144,96,24
OK
Microsoft Sans Serif,8
Black
586a27aaa65d4d7e87a583d475f0ca14
168, 144
btnGerar
96, 24
Gerar
Window
32,104,232,20
Microsoft Sans Serif,8
Black
f1b92882a6d24069b13daf15507f95b3
32, 104
txtFuncionario
232, 20
Control
32,88,96,16
Microsoft Sans Serif,8
Black
751d64b76c6c41ab94907150608e6220
32, 88
LabelControl3
96, 16
Cliente
Microsoft Sans Serif,8
ad3c3d12ac8043f789b9b6348d9935f8
txtFuncionario.Control.Items.Clear();
txtFuncionario.Control.DisplayMember = "nome_fantasia";
txtFuncionario.Control.ValueMember = "id";
txtFuncionario.Control.DataSource = this.Dictionary.DataSources["funcionario"].DataTable;
0, 0
periodo
304, 208
Periodo
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
5/13/2019 4:21:07 PM
9/25/2015 9:37:43 PM
D:\Kinyx\Relatórios\Notas_emitidas_detalhado_por_cliente.mrt
ad5545d1850e445d967c8c1df502e2b3
Report
Centimeters
2015.1.0
CSharp