DBNfeConnection Password=kcms2011;Data Source=192.168.1.213;Integrated Security=False;Initial Catalog=DBNFE_kcms;User ID=kcms DBNfeConnection False NotasEmitidas NRNOTA,System.Int32 DTEMISSAO,System.DateTime CODSTATUSNFE,System.Int32 DESCRICAO,System.String RAZAOSOCIAL,System.String TOTAL,System.Decimal CHAVEACESSO,System.String 30 NotasEmitidas DBNfeConnection _x0040_notaDe,_x0031_,8,0 _x0040_notaAte,_x0039_9999,8,0 _x0040_dataDe,DateTime.Now,4,0 _x0040_dataAte,DateTime.Now,4,0 SELECT NOTA.NRNOTA, NOTA.DTEMISSAO, NOTA.CODSTATUSNFE, STATUSNFE.DESCRICAO, DESTINATARIO.RAZAOSOCIAL, NOTA.CHAVEACESSO, sum(TOTAL.VLRTOTAL) as TOTAL From NOTA INNER JOIN STATUSNFE ON (STATUSNFE.CODSTATUSNFE = NOTA.CODSTATUSNFE) INNER JOIN DESTINATARIO ON (DESTINATARIO.IDNOTA = NOTA.IDNOTA) INNER JOIN TOTAL ON (TOTAL.IDNOTA = NOTA.IDNOTA) where NOTA.NRNOTA >= @notaDe and NOTA.NRNOTA <= @notaAte and NOTA.DTEMISSAO >= @dataDe and NOTA.DTEMISSAO <= @dataAte GROUP BY NOTA.NRNOTA, NOTA.DTEMISSAO, NOTA.CODSTATUSNFE, STATUSNFE.DESCRICAO, DESTINATARIO.RAZAOSOCIAL, NOTA.CHAVEACESSO ORDER BY NOTA.NRNOTA CONFIG SITE_RECEITA,System.String 30 CONFIG DBNfeConnection select * from CONFIG ,contador,contador,System.UInt32,_x0030_,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 0,0,6,0.8 Left Arial,8,Bold 0379d784e4d146699d35d2caf1580de6 http://www.kcms.com 0,0,0,0 Text7 (c) KCMS Solus Report Report Version 1.0 Black Expression Center Transparent 14.6,0,4.4,0.8 Right Arial,8,Bold b673a011e67b4322a1aa52927742086a Right 0,0,0,0 Text14 {PageNofM} Black Center 3bc46c9f69ef4994a4921c87b887fe06 PageFooterBand1 Transparent 0,0.4,19,2 EmptyBrush 0,0.2,9.4,0.8 Arial,18,Bold 0414836f01534c7d8e92a9a5c77ae583 0,0,0,0 Text1 Notas Emitidas Black Expression Transparent 0.2,1,12.8,0.4 Arial,8 e5033b899c094780a9ddb85a4006d671 0,0,0,0 Text9 Data De: {NotasEmitidas.Parameters["@dataDe"].ParameterValue} - Ate: {NotasEmitidas.Parameters["@dataAte"].ParameterValue} Black F Expression Transparent 15,0,4,0.4 Arial,8 3c5c3e8cada643bea87c5ce166f0258d Right 0,0,0,0 Text13 Emissão: {Time} Black Transparent 4.8,1.6,5.2,0.4 Arial,8 0,0,0,0 Text17 {CONFIG.SITE_RECEITA} Black Transparent 0.2,1.6,4.4,0.4 Arial,8 0,0,0,0 Text18 Consultar as chaves de acesso em : Black Expression ReportTitleBand1 Transparent 0,3.2,19,1 Transparent 0.2,0.6,1.8,0.4 Arial,8,Bold f1592a023bc64bca938ad193794f25c7 0,0,0,0 Text31 Nr.Nota Black Expression Transparent 8.6,0.6,2,0.4 Arial,8,Bold 8ad659cb1f424fb29fa8d687a065244c 0,0,0,0 Text2 Dt.Emissão Black Expression Transparent 10.8,0.6,1.8,0.4 Arial,8,Bold 0a29cbf1d4eb430fbe131a6475eae3e8 0,0,0,0 Text3 Total Nota Black Expression Transparent 12.8,0.6,1,0.4 Arial,8,Bold 72cf8cb17a4c40c184ea4c87e1136fb5 0,0,0,0 Text4 Status Black Expression Transparent 2.2,0.6,5.2,0.4 Arial,8,Bold a25a35c6bf0a4217b91ed7145dfb6bd5 0,0,0,0 Text5 Cliente Black Expression 0,0,19,0.0254 Black cc3bc0adddb742f38a500f5e80613872 HorizontalLinePrimitive4 5b8bc3184e1b40469995aa6485fa641a GroupHeaderBand1 None None;Black;1;Dash;False;4;Black Transparent 0,5,19,1.6 Transparent 0.25,0,1.8,0.4 Arial,8 f1b96697f47248cba3ba8cdefb8470b8 0,0,0,0 Text8 {NotasEmitidas.NRNOTA} Black 000000 DataColumn Center contador++ Transparent 2.2,0,6.2,0.4 Arial,8 6af508fe3037455f849c973f11a3ab20 0,0,0,0 Text6 {NotasEmitidas.RAZAOSOCIAL} Black 00000 DataColumn Center Transparent 8.6,0,2,0.4 Arial,8 c9a869ad11e24ca193f4879ad721ed09 Center 0,0,0,0 Text10 {NotasEmitidas.DTEMISSAO.ToString("dd/MM/yyyy")} Black Expression Center Transparent 10.8,0,1.8,0.4 Arial,8 cce609d3b59049d894be4d4e7ec6fc06 Right 0,0,0,0 Text11 {NotasEmitidas.TOTAL} Black , 1 DataColumn Center Transparent 12.8,0,6,0.4 Arial,8 f061dd71ead94f5c93f87b325f1c6b62 0,0,0,0 Text12 {NotasEmitidas.DESCRICAO} Black 00000 DataColumn Center Transparent 0.2,0.6,2.8,0.4 Arial,8 0,0,0,0 Text15 Chave de acesso: Black Expression Transparent 3.4,0.6,12.8,0.4 Arial,8 0,0,0,0 Text16 {NotasEmitidas.CHAVEACESSO} Black Expression NotasEmitidas f5693694a1874b4784d674d089c27ab1 True DataBand1 False Transparent 0,7.4,19,0.6 Transparent 0.2,0.2,2.2,0.4 Arial,8,Bold f0c114e515a249c891225b7ec952e789 0,0,0,0 Text21 Qtde de Notas Black Expression Transparent 2.4,0.2,1.4,0.4 Arial,8 af1761828d5948618b008fb00357fcfb 0,0,0,0 Text22 {Count()} Black Expression Transparent 8.4,0.2,2.2,0.4 Arial,8,Bold 39f0603f06b141168791e45d13e66416 0,0,0,0 Text23 Total das Notas Black Expression Transparent 10.8,0.2,1.8,0.4 Arial,8 3184b5c01e7f4840b9bb22c0af5cca42 Right 0,0,0,0 Text24 {Sum(NotasEmitidas.TOTAL)} Black Expression 0,0,19,0.0254 Black 56f114bea6c94b0489a4788a2788665d HorizontalLinePrimitive1 0,0,19,0.0254 Black f845130f78fe461a94324d06dc31a62a HorizontalLinePrimitive2 90bd88d5f9304ee9944176f1a788d087 FooterBand1 932760d1e81c4531a00631e6aa821b69 1,1,1,1 Page1 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 Relatório 2/14/2013 11:32:01 AM 1/4/2010 10:21:40 AM 1f63f55574934921b4b5aa910333d0df Relatório Centimeters 2009.2.410 CSharp