Index: /trunk/RaportySQL/TESTOWA.rds
===================================================================
--- /trunk/RaportySQL/TESTOWA.rds (revision 130)
+++ /trunk/RaportySQL/TESTOWA.rds (revision 389)
@@ -5,5 +5,5 @@
   <ConnectionProperties>
     <Extension>SQL</Extension>
-    <ConnectString>Data Source=10.0.0.21;Initial Catalog=BAZA_REKLAM_TEST</ConnectString>
+    <ConnectString>Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST</ConnectString>
     <Prompt>Specify a user name and password for data source TESTOWA</Prompt>
   </ConnectionProperties>
Index: /trunk/RaportySQL/RaportySQL.rptproj
===================================================================
--- /trunk/RaportySQL/RaportySQL.rptproj (revision 384)
+++ /trunk/RaportySQL/RaportySQL.rptproj (revision 389)
@@ -4,11 +4,11 @@
   <DataSources>
     <ProjectItem>
+      <Name>TESTOWA.rds</Name>
+      <FullPath>TESTOWA.rds</FullPath>
+    </ProjectItem>
+    <ProjectItem>
       <Name>BAZA_REKLAM.rds</Name>
       <FullPath>BAZA_REKLAM.rds</FullPath>
     </ProjectItem>
-    <ProjectItem>
-      <Name>TESTOWA.rds</Name>
-      <FullPath>TESTOWA.rds</FullPath>
-    </ProjectItem>
   </DataSources>
   <Reports>
@@ -138,4 +138,8 @@
     </ProjectItem>
     <ProjectItem>
+      <Name>PowierzchniaReklamWykres.rdl</Name>
+      <FullPath>PowierzchniaReklamWykres.rdl</FullPath>
+    </ProjectItem>
+    <ProjectItem>
       <Name>PowtorzeniaEmisji.rdl</Name>
       <FullPath>PowtorzeniaEmisji.rdl</FullPath>
@@ -392,8 +396,4 @@
       <Name>ZmianyEmisjiWgSymbolu.rdl</Name>
       <FullPath>ZmianyEmisjiWgSymbolu.rdl</FullPath>
-    </ProjectItem>
-    <ProjectItem>
-      <Name>PowierzchniaReklamWykres.rdl</Name>
-      <FullPath>PowierzchniaReklamWykres.rdl</FullPath>
     </ProjectItem>
   </Reports>
@@ -413,5 +413,5 @@
       <Platform>Win32</Platform>
       <Options>
-        <TargetServerURL>http://10.0.0.39/ReportServer/</TargetServerURL>
+        <TargetServerURL>http://reports.ct.com.pl/ReportServer/</TargetServerURL>
         <TargetFolder>Zestawienia</TargetFolder>
         <TargetDataSourceFolder>Data Sources</TargetDataSourceFolder>
Index: /trunk/RaportySQL/SzacowanieSprzedazy.rdl
===================================================================
--- /trunk/RaportySQL/SzacowanieSprzedazy.rdl (revision 365)
+++ /trunk/RaportySQL/SzacowanieSprzedazy.rdl (revision 389)
@@ -178,4 +178,10 @@
 )
 
+IF @agencja='Wszystkie'
+	BEGIN	
+	INSERT INTO @Agents(symbol)
+	SELECT symbol FROM AGENCI WHERE aktywny=1
+	END
+
 
 SELECT
@@ -279,4 +285,7 @@
 R.[symbol akwizytora], R.ReklamaID, K.kodKlienta, Z.idZamowienia, Z.nrZamowienia, Z.kodAgenta, Z.rokZamowienia, R.[ID Reklamy], R.wyroznienie, R.wyroznienie_procent</CommandText>
         <QueryParameters>
+          <QueryParameter Name="@agencja">
+            <Value>=Parameters!agencja.Value</Value>
+          </QueryParameter>
           <QueryParameter Name="@ms">
             <Value>=Parameters!ms.Value</Value>
Index: /unk/RaportySQL/BAZA_REKLAM.rds
===================================================================
--- /trunk/RaportySQL/BAZA_REKLAM.rds (revision 130)
+++  (revision )
@@ -1,10 +1,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-<RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
-  <Name>BAZA_REKLAM</Name>
-  <DataSourceID>0c620d39-5aea-4ba1-af63-a1a0043d42bb</DataSourceID>
-  <ConnectionProperties>
-    <Extension>SQL</Extension>
-    <ConnectString>Data Source=10.0.0.21;Initial Catalog=BAZA_REKLAM</ConnectString>
-    <Prompt>Specify a user name and password for data source BAZA_REKLAM</Prompt>
-  </ConnectionProperties>
-</RptDataSource>