Index: /trunk/RaportySQL/SredniaCenaModulow.rdl
===================================================================
--- /trunk/RaportySQL/SredniaCenaModulow.rdl (revision 575)
+++ /trunk/RaportySQL/SredniaCenaModulow.rdl (revision 577)
@@ -3,5 +3,5 @@
   <DataSources>
     <DataSource Name="BAZA_REKLAM">
-      <rd:DataSourceID>7a3117ba-2e48-4045-91d5-12c8618a9930</rd:DataSourceID>
+      <rd:DataSourceID>893127e7-8b81-4d0c-b3a0-62f6e68d3b2b</rd:DataSourceID>
       <DataSourceReference>BAZA_REKLAM</DataSourceReference>
     </DataSource>
@@ -10,5 +10,5 @@
   <ReportParameters>
     <ReportParameter Name="year">
-      <DataType>String</DataType>
+      <DataType>Integer</DataType>
       <DefaultValue>
         <Values>
@@ -16,15 +16,14 @@
         </Values>
       </DefaultValue>
-      <AllowBlank>true</AllowBlank>
       <Prompt>Rok:</Prompt>
       <ValidValues>
         <DataSetReference>
           <DataSetName>ListaLat</DataSetName>
-          <ValueField>rok</ValueField>
-          <LabelField>rok</LabelField>
+          <ValueField>Rok</ValueField>
+          <LabelField>Rok</LabelField>
         </DataSetReference>
       </ValidValues>
     </ReportParameter>
-    <ReportParameter Name="month">
+    <ReportParameter Name="months">
       <DataType>String</DataType>
       <DefaultValue>
@@ -33,5 +32,5 @@
         </Values>
       </DefaultValue>
-      <Prompt>Miesiąc:</Prompt>
+      <Prompt>Miesiąc(e):</Prompt>
       <ValidValues>
         <ParameterValues>
@@ -71,29 +70,4 @@
           <ParameterValue>
             <Value>12</Value>
-          </ParameterValue>
-        </ParameterValues>
-      </ValidValues>
-      <MultiValue>true</MultiValue>
-    </ReportParameter>
-    <ReportParameter Name="title">
-      <DataType>String</DataType>
-      <DefaultValue>
-        <Values>
-          <Value>AMT</Value>
-          <Value>GS</Value>
-          <Value>adMot</Value>
-        </Values>
-      </DefaultValue>
-      <Prompt>Tytuł:</Prompt>
-      <ValidValues>
-        <ParameterValues>
-          <ParameterValue>
-            <Value>AMT</Value>
-          </ParameterValue>
-          <ParameterValue>
-            <Value>GS</Value>
-          </ParameterValue>
-          <ParameterValue>
-            <Value>adMot</Value>
           </ParameterValue>
         </ParameterValues>
@@ -109,9 +83,13 @@
   <LeftMargin>2.5cm</LeftMargin>
   <BottomMargin>2.5cm</BottomMargin>
-  <rd:ReportID>cddaaabe-22d1-4745-812e-083e6fb21360</rd:ReportID>
+  <rd:ReportID>d657e215-97e8-4e12-9b89-3d580817eec0</rd:ReportID>
   <PageWidth>21cm</PageWidth>
   <DataSets>
     <DataSet Name="Moduly">
       <Fields>
+        <Field Name="Agencja">
+          <DataField>Agencja</DataField>
+          <rd:TypeName>System.String</rd:TypeName>
+        </Field>
         <Field Name="Agent">
           <DataField>Agent</DataField>
@@ -121,4 +99,16 @@
           <DataField>Modul</DataField>
           <rd:TypeName>System.String</rd:TypeName>
+        </Field>
+        <Field Name="SumaNetto">
+          <DataField>SumaNetto</DataField>
+          <rd:TypeName>System.Decimal</rd:TypeName>
+        </Field>
+        <Field Name="IloscReklam">
+          <DataField>IloscReklam</DataField>
+          <rd:TypeName>System.Int32</rd:TypeName>
+        </Field>
+        <Field Name="IloscEmisji">
+          <DataField>IloscEmisji</DataField>
+          <rd:TypeName>System.Int32</rd:TypeName>
         </Field>
         <Field Name="Sprzedano">
@@ -134,6 +124,10 @@
         <DataSourceName>BAZA_REKLAM</DataSourceName>
         <CommandText>SELECT 
+Ag.Symbol AS Agencja,  
 LOWER(A.Symbol) AS Agent, 
 M.Mod_Typ AS Modul, 
+CAST(SUM(U.netto) AS DECIMAL(9,2)) AS SumaNetto,
+COUNT(DISTINCT R.ReklamaId) AS IloscReklam,
+COUNT(U.ID) AS IloscEmisji,
 CAST(SUM(((R.[Cena Jedn] - R.[Rabat Wartość]) * R.[Krotność]) / (R.Szer * R.Wys * R.[Krotność]))/Count(R.ReklamaId) AS DECIMAL(9,2)) AS Sprzedano, 
 CAST(SUM(M.Cena)/Count(R.ReklamaId) AS DECIMAL(9,2)) AS Cennik
@@ -144,20 +138,20 @@
 INNER JOIN Faktury F ON F.ID_Faktury = U.idFaktury
 INNER JOIN Agenci A ON F.Numer_Roz=A.F_Roz
-WHERE R.[TYTUŁ] IN (@title)
+INNER JOIN Agencje Ag ON Ag.Id_Agencji=A.Id_Agencji
+WHERE R.[TYTUŁ] IN ('AMT')
 AND R.Typ='PŁATNA' 
 AND YEAR(F.[DATA_SPRZEDAZY])=@year
-AND MONTH(F.[DATA_SPRZEDAZY]) IN (@month)
+AND MONTH(F.[DATA_SPRZEDAZY]) IN (@months)
 AND U.idFaktury IS NOT NULL
-GROUP BY A.Symbol, M.Mod_Typ
-ORDER BY A.Symbol, M.Mod_Typ</CommandText>
+AND U.status = 0
+AND M.Mod_Typ IN ('AWEB', 'AWEF', 'AWES')
+GROUP BY Ag.Symbol, A.Symbol, M.Mod_Typ
+ORDER BY Ag.Symbol, A.Symbol, M.Mod_Typ</CommandText>
         <QueryParameters>
-          <QueryParameter Name="@title">
-            <Value>=Parameters!title.Value</Value>
-          </QueryParameter>
           <QueryParameter Name="@year">
             <Value>=Parameters!year.Value</Value>
           </QueryParameter>
-          <QueryParameter Name="@month">
-            <Value>=Parameters!month.Value</Value>
+          <QueryParameter Name="@months">
+            <Value>=Parameters!months.Value</Value>
           </QueryParameter>
         </QueryParameters>
@@ -167,6 +161,6 @@
     <DataSet Name="ListaLat">
       <Fields>
-        <Field Name="rok">
-          <DataField>rok</DataField>
+        <Field Name="Rok">
+          <DataField>Rok</DataField>
           <rd:TypeName>System.Int32</rd:TypeName>
         </Field>
@@ -174,5 +168,9 @@
       <Query>
         <DataSourceName>BAZA_REKLAM</DataSourceName>
-        <CommandText>select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null AND year(DATA_W)&gt;2008 order by year(DATA_W) desc</CommandText>
+        <CommandText>SELECT DISTINCT YEAR(DATA_W) AS Rok 
+FROM dbo.NR 
+WHERE DATA_W IS NOT NULL 
+AND YEAR(DATA_W)&gt;2008 
+ORDER BY year(DATA_W) DESC</CommandText>
         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
       </Query>
@@ -188,30 +186,13 @@
   Return s
 End Function</Code>
-  <Width>13.45cm</Width>
+  <Width>19.73808cm</Width>
   <Body>
     <ColumnSpacing>1cm</ColumnSpacing>
     <ReportItems>
-      <Textbox Name="textbox8">
-        <Top>0.75cm</Top>
-        <Width>13.25cm</Width>
-        <Style>
-          <FontSize>12pt</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>
-        <Height>0.75cm</Height>
-        <Value>="Tytuł(y): " + Code.GetMonths(Parameters!title)</Value>
-      </Textbox>
       <Textbox Name="textbox1">
         <rd:DefaultName>textbox1</rd:DefaultName>
-        <Width>13.25cm</Width>
+        <Width>19.5cm</Width>
         <Style>
-          <FontSize>12pt</FontSize>
+          <FontSize>14pt</FontSize>
           <FontWeight>700</FontWeight>
           <TextAlign>Center</TextAlign>
@@ -224,9 +205,197 @@
         <CanGrow>true</CanGrow>
         <Height>0.75cm</Height>
-        <Value>="Średnia cena modułów sprzedanych w " + CStr(Parameters!year.Value) + " - " + Code.GetMonths(Parameters!month)</Value>
+        <Value>="Średnia cena modułów wewnętrznych dla AMT sprzedanych w roku: " + CStr(Parameters!year.Value) + " miesiąc(e): " + Code.GetMonths(Parameters!months)</Value>
       </Textbox>
       <Table Name="table1">
         <DataSetName>Moduly</DataSetName>
-        <Top>1.75cm</Top>
+        <Top>1cm</Top>
+        <TableGroups>
+          <TableGroup>
+            <Grouping Name="table1_Agencja">
+              <GroupExpressions>
+                <GroupExpression>=Fields!Agencja.Value</GroupExpression>
+              </GroupExpressions>
+            </Grouping>
+            <Sorting>
+              <SortBy>
+                <SortExpression>=Fields!Agencja.Value</SortExpression>
+                <Direction>Ascending</Direction>
+              </SortBy>
+            </Sorting>
+            <Header>
+              <TableRows>
+                <TableRow>
+                  <TableCells>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="Agencja">
+                          <rd:DefaultName>Agencja</rd:DefaultName>
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <TextAlign>Left</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>20</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value>=Fields!Agencja.Value</Value>
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="textbox9">
+                          <rd:DefaultName>textbox9</rd:DefaultName>
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <TextAlign>Center</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>19</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value>
+                          </Value>
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="textbox15">
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <FontWeight>700</FontWeight>
+                            <Format>C</Format>
+                            <TextAlign>Center</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>18</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value>=Sum(Fields!SumaNetto.Value)</Value>
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="textbox10">
+                          <rd:DefaultName>textbox10</rd:DefaultName>
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <TextAlign>Center</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>17</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value>
+                          </Value>
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="textbox14">
+                          <rd:DefaultName>textbox14</rd:DefaultName>
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <TextAlign>Center</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>16</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value />
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="textbox11">
+                          <rd:DefaultName>textbox11</rd:DefaultName>
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <TextAlign>Center</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>15</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value />
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                    <TableCell>
+                      <ReportItems>
+                        <Textbox Name="textbox13">
+                          <rd:DefaultName>textbox13</rd:DefaultName>
+                          <Style>
+                            <BorderColor>
+                              <Default>DarkGray</Default>
+                            </BorderColor>
+                            <BorderStyle>
+                              <Default>Solid</Default>
+                            </BorderStyle>
+                            <TextAlign>Center</TextAlign>
+                            <PaddingLeft>2pt</PaddingLeft>
+                            <PaddingRight>2pt</PaddingRight>
+                            <PaddingTop>2pt</PaddingTop>
+                            <PaddingBottom>2pt</PaddingBottom>
+                          </Style>
+                          <ZIndex>14</ZIndex>
+                          <CanGrow>true</CanGrow>
+                          <Value />
+                        </Textbox>
+                      </ReportItems>
+                    </TableCell>
+                  </TableCells>
+                  <Height>0.53333cm</Height>
+                </TableRow>
+              </TableRows>
+            </Header>
+          </TableGroup>
+        </TableGroups>
         <Details>
           <TableRows>
@@ -235,13 +404,53 @@
                 <TableCell>
                   <ReportItems>
+                    <Textbox Name="textbox3">
+                      <rd:DefaultName>textbox3</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>6</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>
+                      </Value>
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
                     <Textbox Name="Agent">
                       <rd:DefaultName>Agent</rd:DefaultName>
                       <Style>
                         <BorderColor>
-                          <Default>LightGrey</Default>
-                        </BorderColor>
-                        <BorderStyle>
-                          <Default>Solid</Default>
-                        </BorderStyle>
+                          <Default>DarkGray</Default>
+                        </BorderColor>
+                        <BorderStyle>
+                          <Default>Solid</Default>
+                        </BorderStyle>
+                        <TextAlign>Left</TextAlign>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>5</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>=Fields!Agent.Value</Value>
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox16">
+                      <Style>
+                        <BorderColor>
+                          <Default>DarkGray</Default>
+                        </BorderColor>
+                        <BorderStyle>
+                          <Default>Solid</Default>
+                        </BorderStyle>
+                        <Format>C</Format>
                         <TextAlign>Center</TextAlign>
                         <PaddingLeft>2pt</PaddingLeft>
@@ -252,5 +461,5 @@
                       <ZIndex>4</ZIndex>
                       <CanGrow>true</CanGrow>
-                      <Value>=Fields!Agent.Value</Value>
+                      <Value>=Fields!SumaNetto.Value</Value>
                     </Textbox>
                   </ReportItems>
@@ -262,5 +471,5 @@
                       <Style>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -285,5 +494,5 @@
                       <Style>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -309,5 +518,5 @@
                       <Style>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -329,9 +538,8 @@
                 <TableCell>
                   <ReportItems>
-                    <Textbox Name="textbox7">
-                      <rd:DefaultName>textbox7</rd:DefaultName>
-                      <Style>
-                        <BorderColor>
-                          <Default>LightGrey</Default>
+                    <Textbox Name="textbox18">
+                      <Style>
+                        <BorderColor>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -346,5 +554,5 @@
                       </Style>
                       <CanGrow>true</CanGrow>
-                      <Value>=(1 - (Fields!Sprzedano.Value/Fields!Cennik.Value))</Value>
+                      <Value>=1- (Fields!Sprzedano.Value / Fields!Cennik.Value)</Value>
                     </Textbox>
                   </ReportItems>
@@ -354,4 +562,8 @@
             </TableRow>
           </TableRows>
+          <Visibility>
+            <Hidden>true</Hidden>
+            <ToggleItem>Agencja</ToggleItem>
+          </Visibility>
         </Details>
         <Header>
@@ -366,5 +578,5 @@
                         <BackgroundColor>WhiteSmoke</BackgroundColor>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -378,32 +590,7 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>9</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>Agent</Value>
-                    </Textbox>
-                  </ReportItems>
-                </TableCell>
-                <TableCell>
-                  <ReportItems>
-                    <Textbox Name="textbox3">
-                      <rd:DefaultName>textbox3</rd:DefaultName>
-                      <Style>
-                        <BackgroundColor>WhiteSmoke</BackgroundColor>
-                        <BorderColor>
-                          <Default>LightGrey</Default>
-                        </BorderColor>
-                        <BorderStyle>
-                          <Default>Solid</Default>
-                        </BorderStyle>
-                        <FontWeight>700</FontWeight>
-                        <TextAlign>Center</TextAlign>
-                        <PaddingLeft>2pt</PaddingLeft>
-                        <PaddingRight>2pt</PaddingRight>
-                        <PaddingTop>2pt</PaddingTop>
-                        <PaddingBottom>2pt</PaddingBottom>
-                      </Style>
-                      <ZIndex>8</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>Moduł</Value>
+                      <ZIndex>27</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Agencja</Value>
                     </Textbox>
                   </ReportItems>
@@ -416,5 +603,5 @@
                         <BackgroundColor>WhiteSmoke</BackgroundColor>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -428,7 +615,31 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>7</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>Cena sprzedaży</Value>
+                      <ZIndex>26</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Agent</Value>
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox12">
+                      <Style>
+                        <BackgroundColor>WhiteSmoke</BackgroundColor>
+                        <BorderColor>
+                          <Default>DarkGray</Default>
+                        </BorderColor>
+                        <BorderStyle>
+                          <Default>Solid</Default>
+                        </BorderStyle>
+                        <FontWeight>700</FontWeight>
+                        <TextAlign>Center</TextAlign>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>25</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Suma Netto</Value>
                     </Textbox>
                   </ReportItems>
@@ -441,5 +652,5 @@
                         <BackgroundColor>WhiteSmoke</BackgroundColor>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -453,7 +664,7 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>6</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>Cena w cenniku</Value>
+                      <ZIndex>24</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Moduł</Value>
                     </Textbox>
                   </ReportItems>
@@ -466,5 +677,5 @@
                         <BackgroundColor>WhiteSmoke</BackgroundColor>
                         <BorderColor>
-                          <Default>LightGrey</Default>
+                          <Default>DarkGray</Default>
                         </BorderColor>
                         <BorderStyle>
@@ -478,7 +689,57 @@
                         <PaddingBottom>2pt</PaddingBottom>
                       </Style>
-                      <ZIndex>5</ZIndex>
-                      <CanGrow>true</CanGrow>
-                      <Value>Procent rabatu</Value>
+                      <ZIndex>23</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Cena sprzedaży</Value>
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox7">
+                      <rd:DefaultName>textbox7</rd:DefaultName>
+                      <Style>
+                        <BackgroundColor>WhiteSmoke</BackgroundColor>
+                        <BorderColor>
+                          <Default>DarkGray</Default>
+                        </BorderColor>
+                        <BorderStyle>
+                          <Default>Solid</Default>
+                        </BorderStyle>
+                        <FontWeight>700</FontWeight>
+                        <TextAlign>Center</TextAlign>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>22</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Cena z cennika</Value>
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox8">
+                      <rd:DefaultName>textbox8</rd:DefaultName>
+                      <Style>
+                        <BackgroundColor>WhiteSmoke</BackgroundColor>
+                        <BorderColor>
+                          <Default>DarkGray</Default>
+                        </BorderColor>
+                        <BorderStyle>
+                          <Default>Solid</Default>
+                        </BorderStyle>
+                        <FontWeight>700</FontWeight>
+                        <TextAlign>Center</TextAlign>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>21</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>Rabat</Value>
                     </Textbox>
                   </ReportItems>
@@ -492,22 +753,157 @@
         <TableColumns>
           <TableColumn>
-            <Width>2.55cm</Width>
+            <Width>4.5cm</Width>
           </TableColumn>
           <TableColumn>
-            <Width>2.55cm</Width>
+            <Width>2.53968cm</Width>
           </TableColumn>
           <TableColumn>
-            <Width>2.55cm</Width>
+            <Width>2.53968cm</Width>
           </TableColumn>
           <TableColumn>
-            <Width>2.55cm</Width>
+            <Width>2.53968cm</Width>
           </TableColumn>
           <TableColumn>
-            <Width>3.25cm</Width>
+            <Width>2.53968cm</Width>
+          </TableColumn>
+          <TableColumn>
+            <Width>2.53968cm</Width>
+          </TableColumn>
+          <TableColumn>
+            <Width>2.53968cm</Width>
           </TableColumn>
         </TableColumns>
+        <Footer>
+          <TableRows>
+            <TableRow>
+              <TableCells>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox17">
+                      <rd:DefaultName>textbox17</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>13</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value />
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox19">
+                      <rd:DefaultName>textbox19</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>12</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value />
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox25">
+                      <Style>
+                        <BorderColor>
+                          <Default>DarkGray</Default>
+                        </BorderColor>
+                        <BorderStyle>
+                          <Default>Solid</Default>
+                        </BorderStyle>
+                        <FontWeight>700</FontWeight>
+                        <Format>C</Format>
+                        <TextAlign>Center</TextAlign>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>11</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value>=Sum(Fields!SumaNetto.Value)</Value>
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox21">
+                      <rd:DefaultName>textbox21</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>10</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value />
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox22">
+                      <rd:DefaultName>textbox22</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>9</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value />
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox23">
+                      <rd:DefaultName>textbox23</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>8</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value />
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+                <TableCell>
+                  <ReportItems>
+                    <Textbox Name="textbox24">
+                      <rd:DefaultName>textbox24</rd:DefaultName>
+                      <Style>
+                        <PaddingLeft>2pt</PaddingLeft>
+                        <PaddingRight>2pt</PaddingRight>
+                        <PaddingTop>2pt</PaddingTop>
+                        <PaddingBottom>2pt</PaddingBottom>
+                      </Style>
+                      <ZIndex>7</ZIndex>
+                      <CanGrow>true</CanGrow>
+                      <Value />
+                    </Textbox>
+                  </ReportItems>
+                </TableCell>
+              </TableCells>
+              <Height>0.63492cm</Height>
+            </TableRow>
+          </TableRows>
+        </Footer>
       </Table>
     </ReportItems>
-    <Height>2.81666cm</Height>
+    <Height>3.23491cm</Height>
   </Body>
   <Language>pl-PL</Language>