Conexão1 Conexão1 Equipamentos Nome,System.String nserie,System.String Marca,System.String modelo,System.String nif,System.String morada,System.String cp,System.String local,System.String ipequip,System.String datainst,System.DateTime Observacoes,System.String CodInterno,System.String LocalInterno,System.String Host,System.String Descri,System.String mes,System.Int32 ano,System.Int32 valor,System.Int32 appid,System.String Nome_tecnico,System.String model,System.String 30 Equipamentos Conexão1 select * from (select Nome,e.nserie,e.Marca,e.modelo, nif,morada,cp,local,e.ipequip,datainst,Observacoes, e.CodInterno,e.LocalInterno,e.Host,Descri,mes,ano, ifnull(Valor,0) as valor, empresas.appid from equipamentos as e,empresas,yp_desperdicio_mes as ct where (e.AppID = empresas.AppID and e.Contabiliza = 1 and e.Visivel=1 and ct.eqpId = e.eqpid and e.appID in ({param1}) and if("{val1}"='%', e.eqpid like '%', e.eqpid in ('{val1}'))) or ( e.Contabiliza = 1 and e.Visivel=1 and e.AppID = empresas.AppID and ct.eqpId = e.eqpid and e.appID in ({param1}) and if("{val1}"='%', e.eqpid like '%', e.eqpid in ('{val1}'))) ) t left join (select Nome_tecnico, nome as model from yp_modelos m ) mo on mo.Nome_tecnico=t.modelo EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.8 True Transparent 0,-0.4,5,2.2 Emp.imagem Logotipo True Transparent 5.2,0,13.8,1 Tahoma,18,Bold 0,0,0,0 Titulo Listagem de desperdícios mensais Black Expression Transparent 5,1,14,0.6 Equipamentos_x002E_Nome,IsNotNull,,,String,Red,Transparent,Arial_x002C_10,False,False,,,None Arial,10 b30ac0f41ad88412a9417915b0479571 Center 0,0,0,0 Info Não há dados a apresentar. Black Expression PageHeaderBand1 Transparent 0,26.3,19,1.4 Transparent 0,0.9,16,0.4 Letra 8 Tahoma,8 0,0,0,0 Email {Emp.rodape_report} Black DataColumn Transparent 0,0.3,19,0.4 Letra 8 Tahoma,8 0,0,0,0 Impresso em Impresso em: {Format("{0:0###}",Year(Time))}-{Format("{0:0#}",Month(Time))}-{Format("{0:0#}",Day(Time))} {Format("{0:0#}",Hour(Time))}:{Format("{0:0#}",Minute(Time))}:{Format("{0:0#}",Second(Time))} YAWPrint: {Emp.Versao} Black Expression Transparent 16,0.9,3,0.4 Letra 8 Tahoma,8 Right 0,0,0,0 N Páginas {PageNofM} Black PageFooterBand1 Transparent 35.2,4,1.6,0.6 Arial,10 0,0,0,0 Text19 {Column} Black Transparent 32.4,4,2.8,0.6 Arial,10 0,0,0,0 Text23 Column Black Transparent 0,3,19,0.6 None;Transparent;1;Solid;False;4;Black Transparent 0,0.2,19,0.6 Tahoma,9,Bold d88c1bf8d9d6f32b0187a510da0e8101 0,0,0,0 Cliente Cliente : {Equipamentos.Nome} RoyalBlue Expression {Equipamentos.Nome} 03c72da9647f76022433a510da0e767c GroupHeaderBand2 False None Transparent False 0,4.4,19,0.6 Transparent 1.6,0,3.4,0.6 Tahoma,8 0,0,0,0 Mes - Ano {IIF(Equipamentos.mes==1,"Janeiro",IIF(Equipamentos.mes==2,"Fevereiro",IIF(Equipamentos.mes==3,"Março",IIF(Equipamentos.mes==4,"Abril",IIF(Equipamentos.mes==5,"Maio",IIF(Equipamentos.mes==6,"Junho",IIF(Equipamentos.mes==7,"Julho",IIF(Equipamentos.mes==8,"Agosto",IIF(Equipamentos.mes==9,"Setembro",IIF(Equipamentos.mes==10,"Outubro",IIF(Equipamentos.mes==11,"Novembro",IIF(Equipamentos.mes==12,"Dezembro",Equipamentos.mes))))))))))))} - {Equipamentos.ano} Black Expression {Equipamentos.mes} GroupHeaderBand1 False None Transparent 0,5.8,19,2 All;Black;1;Solid;False;4;Black Transparent 8,0.6,1.6,0.6 Tahoma,6 e558a03f488a8e492c9fa504ce947f56 Center DataBand1.Marca 0,0,0,0 Marca Marca Black Expression Center All;Black;1;Solid;False;4;Black Transparent 16.8,0.6,1.6,0.6 Tahoma,6 9ee9ebcb9d8915d5a75fa504ce9452f9 Center DataBand1.valor 0,0,0,0 Valor (%) Valor (%) Black Expression Center All;Black;1;Solid;False;4;Black Transparent 6,0.6,2,0.6 Tahoma,6 abb66f678b30c62845d9a504ce9491f3 Center DataBand1.LocalInterno 0,0,0,0 Cod Interno Cod Interno Black Expression Center All;Black;1;Solid;False;4;Black Transparent 11.8,0.6,2.8,0.6 Tahoma,6 41c027bea3ed666b1f5fa504ce94b1ff Center DataBand1.Host 0,0,0,0 Host Host Black Expression Center All;Black;1;Solid;False;4;Black Transparent 9.6,0.6,2.2,0.6 Tahoma,6 e84f0e7bf178c04f0260a504ce946230 Center DataBand1.LocalInterno 0,0,0,0 Local Interno Local Interno Black Expression Center All;Black;1;Solid;False;4;Black Transparent 14.6,0.6,2.2,0.6 Tahoma,6 59d55f6d4f8d75644812a504ce94861b Center DataBand1.Descri 0,0,0,0 Tipo Comsumível Tipo Comsumível Black Expression Center All;Black;1;Solid;False;4;Black Transparent 4,0.6,2,0.6 Tahoma,6 04a47513a063dbbd7a68a504ce94ad5d Center DataBand1.nserie 0,0,0,0 NºSérie NºSérie Black Expression Center None;Transparent;1;Solid;False;4;Black Transparent 4,0,15,0.6 Tahoma,8 db7c521e0a87773774baa52a72964888 0,0,0,0 Modelo {Equipamentos.Marca} - {Equipamentos.model} RoyalBlue Expression Left, Right, Bottom;Black;1;Solid;False;4;Black Transparent 4,1.2,2,0.6 Tahoma,6 Center 0,0,0,0 Nserie {Equipamentos.nserie} Black Center Left, Bottom;Black;1;Solid;False;4;Black Transparent 8,1.2,1.6,0.6 Tahoma,6 Center 0,0,0,0 Marca {Equipamentos.Marca} Black Center Left, Bottom;Black;1;Solid;False;4;Black Transparent 6,1.2,2,0.6 Tahoma,6 Center 0,0,0,0 Cod Interno {Equipamentos.CodInterno} Black Center Left, Right, Bottom;Black;1;Solid;False;4;Black Transparent 11.8,1.2,2.8,0.6 Tahoma,6 Center 0,0,0,0 Host {Equipamentos.Host} Black Center Left, Bottom;Black;1;Solid;False;4;Black Transparent 9.6,1.2,2.2,0.6 Tahoma,6 Center 0,0,0,0 Local Interno {Equipamentos.LocalInterno} Black Center {Equipamentos.nserie} GroupHeaderBand3 False None Transparent False 0,8.6,19,0.8 Top, Left, Bottom;Black;1;Solid;False;4;Black Transparent 16.8,0,1.2,0.6 Tahoma,6 c90a2d1b6f7c81d997a0153d99005fed Right 0,0,0,0 Valor (%) 0 {Equipamentos.valor} Black , . 1 False DataColumn Center Top, Left, Bottom;Black;1;Solid;False;4;Black Transparent 14.6,0,2.2,0.6 Tahoma,6 Center 0,0,0,0 Tipo Comsumível {Equipamentos.Descri} Black Center <_x0025_ isKey="true" type="Text" Ref="44"> Top, Right, Bottom;Black;1;Solid;False;4;Black Transparent 18,0,0.4,0.6 Tahoma,6 a007d4ff74fa24df3c96b4c73ce4ef80 0,0,0,0 % % Black Expression Center Transparent 0,0,0.2,0.6 Arial,10 013bf9dadbfcc0d6ab4803ce04956f8c 0,0,0,0 Cliente {Equipamentos.Nome} [255:255:255] Transparent 0.2,0,0.2,0.6 Arial,10 2ee42ebff9679901a70d03ce0495dcf6 0,0,0,0 Nº Cliente {Equipamentos.appid} [255:255:255] Transparent 0.4,0,0.2,0.6 Arial,10 9801c1eb6d54694f908903ce0495956d 0,0,0,0 Nº Série {Equipamentos.nserie} [255:255:255] Transparent 0.6,0,0.2,0.6 Arial,10 09dfd17f561da56005ca03ce04953f2a 0,0,0,0 Código Interno {Equipamentos.CodInterno} [255:255:255] Transparent 0.8,0,0.2,0.6 Arial,10 4a69d9af15075f64b0e403ce04954538 0,0,0,0 Marca {Equipamentos.Marca} [255:255:255] Transparent 1,0,0.2,0.6 Arial,10 4d6c584e8b36bf1389cb03ce049561a7 0,0,0,0 Modelo {Equipamentos.model} [255:255:255] DataColumn Transparent 1.4,0,0.2,0.6 Arial,10 b7be991d89a4851a40a603ce0495b925 0,0,0,0 Host {Equipamentos.Host} [255:255:255] Transparent 1.8,0,0.2,0.6 Arial,10 4e7419e9aa22218c56db03ce04959aa0 0,0,0,0 Mês {Equipamentos.mes} [255:255:255] Transparent 1.6,0,0.2,0.6 Arial,10 26a260af91c6fac5823b03ce04955232 0,0,0,0 Ano {Equipamentos.ano} [255:255:255] Transparent 1.2,0,0.2,0.6 Arial,10 aaad9f2ad6c619d5884003ce0495b14f 0,0,0,0 Local Interno {Equipamentos.LocalInterno} [255:255:255] Equipamentos False _x007B_Equipamentos_x002E_Nome_x0020__x003D__x003D__x0020_Empresa_x0020__x007C__x007C__x0020_all_emp_x007D_ _x007B_Equipamentos_x002E_Marca_x0020__x003D__x003D__x0020_Marca_x0020__x007C__x007C__x0020_all_equip_x007D_ True DataBand1 False DESC ano DESC mes Transparent 0,10.2,19,0.8 Transparent 14.6,0,2.2,0.6 Tahoma,6 067012b4a19c5d65c4cfa19ace850725 Center 0,0,0,0 Total Desperdicios: Total Desperdicios: Black Expression Center Transparent 5.6,0,0.8,0.6 Tahoma,6 Right 0,0,0,0 Desperdicio Preto: {Sum(IIF(Equipamentos.Descri=="Toner Preto",Equipamentos.Valor,0))} Black , . 1 False Expression Center Transparent 6.8,0,2.8,0.6 Tahoma,6 0b3a089844472f7a1774a54543d65bc9 Right 0,0,0,0 Desperdicio Cor: Desperdicio Cor: Black Expression Center Transparent 16.8,0,1.2,0.6 Tahoma,6 48ec34b397c07415a347a545e217d267 Right 0,0,0,0 Total Desperdicios: {Sum(Equipamentos.Valor)} % Black , . 1 False Expression Center <_x0025_ isKey="true" type="Text" Ref="62"> Transparent 18,0,0.4,0.6 Tahoma,6 1f1e42e7aa4817a51625b4c6e639124b 0,0,0,0 % % Black Expression Center Transparent 9.6,0,0.8,0.6 Tahoma,6 c6832aaf48232d5bc717b4e3bb52a523 Right 0,0,0,0 Desperdicio Cor: {Sum(IIF(Equipamentos.Descri=="Toner Cyan",Equipamentos.Valor, IIF(Equipamentos.Descri=="Toner Magenta",Equipamentos.Valor, IIF(Equipamentos.Descri=="Toner Amarelo",Equipamentos.Valor,0))))} Black , . 1 False Expression Center <_x0025_ isKey="true" type="Text" Ref="65"> Transparent 10.4,0,0.4,0.6 Tahoma,6 9fe547969c375c3557a8b4e3ef47e013 0,0,0,0 % % Black Expression Center Transparent 2.8,0,2.8,0.6 Tahoma,6 02300ea228e5f74cecaab4e4c37abeca Right 0,0,0,0 Desperdicio Preto: Desperdicio Preto: Black Expression Center <_x0025_ isKey="true" type="Text" Ref="67"> Transparent 6.4,0,0.4,0.6 Tahoma,6 a1a5f99b4c7316fda48eb4e4f745cc8e 0,0,0,0 % % Black Expression Center 4,0,14.4,0.0254 Black Black HorizontalLinePrimitive2 Black GroupFooterBand1 False Transparent 0,11.8,19,0.8 Transparent 14.4,0,2.4,0.6 Tahoma,6,Bold c36eb52916abdca47597a52d0184d991 Center 0,0,0,0 Média de Desperdício Média de Desperdicio: Black Expression Center Transparent 5.4,0,1,0.6 Tahoma,6,Bold fd4333966df395302973a545869ae58a Right 0,0,0,0 Media do total de desperdicio preto {Sum(IIF(Equipamentos.Descri=="Toner Preto",Equipamentos.Valor,0))/cCountIf(Equipamentos.Descri=="Toner Preto")} Black , . 1 False Expression Center Transparent 10.8,0,1,0.6 Tahoma,6,Bold 8358b73e552e4bc19873a545869a40be Right 0,0,0,0 Media do total de desperdidico cor {Sum(IIF(Equipamentos.Descri=="Toner Cyan",Equipamentos.Valor, IIF(Equipamentos.Descri=="Toner Magenta",Equipamentos.Valor, IIF(Equipamentos.Descri=="Toner Amarelo",Equipamentos.Valor,0))))/Count()} Black , . 1 False Expression Center <_x0025_ isKey="true" type="Text" Ref="77"> Transparent 18,0,0.4,0.6 Tahoma,6,Bold 0,0,0,0 % % Black Expression Center Transparent 16.8,0,1.2,0.6 Tahoma,6,Bold 10ff84635a49bf29ce00a5464466bfe0 Right 0,0,0,0 Media de desperdicio {Round(Sum(Equipamentos.Valor)/Count(),2)} Black , . 1 False Expression Center <_x0025_ isKey="true" type="Text" Ref="80"> Transparent 6.4,0,0.4,0.6 Tahoma,6,Bold c3676a57b87bd0c98415b4dfc0909075 0,0,0,0 % % Black Expression Center <_x0025_ isKey="true" type="Text" Ref="81"> Transparent 11.8,0,0.4,0.6 Tahoma,6,Bold 0ed05368fe9ed3416355b4dfceb92ba3 0,0,0,0 % % Black Expression Center Transparent 1.6,0,3.8,0.6 Tahoma,6,Bold 48cec565de0d72d01e69b4e10f5d533b Right 0,0,0,0 Média do Total de Desperdício Preto Média do total desperdicio Preto: Black , . 1 False Expression Center Transparent 7.4,0,3.4,0.6 Tahoma,6,Bold f4fe2e9324874505df53b4e190cb57b7 Right 0,0,0,0 Média Total de Desperdício Cor Médi total de desperdicio Cor: Black Expression Center 0,0,19,0.0254 Black Black HorizontalLinePrimitive1 Black GroupFooterBand2 False Transparent 0,13.4,19,0.8 Transparent 14.4,0,2.4,0.6 Tahoma,6,Bold 380d02463ed4e99c9ca903d72ec9d7d8 Center 0,0,0,0 Text20 Média de Desperdicio: Black Expression Center Transparent 5.4,0,1,0.6 Tahoma,6,Bold 4eb3280bc5d0f857edd403d72ec981a3 Right 0,0,0,0 Text5 {Sum(IIF(Equipamentos.Descri=="Toner Preto",Equipamentos.Valor,0))/CountIf(Equipamentos.Descri=="Toner Preto")} Black , . 1 False Expression Center Transparent 10.8,0,1,0.6 Tahoma,6,Bold 36b844ad2ea51bfdb3a603d72ec9c52d Right 0,0,0,0 Text12 {Sum(IIF(Equipamentos.Descri=="Toner Cor",Equipamentos.Valor,0))/Count()} Black , . 1 False Expression Center Transparent 18,0,0.4,0.6 Tahoma,6,Bold 3cfbc0a387a0d8aab0a903d72ec9cb2a 0,0,0,0 Text13 % Black Expression Center Transparent 16.8,0,1.2,0.6 Tahoma,6,Bold 3dc72143834fbc9d241103d72ec9cb34 Right 0,0,0,0 Text14 {Round(Sum(Equipamentos.Valor)/Count(),2)} Black , . 1 False Expression Center Transparent 6.4,0,0.4,0.6 Tahoma,6,Bold 6885002104312a579db003d72ec91481 0,0,0,0 Text15 {CountIf(Equipamentos.Descri=="Toner Preto")} Black Expression Center Transparent 1.6,0,3.8,0.6 Tahoma,6,Bold 9c61f87c4b6d8cb4ee7f03d72ec9a436 Right 0,0,0,0 Text17 Média do total desperdicio Preto: Black , . 1 False Expression Center Transparent 7.4,0,3.4,0.6 Tahoma,6,Bold 60f808b1a4e8f76daad703d72ec9a872 Right 0,0,0,0 Text18 Médi total de desperdicio Cor: Black Expression Center 0,0,19,0.0254 Black Black c2e71c33e69af3a4dbba03d72ec970aa HorizontalLinePrimitive4 Black ReportSummaryBand1 125174a89253cfd6a72510c140cfa94d 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Desperdícios mensais Mário Ferreira 09/07/2016 11:11:11 AM 11/16/2015 02:44:39 PM 03_007 C:\Users\sara.nogueira\OneDrive - Beltrão Coelho\Desktop\example.mrt a5587298934bcd2d502304210ea4cc2b Desperdícios mensais Centimeters 2016.1.17 CSharp Transparent Tahoma,6 Letra 6 Black Transparent Tahoma,8 Letra 8 Black