d5cd74ea-0203-4897-b23b-608b6e7c9ee7 BAZA_REKLAM 29.7cm true 21cm 0.25cm true 1cm 1cm 2.5cm b9375294-f8e7-4520-8f81-374698915f18 21cm symbol System.String WARTOSC System.Decimal ILOSC System.Int32 srednio System.Decimal BAZA_REKLAM SELECT A.symbol, CONVERT(money, SUM(FD.NETTO)) AS WARTOSC, COUNT(distinct FD.id_faktury) AS ILOSC, CONVERT(money, SUM(FD.NETTO)) / COUNT(distinct FD.id_faktury) AS srednio FROM dbo.FAKTURY F left join FAKTURA_DETAILS FD on F.id_faktury = FD.id_faktury left join AGENCI A on F.numer_roz = A.f_roz WHERE F.numer_rok >=2009 and zaplata_data is not null GROUP BY A.[symbol] order by 2 desc true


  19cm
  
    1cm
    
      
        textbox6
        1cm
        18cm
        
        2
        true
        0.5cm
        0.63492cm
        Ranking na podstawie zapłaconych faktur od 2009 (nie uwzględnia korekt).
      
      
        0.25cm
        18cm
        
        1
        true
        0.5cm
        0.63492cm
        RANKING AGENTÓW
      
      RankingAgentow2cm18cm
          
            
              
                
                  
                    
                      SYMBOL_AKWIZYTORA
                      
                      3
                      true
                      =Fields!symbol.Value
                    
                  
                
                
                  
                    
                      WARTOSC
                      
                      2
                      true
                      =Fields!WARTOSC.Value
                    
                  
                
                
                  
                    
                      ILOSC
                      
                      1
                      true
                      =Fields!ILOSC.Value
                    
                  
                
                
                  
                    
                      srednio
                      
                      true
                      =Fields!srednio.Value
                    
                  
                
              
              0.75cm
            
          
        

          
            
              
                
                  
                    
                      textbox1
                      
                      7
                      true
                      Agent
                    
                  
                
                
                  
                    
                      textbox2
                      
                      6
                      true
                      Wartość
                    
                  
                
                
                  
                    
                      textbox3
                      
                      5
                      true
                      Ilość
                    
                  
                
                
                  
                    
                      textbox4
                      
                      4
                      true
                      Średnio
                    
                  
                
              
              0.75cm
            
          
        

          
            5.25cm
          
          
            5cm
          
          
            3.25cm
          
          
            4.5cm
          
        0.5cm
        
        
        
        
        
        
        
      
    
    3.5cm
  
  en-US
  2.5cm
  29.7cm