Index: trunk/RaportySQL/RankingKlientow2009.rdl
===================================================================
--- trunk/RaportySQL/RankingKlientow2009.rdl (revision 185)
+++ trunk/RaportySQL/RankingKlientow2009.rdl (revision 222)
@@ -76,8 +76,4 @@
           <rd:TypeName>System.Decimal</rd:TypeName>
         </Field>
-        <Field Name="ILOSC">
-          <DataField>ILOSC</DataField>
-          <rd:TypeName>System.Int32</rd:TypeName>
-        </Field>
         <Field Name="symbol">
           <DataField>Symbol</DataField>
@@ -111,8 +107,8 @@
       <Query>
         <DataSourceName>BAZA_REKLAM</DataSourceName>
-        <CommandText>SELECT     K.FirstName, K.LastName, CONVERT(money, SUM(FD.NETTO)) AS WARTOSC, COUNT(DISTINCT FD.reklamaId) AS ILOSC, A1.Symbol, 
-                      YEAR(F.DATA_WYSTAWIENIA) AS rok, A2.Symbol AS agencja
+        <CommandText>SELECT     K.FirstName, K.LastName, CONVERT(money, SUM(FD.netto)) AS WARTOSC, A1.Symbol, YEAR(F.DATA_WYSTAWIENIA) AS rok, 
+                      A2.Symbol AS agencja
 FROM         FAKTURY AS F LEFT OUTER JOIN
-                      FAKTURA_DETAILS AS FD ON F.ID_FAKTURY = FD.ID_FAKTURY LEFT OUTER JOIN
+                      VIEW_BRUTTO_PO_KOREKTACH AS FD ON F.ID_FAKTURY = FD.id_faktury LEFT OUTER JOIN
                       KLIENCI AS K ON F.ID_NABYWCY = K.CustomerID INNER JOIN
                       AGENCI AS A1 ON F.NUMER_ROZ = A1.F_ROZ INNER JOIN
@@ -120,5 +116,5 @@
 WHERE     (F.NUMER_ROZ &lt;&gt; 'POZ') AND (F.NUMER_ROZ &lt;&gt; 'KAT') AND (YEAR(F.DATA_WYSTAWIENIA) &gt; 2008)
 GROUP BY K.FirstName, K.LastName, A1.Symbol, YEAR(F.DATA_WYSTAWIENIA), A2.Symbol
-ORDER BY CONVERT(money, SUM(FD.NETTO)) DESC</CommandText>
+ORDER BY CONVERT(money, SUM(FD.netto)) DESC</CommandText>
       </Query>
     </DataSet>
@@ -216,5 +212,5 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>5</ZIndex>
+                      <ZIndex>4</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>=Fields!FirstName.Value</Value>
@@ -244,5 +240,5 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>4</ZIndex>
+                      <ZIndex>3</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>=Fields!Lastname.Value</Value>
@@ -274,35 +270,7 @@
                         <Language>pl</Language>
                       </Style>
-                      <ZIndex>3</ZIndex>
+                      <ZIndex>2</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>=Fields!WARTOSC.Value</Value>
-                    </Textbox>
-                  </ReportItems>
-                </TableCell>
-                <TableCell>
-                  <ReportItems>
-                    <Textbox Name="ILOSC">
-                      <rd:DefaultName>ILOSC</rd:DefaultName>
-                      <Style>
-                        <BorderColor>
-                          <Default>LightGrey</Default>
-                        </BorderColor>
-                        <BorderStyle>
-                          <Default>Solid</Default>
-                        </BorderStyle>
-                        <BorderWidth>
-                          <Default>0.5pt</Default>
-                        </BorderWidth>
-                        <FontSize>8pt</FontSize>
-                        <TextAlign>Center</TextAlign>
-                        <VerticalAlign>Middle</VerticalAlign>
-                        <PaddingLeft>2pt</PaddingLeft>
-                        <PaddingRight>2pt</PaddingRight>
-                        <PaddingTop>2pt</PaddingTop>
-                        <PaddingBottom>2pt</PaddingBottom>
-                      </Style>
-                      <ZIndex>2</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>=Fields!ILOSC.Value</Value>
                     </Textbox>
                   </ReportItems>
@@ -396,5 +364,5 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>10</ZIndex>
+                      <ZIndex>8</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>KLIENT</Value>
@@ -426,37 +394,7 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>9</ZIndex>
+                      <ZIndex>7</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>WARTOŚĆ</Value>
-                    </Textbox>
-                  </ReportItems>
-                </TableCell>
-                <TableCell>
-                  <ReportItems>
-                    <Textbox Name="textbox11">
-                      <rd:DefaultName>textbox11</rd:DefaultName>
-                      <Style>
-                        <BackgroundColor>WhiteSmoke</BackgroundColor>
-                        <BorderColor>
-                          <Default>LightGrey</Default>
-                        </BorderColor>
-                        <BorderStyle>
-                          <Default>Solid</Default>
-                        </BorderStyle>
-                        <BorderWidth>
-                          <Default>0.5pt</Default>
-                        </BorderWidth>
-                        <FontSize>8pt</FontSize>
-                        <FontWeight>700</FontWeight>
-                        <TextAlign>Center</TextAlign>
-                        <VerticalAlign>Middle</VerticalAlign>
-                        <PaddingLeft>2pt</PaddingLeft>
-                        <PaddingRight>2pt</PaddingRight>
-                        <PaddingTop>2pt</PaddingTop>
-                        <PaddingBottom>2pt</PaddingBottom>
-                      </Style>
-                      <ZIndex>8</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>ILOŚĆ</Value>
                     </Textbox>
                   </ReportItems>
@@ -486,5 +424,5 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>7</ZIndex>
+                      <ZIndex>6</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>AGENT</Value>
@@ -516,5 +454,5 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>6</ZIndex>
+                      <ZIndex>5</ZIndex>
                       <CanGrow>true</CanGrow>
                       <Value>AGENCJA</Value>
@@ -529,14 +467,11 @@
         <TableColumns>
           <TableColumn>
-            <Width>4cm</Width>
+            <Width>5cm</Width>
           </TableColumn>
           <TableColumn>
-            <Width>3.75cm</Width>
+            <Width>4.5cm</Width>
           </TableColumn>
           <TableColumn>
-            <Width>2.5cm</Width>
-          </TableColumn>
-          <TableColumn>
-            <Width>2.5cm</Width>
+            <Width>3.25cm</Width>
           </TableColumn>
           <TableColumn>