- Data:
- 2009-06-29 12:10:28 (17 years ago)
- Lokalizacja:
- trunk
- Pliki:
-
- 6 zmodyfikowane
-
BazaReklam/Raporty/fakturaReversed2.rdlc (zmodyfikowane) (8 diffs)
-
BazaReklam/Raporty/fakturaReversed2_1page.rdlc (zmodyfikowane) (8 diffs)
-
RaportySQL/ListaReklamA3.rdl (zmodyfikowane) (35 diffs)
-
RaportySQL/ListaReklamA3.rdl.data (zmodyfikowane) (poprzedni)
-
RaportySQL/ListaReklamNaWydanieNr.rdl (zmodyfikowane) (7 diffs)
-
RaportySQL/ListaReklamNaWydanieNr.rdl.data (zmodyfikowane) (poprzedni)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/BazaReklam/Raporty/fakturaReversed2.rdlc
r626 r733 1576 1576 <ZIndex>4</ZIndex> 1577 1577 <CanGrow>true</CanGrow> 1578 <Value>= iif(Sum(Fields!S_VAT.Value, "FakturaDetails2")<>0,Sum(Fields!NETTO.Value, "FakturaDetails2")*1.22,First(Fields!waluta_brutto.Value, "Faktura") & " " & First(Fields!waluta_miano.Value, "Faktura"))</Value>1578 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, Sum(Fields!NETTO.Value, "FakturaDetails2")*(1 + Fields!S_VAT.Value), First(Fields!waluta_brutto.Value, "Faktura") & " " & First(Fields!waluta_miano.Value, "Faktura"))</Value> 1579 1579 </Textbox> 1580 1580 </ReportItems> … … 1603 1603 <ZIndex>3</ZIndex> 1604 1604 <CanGrow>true</CanGrow> 1605 <Value>= iif(First(Fields!waluta_brutto.Value, "Faktura")<>0,Sum(Fields!NETTO.Value, "FakturaDetails2"),"")</Value>1605 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, "", Sum(Fields!NETTO.Value, "FakturaDetails2")*(1 + Fields!S_VAT.Value))</Value> 1606 1606 </Textbox> 1607 1607 </ReportItems> … … 4847 4847 <ZIndex>9</ZIndex> 4848 4848 <CanGrow>true</CanGrow> 4849 <Value>=iif(Fi elds!S_VAT.Value<>0,"Netto (PLN)","Netto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value>4849 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura") Is Nothing,"Netto (PLN)","Netto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value> 4850 4850 </Textbox> 4851 4851 </ReportItems> … … 4879 4879 <ZIndex>8</ZIndex> 4880 4880 <CanGrow>true</CanGrow> 4881 <Value>=iif(Fi elds!S_VAT.Value<>0,"VAT (PLN)","VAT (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value>4881 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura") Is Nothing,"VAT (PLN)","VAT (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value> 4882 4882 </Textbox> 4883 4883 </ReportItems> … … 4911 4911 <ZIndex>7</ZIndex> 4912 4912 <CanGrow>true</CanGrow> 4913 <Value>=iif(Fi elds!S_VAT.Value<>0,"Brutto (PLN)","Brutto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value>4913 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura") Is Nothing,"Brutto (PLN)","Brutto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value> 4914 4914 </Textbox> 4915 4915 </ReportItems> … … 5018 5018 <ZIndex>4</ZIndex> 5019 5019 <CanGrow>true</CanGrow> 5020 <Value>=IIf(Fi elds!S_VAT.Value>0,Fields!NETTO.Value,Fields!NETTO.Value/Parameters!kursWaluty.Value)</Value>5020 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing,Fields!NETTO.Value,Fields!NETTO.Value/Parameters!kursWaluty.Value)</Value> 5021 5021 </Textbox> 5022 5022 </ReportItems> … … 5049 5049 <ZIndex>3</ZIndex> 5050 5050 <CanGrow>true</CanGrow> 5051 <Value>= Fields!S_VAT.Value * Fields!NETTO.Value</Value>5051 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, Fields!S_VAT.Value * Fields!NETTO.Value, (Fields!S_VAT.Value * Fields!NETTO.Value)/Parameters!kursWaluty.Value)</Value> 5052 5052 </Textbox> 5053 5053 </ReportItems> … … 5080 5080 <ZIndex>2</ZIndex> 5081 5081 <CanGrow>true</CanGrow> 5082 <Value>=iif(Fi elds!S_VAT.Value<>0,Fields!NETTO.Value * (1 + Fields!S_VAT.Value),Fields!NETTO.Value/Parameters!kursWaluty.Value)</Value>5082 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, Fields!NETTO.Value * (1 + Fields!S_VAT.Value),(Fields!NETTO.Value * (1 + Fields!S_VAT.Value))/Parameters!kursWaluty.Value)</Value> 5083 5083 </Textbox> 5084 5084 </ReportItems> -
trunk/BazaReklam/Raporty/fakturaReversed2_1page.rdlc
r626 r733 1615 1615 <ZIndex>4</ZIndex> 1616 1616 <CanGrow>true</CanGrow> 1617 <Value>= iif(Sum(Fields!S_VAT.Value, "FakturaDetails2")<>0,Sum(Fields!NETTO.Value, "FakturaDetails2")*1.22,First(Fields!waluta_brutto.Value, "Faktura") & " " & First(Fields!waluta_miano.Value, "Faktura"))</Value>1617 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, Sum(Fields!NETTO.Value, "FakturaDetails2")*(1 + Fields!S_VAT.Value), First(Fields!waluta_brutto.Value, "Faktura") & " " & First(Fields!waluta_miano.Value, "Faktura"))</Value> 1618 1618 </Textbox> 1619 1619 </ReportItems> … … 1642 1642 <ZIndex>3</ZIndex> 1643 1643 <CanGrow>true</CanGrow> 1644 <Value>= iif(First(Fields!waluta_brutto.Value, "Faktura")<>0,Sum(Fields!NETTO.Value, "FakturaDetails2"),"")</Value>1644 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, "", Sum(Fields!NETTO.Value, "FakturaDetails2")*(1 + Fields!S_VAT.Value))</Value> 1645 1645 </Textbox> 1646 1646 </ReportItems> … … 4842 4842 <ZIndex>9</ZIndex> 4843 4843 <CanGrow>true</CanGrow> 4844 <Value>=iif(Fi elds!S_VAT.Value<>0,"Netto (PLN)","Netto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value>4844 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura") Is Nothing,"Netto (PLN)","Netto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value> 4845 4845 </Textbox> 4846 4846 </ReportItems> … … 4874 4874 <ZIndex>8</ZIndex> 4875 4875 <CanGrow>true</CanGrow> 4876 <Value>=iif(Fi elds!S_VAT.Value<>0,"VAT (PLN)","VAT (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value>4876 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura") Is Nothing,"VAT (PLN)","VAT (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value> 4877 4877 </Textbox> 4878 4878 </ReportItems> … … 4906 4906 <ZIndex>7</ZIndex> 4907 4907 <CanGrow>true</CanGrow> 4908 <Value>=iif(Fi elds!S_VAT.Value<>0,"Brutto (PLN)","Brutto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value>4908 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura") Is Nothing,"Brutto (PLN)","Brutto (" + First(Fields!waluta_miano.Value, "Faktura") + ")")</Value> 4909 4909 </Textbox> 4910 4910 </ReportItems> … … 5013 5013 <ZIndex>4</ZIndex> 5014 5014 <CanGrow>true</CanGrow> 5015 <Value>=IIf(Fi elds!S_VAT.Value>0,Fields!NETTO.Value,Fields!NETTO.Value/Parameters!kursWaluty.Value)</Value>5015 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing,Fields!NETTO.Value,Fields!NETTO.Value/Parameters!kursWaluty.Value)</Value> 5016 5016 </Textbox> 5017 5017 </ReportItems> … … 5044 5044 <ZIndex>3</ZIndex> 5045 5045 <CanGrow>true</CanGrow> 5046 <Value>= Fields!S_VAT.Value * Fields!NETTO.Value</Value>5046 <Value>=IIf(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, Fields!S_VAT.Value * Fields!NETTO.Value, (Fields!S_VAT.Value * Fields!NETTO.Value)/Parameters!kursWaluty.Value)</Value> 5047 5047 </Textbox> 5048 5048 </ReportItems> … … 5075 5075 <ZIndex>2</ZIndex> 5076 5076 <CanGrow>true</CanGrow> 5077 <Value>=iif(Fi elds!S_VAT.Value<>0,Fields!NETTO.Value * (1 + Fields!S_VAT.Value),Fields!NETTO.Value/Parameters!kursWaluty.Value)</Value>5077 <Value>=iif(First(Fields!waluta_miano.Value, "Faktura")="PLN" Or First(Fields!waluta_miano.Value, "Faktura") Is Nothing, Fields!NETTO.Value * (1 + Fields!S_VAT.Value),(Fields!NETTO.Value * (1 + Fields!S_VAT.Value))/Parameters!kursWaluty.Value)</Value> 5078 5078 </Textbox> 5079 5079 </ReportItems> -
trunk/RaportySQL/ListaReklamA3.rdl
r147 r733 13 13 <DefaultValue> 14 14 <Values> 15 <Value> AMT</Value>15 <Value>1</Value> 16 16 </Values> 17 17 </DefaultValue> … … 21 21 <DataSetReference> 22 22 <DataSetName>ListaTytulow</DataSetName> 23 <ValueField> SYMB</ValueField>23 <ValueField>Id</ValueField> 24 24 <LabelField>SYMB</LabelField> 25 25 </DataSetReference> … … 89 89 </ValidValues> 90 90 </ReportParameter> 91 <ReportParameter Name="dzial"> 92 <DataType>String</DataType> 93 <DefaultValue> 94 <DataSetReference> 95 <DataSetName>ListaDzialow</DataSetName> 96 <ValueField>Id</ValueField> 97 </DataSetReference> 98 </DefaultValue> 99 <AllowBlank>true</AllowBlank> 100 <Prompt>DziaÅy:</Prompt> 101 <ValidValues> 102 <DataSetReference> 103 <DataSetName>ListaDzialow</DataSetName> 104 <ValueField>Id</ValueField> 105 <LabelField>Name</LabelField> 106 </DataSetReference> 107 </ValidValues> 108 <MultiValue>true</MultiValue> 109 </ReportParameter> 91 110 </ReportParameters> 92 111 <rd:DrawGrid>true</rd:DrawGrid> … … 142 161 <rd:TypeName>System.String</rd:TypeName> 143 162 </Field> 163 <Field Name="lokalizacja1"> 164 <DataField>lokalizacja1</DataField> 165 <rd:TypeName>System.String</rd:TypeName> 166 </Field> 144 167 <Field Name="NR"> 145 168 <DataField>NR</DataField> … … 159 182 </Field> 160 183 <Field Name="agencja"> 161 <DataField> agencja</DataField>184 <DataField>Agencja</DataField> 162 185 <rd:TypeName>System.String</rd:TypeName> 163 186 </Field> … … 190 213 <rd:TypeName>System.Double</rd:TypeName> 191 214 </Field> 192 <Field Name="dziaÅ_txt"> 193 <DataField>dziaÅ_txt</DataField> 194 <rd:TypeName>System.String</rd:TypeName> 195 </Field> 196 <Field Name="rozdziaÅ_txt"> 197 <DataField>rozdziaÅ_txt</DataField> 215 <Field Name="nettoZEmisji"> 216 <DataField>nettoZEmisji</DataField> 217 <rd:TypeName>System.Decimal</rd:TypeName> 218 </Field> 219 <Field Name="zafakturowana"> 220 <DataField>zafakturowana</DataField> 221 <rd:TypeName>System.Boolean</rd:TypeName> 222 </Field> 223 <Field Name="Dzial"> 224 <DataField>Dzial</DataField> 225 <rd:TypeName>System.String</rd:TypeName> 226 </Field> 227 <Field Name="Rozdzial"> 228 <DataField>Rozdzial</DataField> 198 229 <rd:TypeName>System.String</rd:TypeName> 199 230 </Field> … … 201 232 <Query> 202 233 <DataSourceName>BAZA_REKLAM</DataSourceName> 203 <CommandText>SELECT R.ReklamaID, R.TYTUÅ, R.[ID REKLAMY], R.SZER, R.WYS, R.KOLOR, R.[NICK NAME], R.MOD_TYP, R.RABAT, R.STRONA AS lokalizacja, 204 [UKAÅ»E SIÄ W NR].[Nr Wydania] AS NR, R.[ZATWIERDZONO DO DRUKU], R.GRZBIET, REKLAMA_STRONA.STRONA, A.Symbol AS agencja, 205 R.[SYMBOL AKWIZYTORA], R.KROTNOÅÄ, R.NETTO, G.Nazwa AS nazwaGrzbietu, A2.ID_AGENTA, R.[CENA JEDN], R.[RABAT WARTOÅÄ], OD.dziaÅ_txt, 206 ORZ.rozdziaÅ_txt 207 FROM AGENCI AS A2 LEFT OUTER JOIN 208 AGENCJE AS A ON A.Id_agencji = A2.ID_AGENCJI INNER JOIN 209 REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] INNER JOIN 210 [UKAÅ»E SIÄ W NR] ON R.ReklamaID = [UKAÅ»E SIÄ W NR].ReklamaId LEFT OUTER JOIN 211 REKLAMA_STRONA ON R.ReklamaID = REKLAMA_STRONA.ReklamaId AND 212 [UKAÅ»E SIÄ W NR].[Nr Wydania] = REKLAMA_STRONA.NR_WYDANIA LEFT OUTER JOIN 213 GRZBIETY AS G ON R.GRZBIET = G.ID LEFT OUTER JOIN 214 ogl_dzialy AS OD ON OD.DZIAÅ_NR = R.ogl_dzial LEFT OUTER JOIN 215 ogl_rozdzialy AS ORZ ON OD.DZIAÅ_NR = ORZ.DZIAL AND R.ogl_rozdzial = ORZ.id 216 WHERE (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND 217 (@agent IS NULL) AND (@grzbiet IS NULL) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 218 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND 219 (@agent IS NULL) AND (R.GRZBIET = @grzbiet) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 220 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND 221 (@grzbiet IS NULL) AND (A2.ID_AGENTA = @agent) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 222 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND 223 (R.GRZBIET = @grzbiet) AND (A2.ID_AGENTA = @agent) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 224 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agent IS NULL) AND 225 (@grzbiet IS NULL) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 226 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agent IS NULL) AND 227 (R.GRZBIET = @grzbiet) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 228 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@grzbiet IS NULL) AND 229 (A2.ID_AGENTA = @agent) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR 230 (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (R.GRZBIET = @grzbiet) AND 231 (A2.ID_AGENTA = @agent) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) 232 ORDER BY R.[ID REKLAMY]</CommandText> 234 <CommandType>StoredProcedure</CommandType> 235 <CommandText>sp_GetListaReklamNaWydanie</CommandText> 233 236 <QueryParameters> 237 <QueryParameter Name="@nrwydania"> 238 <Value>=Parameters!nrwydania.Value</Value> 239 </QueryParameter> 234 240 <QueryParameter Name="@tytul"> 235 241 <Value>=Parameters!tytul.Value</Value> 236 242 </QueryParameter> 237 <QueryParameter Name="@ nrwydania">238 <Value>=Parameters! nrwydania.Value</Value>243 <QueryParameter Name="@dzial"> 244 <Value>=Parameters!dzial.Value</Value> 239 245 </QueryParameter> 240 246 <QueryParameter Name="@agencja"> … … 252 258 <DataSet Name="ListaTytulow"> 253 259 <Fields> 260 <Field Name="Id"> 261 <DataField>Id</DataField> 262 <rd:TypeName>System.Int32</rd:TypeName> 263 </Field> 254 264 <Field Name="SYMB"> 255 <DataField>S YMB</DataField>265 <DataField>Symb</DataField> 256 266 <rd:TypeName>System.String</rd:TypeName> 257 267 </Field> … … 259 269 <Query> 260 270 <DataSourceName>BAZA_REKLAM</DataSourceName> 261 <CommandText>SELECT SYMB 262 FROM [LISTA TYTUÅÃW] 263 WHERE (st_aktywny = - 1)</CommandText> 271 <CommandText>SELECT Id, Symb FROM [LISTA TYTUÅÃW] 272 WHERE Active=1</CommandText> 264 273 <rd:UseGenericDesigner>true</rd:UseGenericDesigner> 265 274 </Query> … … 334 343 <CommandText>SELECT ID, Nazwa 335 344 FROM GRZBIETY 336 union 337 select NULL ,'Wszystkie' 338 order by Nazwa</CommandText> 345 WHERE Active=1 AND TytulId=@tytul 346 UNION 347 SELECT NULL ,'Wszystkie' 348 ORDER BY Nazwa</CommandText> 349 <QueryParameters> 350 <QueryParameter Name="@tytul"> 351 <Value>=Parameters!tytul.Value</Value> 352 </QueryParameter> 353 </QueryParameters> 354 <rd:UseGenericDesigner>true</rd:UseGenericDesigner> 355 </Query> 356 </DataSet> 357 <DataSet Name="ListaDzialow"> 358 <Fields> 359 <Field Name="Id"> 360 <DataField>Id</DataField> 361 <rd:TypeName>System.Int32</rd:TypeName> 362 </Field> 363 <Field Name="Name"> 364 <DataField>Name</DataField> 365 <rd:TypeName>System.String</rd:TypeName> 366 </Field> 367 </Fields> 368 <Query> 369 <DataSourceName>BAZA_REKLAM</DataSourceName> 370 <CommandText>DECLARE @Dzialy Table 371 ( 372 Id INT, 373 Name NVARCHAR(50) 374 ) 375 376 INSERT INTO @Dzialy 377 SELECT Id, Name FROM Dzial WHERE Active=1 AND TitleId=@tytul 378 379 IF (SELECT COUNT(Id) FROM @Dzialy)<1 380 INSERT INTO @Dzialy 381 SELECT 0, 'Wszystkie dziaÅy' 382 383 SELECT * FROM @Dzialy</CommandText> 384 <QueryParameters> 385 <QueryParameter Name="@tytul"> 386 <Value>=Parameters!tytul.Value</Value> 387 </QueryParameter> 388 </QueryParameters> 339 389 <rd:UseGenericDesigner>true</rd:UseGenericDesigner> 340 390 </Query> … … 403 453 <CanGrow>true</CanGrow> 404 454 <Height>0.75cm</Height> 405 <Value>="LISTA REKLAM DO WYDANIA NR: " & Parameters!tytul. Value& " " & Parameters!nrwydania.Value</Value>455 <Value>="LISTA REKLAM DO WYDANIA NR: " & Parameters!tytul.Label & " " & Parameters!nrwydania.Value</Value> 406 456 </Textbox> 407 457 <Table Name="table1"> 408 458 <DataSetName>ListaReklam</DataSetName> 409 459 <Top>1.25cm</Top> 460 <Width>24.22646cm</Width> 410 461 <Details> 411 462 <TableRows> … … 434 485 <Language>pl-PL</Language> 435 486 </Style> 436 <ZIndex>1 1</ZIndex>487 <ZIndex>10</ZIndex> 437 488 <CanGrow>true</CanGrow> 438 489 <Value>=Left(Fields!agencja.Value,10)</Value> … … 464 515 <Language>pl-PL</Language> 465 516 </Style> 466 <ZIndex> 10</ZIndex>517 <ZIndex>9</ZIndex> 467 518 <CanGrow>true</CanGrow> 468 519 <Value>=Fields!ID_REKLAMY.Value</Value> … … 494 545 <Language>pl-PL</Language> 495 546 </Style> 496 <ZIndex> 9</ZIndex>547 <ZIndex>8</ZIndex> 497 548 <CanGrow>true</CanGrow> 498 549 <Value>=Fields!SZER.Value</Value> … … 524 575 <Language>pl-PL</Language> 525 576 </Style> 526 <ZIndex> 8</ZIndex>577 <ZIndex>7</ZIndex> 527 578 <CanGrow>true</CanGrow> 528 579 <Value>=Fields!WYS.Value</Value> … … 553 604 <Language>pl-PL</Language> 554 605 </Style> 555 <ZIndex> 7</ZIndex>606 <ZIndex>6</ZIndex> 556 607 <CanGrow>true</CanGrow> 557 608 <Value>=Fields!MOD_TYP.Value</Value> 558 </Textbox>559 </ReportItems>560 </TableCell>561 <TableCell>562 <ReportItems>563 <Textbox Name="KOLOR">564 <rd:DefaultName>KOLOR</rd:DefaultName>565 <Style>566 <BorderColor>567 <Default>LightGrey</Default>568 </BorderColor>569 <BorderStyle>570 <Default>Solid</Default>571 </BorderStyle>572 <BorderWidth>573 <Default>0.5pt</Default>574 </BorderWidth>575 <FontSize>7pt</FontSize>576 <TextAlign>Center</TextAlign>577 <VerticalAlign>Middle</VerticalAlign>578 <PaddingLeft>2pt</PaddingLeft>579 <PaddingRight>2pt</PaddingRight>580 <PaddingTop>2pt</PaddingTop>581 <PaddingBottom>2pt</PaddingBottom>582 <Language>pl-PL</Language>583 </Style>584 <ZIndex>6</ZIndex>585 <CanGrow>true</CanGrow>586 <Value>=Fields!KOLOR.Value</Value>587 609 </Textbox> 588 610 </ReportItems> … … 641 663 <ZIndex>4</ZIndex> 642 664 <CanGrow>true</CanGrow> 643 <Value>=Fields! dziaÅ_txt.Value</Value>665 <Value>=Fields!Dzial.Value</Value> 644 666 </Textbox> 645 667 </ReportItems> … … 669 691 <ZIndex>3</ZIndex> 670 692 <CanGrow>true</CanGrow> 671 <Value>=Fields! rozdziaÅ_txt.Value</Value>693 <Value>=Fields!Rozdzial.Value</Value> 672 694 </Textbox> 673 695 </ReportItems> … … 778 800 <TableCells> 779 801 <TableCell> 780 <ColSpan> 7</ColSpan>802 <ColSpan>6</ColSpan> 781 803 <ReportItems> 782 804 <Textbox Name="textbox37"> … … 806 828 <Language>pl-PL</Language> 807 829 </Style> 808 <ZIndex>2 5</ZIndex>830 <ZIndex>23</ZIndex> 809 831 <CanGrow>true</CanGrow> 810 832 <Value>=Count(Fields!ReklamaID.Value) & " REK" & " " & Sum(Fields!WYS.Value*Fields!SZER.Value) & " MOD" & " " & Round(Sum(Fields!WYS.Value*Fields!SZER.Value)/64) & " stron"</Value> … … 841 863 <PaddingBottom>2pt</PaddingBottom> 842 864 </Style> 843 <ZIndex>2 4</ZIndex>865 <ZIndex>22</ZIndex> 844 866 <CanGrow>true</CanGrow> 845 867 <Value>=Sum(Fields!CENA_JEDN.Value) - Sum(Fields!RABAT_WARTOÅÄ.Value)</Value> … … 877 899 <Language>pl-PL</Language> 878 900 </Style> 879 <ZIndex>2 3</ZIndex>901 <ZIndex>21</ZIndex> 880 902 <CanGrow>true</CanGrow> 881 903 <Value>Agencja</Value> … … 908 930 <Language>pl-PL</Language> 909 931 </Style> 910 <ZIndex>2 2</ZIndex>932 <ZIndex>20</ZIndex> 911 933 <CanGrow>true</CanGrow> 912 934 <Value>Symbol </Value> … … 939 961 <Language>pl-PL</Language> 940 962 </Style> 941 <ZIndex> 21</ZIndex>963 <ZIndex>19</ZIndex> 942 964 <CanGrow>true</CanGrow> 943 965 <Value>S</Value> … … 970 992 <Language>pl-PL</Language> 971 993 </Style> 972 <ZIndex> 20</ZIndex>994 <ZIndex>18</ZIndex> 973 995 <CanGrow>true</CanGrow> 974 996 <Value>W</Value> … … 1001 1023 <Language>pl-PL</Language> 1002 1024 </Style> 1003 <ZIndex>1 9</ZIndex>1025 <ZIndex>17</ZIndex> 1004 1026 <CanGrow>true</CanGrow> 1005 1027 <Value>ModuÅ</Value> 1006 </Textbox>1007 </ReportItems>1008 </TableCell>1009 <TableCell>1010 <ReportItems>1011 <Textbox Name="textbox16">1012 <rd:DefaultName>textbox16</rd:DefaultName>1013 <Style>1014 <BackgroundColor>WhiteSmoke</BackgroundColor>1015 <BorderColor>1016 <Default>LightGrey</Default>1017 </BorderColor>1018 <BorderStyle>1019 <Default>Solid</Default>1020 </BorderStyle>1021 <BorderWidth>1022 <Default>0.5pt</Default>1023 </BorderWidth>1024 <FontSize>7pt</FontSize>1025 <FontWeight>700</FontWeight>1026 <TextAlign>Center</TextAlign>1027 <VerticalAlign>Middle</VerticalAlign>1028 <PaddingLeft>2pt</PaddingLeft>1029 <PaddingRight>2pt</PaddingRight>1030 <PaddingTop>2pt</PaddingTop>1031 <PaddingBottom>2pt</PaddingBottom>1032 <Language>pl-PL</Language>1033 </Style>1034 <ZIndex>18</ZIndex>1035 <CanGrow>true</CanGrow>1036 <Value>KOLOR</Value>1037 1028 </Textbox> 1038 1029 </ReportItems> … … 1063 1054 <Language>pl-PL</Language> 1064 1055 </Style> 1065 <ZIndex>1 7</ZIndex>1056 <ZIndex>16</ZIndex> 1066 1057 <CanGrow>true</CanGrow> 1067 1058 <Value>Klient</Value> … … 1093 1084 <PaddingBottom>2pt</PaddingBottom> 1094 1085 </Style> 1095 <ZIndex>1 6</ZIndex>1086 <ZIndex>15</ZIndex> 1096 1087 <CanGrow>true</CanGrow> 1097 1088 <Value>DziaÅ</Value> … … 1123 1114 <PaddingBottom>2pt</PaddingBottom> 1124 1115 </Style> 1125 <ZIndex>1 5</ZIndex>1116 <ZIndex>14</ZIndex> 1126 1117 <CanGrow>true</CanGrow> 1127 1118 <Value>Roz</Value> … … 1154 1145 <Language>pl-PL</Language> 1155 1146 </Style> 1156 <ZIndex>1 4</ZIndex>1147 <ZIndex>13</ZIndex> 1157 1148 <CanGrow>true</CanGrow> 1158 1149 <Value>Lokalizacja</Value> … … 1185 1176 <Language>pl-PL</Language> 1186 1177 </Style> 1187 <ZIndex>1 3</ZIndex>1178 <ZIndex>12</ZIndex> 1188 1179 <CanGrow>true</CanGrow> 1189 1180 <Value>Str</Value> … … 1216 1207 <Language>pl-PL</Language> 1217 1208 </Style> 1218 <ZIndex>1 2</ZIndex>1209 <ZIndex>11</ZIndex> 1219 1210 <CanGrow>true</CanGrow> 1220 1211 <Value>Grzbiet</Value> … … 1229 1220 <TableColumns> 1230 1221 <TableColumn> 1231 <Width> 2.55cm</Width>1222 <Width>1.35cm</Width> 1232 1223 </TableColumn> 1233 1224 <TableColumn> 1234 <Width>2 .85cm</Width>1225 <Width>2cm</Width> 1235 1226 </TableColumn> 1236 1227 <TableColumn> … … 1239 1230 <TableColumn> 1240 1231 <Width>0.5cm</Width> 1241 </TableColumn>1242 <TableColumn>1243 <Width>1.27646cm</Width>1244 1232 </TableColumn> 1245 1233 <TableColumn> … … 1269 1257 <Height>2.88492cm</Height> 1270 1258 </Body> 1271 <Language> en-US</Language>1259 <Language>pl-PL</Language> 1272 1260 <TopMargin>1cm</TopMargin> 1273 1261 <PageHeight>42cm</PageHeight> -
trunk/RaportySQL/ListaReklamNaWydanieNr.rdl
r732 r733 7 7 </DataSource> 8 8 </DataSources> 9 <InteractiveHeight>2 9.7cm</InteractiveHeight>9 <InteractiveHeight>21cm</InteractiveHeight> 10 10 <ReportParameters> 11 11 <ReportParameter Name="tytul"> … … 110 110 </ReportParameters> 111 111 <rd:DrawGrid>true</rd:DrawGrid> 112 <InteractiveWidth>2 1cm</InteractiveWidth>112 <InteractiveWidth>29.7cm</InteractiveWidth> 113 113 <rd:GridSpacing>0.15cm</rd:GridSpacing> 114 114 <rd:SnapToGrid>true</rd:SnapToGrid> … … 117 117 <BottomMargin>1cm</BottomMargin> 118 118 <rd:ReportID>c8c9d8c9-35ad-4718-921a-81280b453acf</rd:ReportID> 119 <PageWidth>2 1cm</PageWidth>119 <PageWidth>29.7cm</PageWidth> 120 120 <DataSets> 121 121 <DataSet Name="ListaReklam"> … … 385 385 </DataSets> 386 386 <Code /> 387 <Width>2 1.75cm</Width>387 <Width>25cm</Width> 388 388 <Body> 389 389 <ColumnSpacing>1cm</ColumnSpacing> … … 451 451 <DataSetName>ListaReklam</DataSetName> 452 452 <Top>1.25cm</Top> 453 <Width>2 0.5cm</Width>453 <Width>23.61255cm</Width> 454 454 <Details> 455 455 <TableRows> … … 1538 1538 <TableColumns> 1539 1539 <TableColumn> 1540 <Width>1. 35cm</Width>1540 <Width>1.63783cm</Width> 1541 1541 </TableColumn> 1542 1542 <TableColumn> 1543 <Width>2 cm</Width>1543 <Width>2.1cm</Width> 1544 1544 </TableColumn> 1545 1545 <TableColumn> 1546 <Width>0. 5cm</Width>1546 <Width>0.6066cm</Width> 1547 1547 </TableColumn> 1548 1548 <TableColumn> 1549 <Width>0. 5cm</Width>1549 <Width>0.6066cm</Width> 1550 1550 </TableColumn> 1551 1551 <TableColumn> 1552 <Width>1. 25cm</Width>1552 <Width>1.51651cm</Width> 1553 1553 </TableColumn> 1554 1554 <TableColumn> 1555 <Width>2. 75cm</Width>1555 <Width>2.85cm</Width> 1556 1556 </TableColumn> 1557 1557 <TableColumn> 1558 <Width> 3cm</Width>1558 <Width>2.55cm</Width> 1559 1559 </TableColumn> 1560 1560 <TableColumn> 1561 <Width>3 cm</Width>1561 <Width>3.63962cm</Width> 1562 1562 </TableColumn> 1563 1563 <TableColumn> 1564 <Width>1. 2cm</Width>1564 <Width>1.45585cm</Width> 1565 1565 </TableColumn> 1566 1566 <TableColumn> 1567 <Width>1. 5cm</Width>1567 <Width>1.81981cm</Width> 1568 1568 </TableColumn> 1569 1569 <TableColumn> 1570 <Width>1. 5cm</Width>1570 <Width>1.81981cm</Width> 1571 1571 </TableColumn> 1572 1572 <TableColumn> 1573 <Width>0. 75cm</Width>1573 <Width>0.90991cm</Width> 1574 1574 </TableColumn> 1575 1575 <TableColumn> 1576 <Width> 1.2cm</Width>1576 <Width>2.1cm</Width> 1577 1577 </TableColumn> 1578 1578 </TableColumns> … … 1581 1581 <Height>2.88492cm</Height> 1582 1582 </Body> 1583 <Language> en-US</Language>1583 <Language>pl-PL</Language> 1584 1584 <TopMargin>1cm</TopMargin> 1585 <PageHeight>2 9.7cm</PageHeight>1585 <PageHeight>21cm</PageHeight> 1586 1586 </Report>
