Index: trunk/RaportySQL/RankingKlientow.rdl
===================================================================
--- trunk/RaportySQL/RankingKlientow.rdl (revision 130)
+++ trunk/RaportySQL/RankingKlientow.rdl (revision 145)
@@ -112,10 +112,11 @@
         <DataSourceName>BAZA_REKLAM</DataSourceName>
         <CommandText>SELECT     K.FirstName, K.LastName, CONVERT(money, SUM(R.NETTO)) AS WARTOSC, COUNT(*) AS ILOSC, R.[SYMBOL AKWIZYTORA], 
-                      YEAR(r.[data zamówienia]) AS rok, A2.Symbol
+                      YEAR(R.[FAKTURA DATA WYSTAWIENIA]) AS rok, A2.Symbol
 FROM         REKLAMA AS R INNER JOIN
                       KLIENCI AS K ON R.CustomerID = K.CustomerID INNER JOIN
                       AGENCI AS A1 ON R.[SYMBOL AKWIZYTORA] = A1.Symbol INNER JOIN
                       AGENCJE AS A2 ON A1.ID_AGENCJI = A2.Id_agencji
-GROUP BY K.FirstName, K.LastName, R.[SYMBOL AKWIZYTORA], YEAR(r.[data zamówienia]), A2.Symbol, R.[ZATWIERDZONO DO DRUKU]
+GROUP BY K.FirstName, K.LastName, R.[SYMBOL AKWIZYTORA], YEAR(R.[FAKTURA DATA WYSTAWIENIA]), A2.Symbol, 
+                      R.[ZATWIERDZONO DO DRUKU]
 HAVING      (ABS(R.[ZATWIERDZONO DO DRUKU]) = 1)
 ORDER BY CONVERT(money, SUM(R.NETTO)) DESC</CommandText>
@@ -154,5 +155,5 @@
       <Query>
         <DataSourceName>BAZA_REKLAM</DataSourceName>
-        <CommandText>select distinct(year([data zamówienia])) from reklama where [data zamówienia] is not null order by year([data zamówienia]) desc</CommandText>
+        <CommandText>select distinct(year([data zamówienia])) from reklama where [data zamówienia] is not null and year([data zamówienia])&lt;=2008 order by year([data zamówienia]) desc</CommandText>
         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
       </Query>
@@ -164,8 +165,28 @@
     <ColumnSpacing>1cm</ColumnSpacing>
     <ReportItems>
+      <Textbox Name="textbox6">
+        <rd:DefaultName>textbox6</rd:DefaultName>
+        <Top>0.75cm</Top>
+        <Width>18cm</Width>
+        <Style>
+          <Color>Red</Color>
+          <FontSize>8pt</FontSize>
+          <FontWeight>700</FontWeight>
+          <TextAlign>Center</TextAlign>
+          <PaddingLeft>2pt</PaddingLeft>
+          <PaddingRight>2pt</PaddingRight>
+          <PaddingTop>2pt</PaddingTop>
+          <PaddingBottom>2pt</PaddingBottom>
+        </Style>
+        <ZIndex>2</ZIndex>
+        <CanGrow>true</CanGrow>
+        <Left>0.5cm</Left>
+        <Height>0.5cm</Height>
+        <Value>Raport na podstawie reklam do roku 2008.</Value>
+      </Textbox>
       <Table Name="table1">
         <ZIndex>1</ZIndex>
         <DataSetName>RankingKlientow</DataSetName>
-        <Top>0.75cm</Top>
+        <Top>1.25cm</Top>
         <Width>18cm</Width>
         <Details>
@@ -543,8 +564,8 @@
         <Left>0.5cm</Left>
         <Height>0.63492cm</Height>
-        <Value>RANKING KLIENTÓW</Value>
+        <Value>RANKING KLIENTÓW - wg daty wystawienia faktury </Value>
       </Textbox>
     </ReportItems>
-    <Height>2.01984cm</Height>
+    <Height>2.51984cm</Height>
   </Body>
   <Language>en-US</Language>