Zbiór zmian 581 dla trunk/RaportySQL
- Data:
- 2009-04-14 17:36:32 (17 years ago)
- Pliki:
-
- 1 zmodyfikowane
-
trunk/RaportySQL/SredniaCenaModulow.rdl (zmodyfikowane) (31 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/RaportySQL/SredniaCenaModulow.rdl
r577 r581 7 7 </DataSource> 8 8 </DataSources> 9 <InteractiveHeight> 11in</InteractiveHeight>9 <InteractiveHeight>29.7cm</InteractiveHeight> 10 10 <ReportParameters> 11 11 <ReportParameter Name="year"> … … 77 77 </ReportParameters> 78 78 <rd:DrawGrid>true</rd:DrawGrid> 79 <InteractiveWidth> 8.5in</InteractiveWidth>79 <InteractiveWidth>21cm</InteractiveWidth> 80 80 <rd:GridSpacing>0.25cm</rd:GridSpacing> 81 81 <rd:SnapToGrid>true</rd:SnapToGrid> … … 120 120 <rd:TypeName>System.Decimal</rd:TypeName> 121 121 </Field> 122 <Field Name="SumaNettoCennik"> 123 <DataField>SumaNettoCennik</DataField> 124 <rd:TypeName>System.Decimal</rd:TypeName> 125 </Field> 122 126 </Fields> 123 127 <Query> … … 131 135 COUNT(U.ID) AS IloscEmisji, 132 136 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, 133 CAST(SUM(M.Cena)/Count(R.ReklamaId) AS DECIMAL(9,2)) AS Cennik 137 CAST(SUM(M.Cena)/Count(R.ReklamaId) AS DECIMAL(9,2)) AS Cennik, 138 CAST(SUM(M.Cena * R.Szer * R.Wys) AS DECIMAL(9,2)) AS SumaNettoCennik 134 139 FROM [ukaże się w nr] U 135 140 INNER JOIN Reklama R ON R.ReklamaID = U.ReklamaID … … 186 191 Return s 187 192 End Function</Code> 188 <Width> 19.73808cm</Width>193 <Width>20.32936cm</Width> 189 194 <Body> 190 195 <ColumnSpacing>1cm</ColumnSpacing> … … 244 249 <PaddingBottom>2pt</PaddingBottom> 245 250 </Style> 246 <ZIndex>2 0</ZIndex>251 <ZIndex>23</ZIndex> 247 252 <CanGrow>true</CanGrow> 248 253 <Value>=Fields!Agencja.Value</Value> … … 267 272 <PaddingBottom>2pt</PaddingBottom> 268 273 </Style> 269 <ZIndex> 19</ZIndex>274 <ZIndex>22</ZIndex> 270 275 <CanGrow>true</CanGrow> 271 276 <Value> … … 292 297 <PaddingBottom>2pt</PaddingBottom> 293 298 </Style> 294 <ZIndex> 18</ZIndex>299 <ZIndex>21</ZIndex> 295 300 <CanGrow>true</CanGrow> 296 301 <Value>=Sum(Fields!SumaNetto.Value)</Value> 302 </Textbox> 303 </ReportItems> 304 </TableCell> 305 <TableCell> 306 <ReportItems> 307 <Textbox Name="textbox29"> 308 <Style> 309 <BorderColor> 310 <Default>DarkGray</Default> 311 </BorderColor> 312 <BorderStyle> 313 <Default>Solid</Default> 314 </BorderStyle> 315 <FontWeight>700</FontWeight> 316 <Format>C</Format> 317 <TextAlign>Center</TextAlign> 318 <PaddingLeft>2pt</PaddingLeft> 319 <PaddingRight>2pt</PaddingRight> 320 <PaddingTop>2pt</PaddingTop> 321 <PaddingBottom>2pt</PaddingBottom> 322 </Style> 323 <ZIndex>20</ZIndex> 324 <CanGrow>true</CanGrow> 325 <Value>=Sum(Fields!SumaNettoCennik.Value)</Value> 297 326 </Textbox> 298 327 </ReportItems> … … 315 344 <PaddingBottom>2pt</PaddingBottom> 316 345 </Style> 317 <ZIndex>1 7</ZIndex>346 <ZIndex>19</ZIndex> 318 347 <CanGrow>true</CanGrow> 319 348 <Value> … … 339 368 <PaddingBottom>2pt</PaddingBottom> 340 369 </Style> 341 <ZIndex>1 6</ZIndex>370 <ZIndex>18</ZIndex> 342 371 <CanGrow>true</CanGrow> 343 372 <Value /> … … 362 391 <PaddingBottom>2pt</PaddingBottom> 363 392 </Style> 364 <ZIndex>1 5</ZIndex>393 <ZIndex>17</ZIndex> 365 394 <CanGrow>true</CanGrow> 366 395 <Value /> … … 379 408 <Default>Solid</Default> 380 409 </BorderStyle> 410 <FontWeight>700</FontWeight> 411 <Format>P</Format> 381 412 <TextAlign>Center</TextAlign> 382 413 <PaddingLeft>2pt</PaddingLeft> … … 385 416 <PaddingBottom>2pt</PaddingBottom> 386 417 </Style> 387 <ZIndex>1 4</ZIndex>418 <ZIndex>16</ZIndex> 388 419 <CanGrow>true</CanGrow> 389 <Value />420 <Value>=1- (Sum(Fields!SumaNetto.Value) / Sum(Fields!SumaNettoCennik.Value))</Value> 390 421 </Textbox> 391 422 </ReportItems> … … 412 443 <PaddingBottom>2pt</PaddingBottom> 413 444 </Style> 414 <ZIndex> 6</ZIndex>445 <ZIndex>7</ZIndex> 415 446 <CanGrow>true</CanGrow> 416 447 <Value> … … 436 467 <PaddingBottom>2pt</PaddingBottom> 437 468 </Style> 469 <ZIndex>6</ZIndex> 470 <CanGrow>true</CanGrow> 471 <Value>=Fields!Agent.Value</Value> 472 </Textbox> 473 </ReportItems> 474 </TableCell> 475 <TableCell> 476 <ReportItems> 477 <Textbox Name="textbox16"> 478 <Style> 479 <BorderColor> 480 <Default>DarkGray</Default> 481 </BorderColor> 482 <BorderStyle> 483 <Default>Solid</Default> 484 </BorderStyle> 485 <Format>C</Format> 486 <TextAlign>Center</TextAlign> 487 <PaddingLeft>2pt</PaddingLeft> 488 <PaddingRight>2pt</PaddingRight> 489 <PaddingTop>2pt</PaddingTop> 490 <PaddingBottom>2pt</PaddingBottom> 491 </Style> 438 492 <ZIndex>5</ZIndex> 439 493 <CanGrow>true</CanGrow> 440 <Value>=Fields! Agent.Value</Value>441 </Textbox> 442 </ReportItems> 443 </TableCell> 444 <TableCell> 445 <ReportItems> 446 <Textbox Name="textbox 16">494 <Value>=Fields!SumaNetto.Value</Value> 495 </Textbox> 496 </ReportItems> 497 </TableCell> 498 <TableCell> 499 <ReportItems> 500 <Textbox Name="textbox26"> 447 501 <Style> 448 502 <BorderColor> … … 461 515 <ZIndex>4</ZIndex> 462 516 <CanGrow>true</CanGrow> 463 <Value>=Fields!SumaNetto .Value</Value>517 <Value>=Fields!SumaNettoCennik.Value</Value> 464 518 </Textbox> 465 519 </ReportItems> … … 590 644 <PaddingBottom>2pt</PaddingBottom> 591 645 </Style> 592 <ZIndex> 27</ZIndex>646 <ZIndex>31</ZIndex> 593 647 <CanGrow>true</CanGrow> 594 648 <Value>Agencja</Value> … … 615 669 <PaddingBottom>2pt</PaddingBottom> 616 670 </Style> 617 <ZIndex> 26</ZIndex>671 <ZIndex>30</ZIndex> 618 672 <CanGrow>true</CanGrow> 619 673 <Value>Agent</Value> … … 639 693 <PaddingBottom>2pt</PaddingBottom> 640 694 </Style> 641 <ZIndex>25</ZIndex> 642 <CanGrow>true</CanGrow> 643 <Value>Suma Netto</Value> 695 <ZIndex>29</ZIndex> 696 <CanGrow>true</CanGrow> 697 <Value>Sprzedaż Netto</Value> 698 </Textbox> 699 </ReportItems> 700 </TableCell> 701 <TableCell> 702 <ReportItems> 703 <Textbox Name="textbox20"> 704 <rd:DefaultName>textbox20</rd:DefaultName> 705 <Style> 706 <BackgroundColor>WhiteSmoke</BackgroundColor> 707 <BorderColor> 708 <Default>DarkGray</Default> 709 </BorderColor> 710 <BorderStyle> 711 <Default>Solid</Default> 712 </BorderStyle> 713 <FontWeight>700</FontWeight> 714 <TextAlign>Center</TextAlign> 715 <PaddingLeft>2pt</PaddingLeft> 716 <PaddingRight>2pt</PaddingRight> 717 <PaddingTop>2pt</PaddingTop> 718 <PaddingBottom>2pt</PaddingBottom> 719 </Style> 720 <ZIndex>28</ZIndex> 721 <CanGrow>true</CanGrow> 722 <Value>Sprzedaż wg cennika</Value> 644 723 </Textbox> 645 724 </ReportItems> … … 664 743 <PaddingBottom>2pt</PaddingBottom> 665 744 </Style> 666 <ZIndex>2 4</ZIndex>745 <ZIndex>27</ZIndex> 667 746 <CanGrow>true</CanGrow> 668 747 <Value>Moduł</Value> … … 689 768 <PaddingBottom>2pt</PaddingBottom> 690 769 </Style> 691 <ZIndex>2 3</ZIndex>692 <CanGrow>true</CanGrow> 693 <Value> Cena sprzedaży</Value>770 <ZIndex>26</ZIndex> 771 <CanGrow>true</CanGrow> 772 <Value>Średnia cena modułu</Value> 694 773 </Textbox> 695 774 </ReportItems> … … 714 793 <PaddingBottom>2pt</PaddingBottom> 715 794 </Style> 716 <ZIndex>2 2</ZIndex>717 <CanGrow>true</CanGrow> 718 <Value>Cena z cennika</Value>795 <ZIndex>25</ZIndex> 796 <CanGrow>true</CanGrow> 797 <Value>Cena modułu z cennika</Value> 719 798 </Textbox> 720 799 </ReportItems> … … 739 818 <PaddingBottom>2pt</PaddingBottom> 740 819 </Style> 741 <ZIndex>2 1</ZIndex>820 <ZIndex>24</ZIndex> 742 821 <CanGrow>true</CanGrow> 743 822 <Value>Rabat</Value> … … 753 832 <TableColumns> 754 833 <TableColumn> 755 <Width>4.5cm</Width> 834 <Width>4cm</Width> 835 </TableColumn> 836 <TableColumn> 837 <Width>2.5cm</Width> 838 </TableColumn> 839 <TableColumn> 840 <Width>2.5cm</Width> 841 </TableColumn> 842 <TableColumn> 843 <Width>2.5cm</Width> 844 </TableColumn> 845 <TableColumn> 846 <Width>2cm</Width> 756 847 </TableColumn> 757 848 <TableColumn> … … 762 853 </TableColumn> 763 854 <TableColumn> 764 <Width>2.53968cm</Width> 765 </TableColumn> 766 <TableColumn> 767 <Width>2.53968cm</Width> 768 </TableColumn> 769 <TableColumn> 770 <Width>2.53968cm</Width> 771 </TableColumn> 772 <TableColumn> 773 <Width>2.53968cm</Width> 855 <Width>1.75cm</Width> 774 856 </TableColumn> 775 857 </TableColumns> … … 788 870 <PaddingBottom>2pt</PaddingBottom> 789 871 </Style> 790 <ZIndex>1 3</ZIndex>872 <ZIndex>15</ZIndex> 791 873 <CanGrow>true</CanGrow> 792 874 <Value /> … … 804 886 <PaddingBottom>2pt</PaddingBottom> 805 887 </Style> 806 <ZIndex>1 2</ZIndex>888 <ZIndex>14</ZIndex> 807 889 <CanGrow>true</CanGrow> 808 890 <Value /> … … 828 910 <PaddingBottom>2pt</PaddingBottom> 829 911 </Style> 830 <ZIndex>1 1</ZIndex>912 <ZIndex>13</ZIndex> 831 913 <CanGrow>true</CanGrow> 832 914 <Value>=Sum(Fields!SumaNetto.Value)</Value> 915 </Textbox> 916 </ReportItems> 917 </TableCell> 918 <TableCell> 919 <ReportItems> 920 <Textbox Name="textbox27"> 921 <Style> 922 <BorderColor> 923 <Default>DarkGray</Default> 924 </BorderColor> 925 <BorderStyle> 926 <Default>Solid</Default> 927 </BorderStyle> 928 <FontWeight>700</FontWeight> 929 <Format>C</Format> 930 <TextAlign>Center</TextAlign> 931 <PaddingLeft>2pt</PaddingLeft> 932 <PaddingRight>2pt</PaddingRight> 933 <PaddingTop>2pt</PaddingTop> 934 <PaddingBottom>2pt</PaddingBottom> 935 </Style> 936 <ZIndex>12</ZIndex> 937 <CanGrow>true</CanGrow> 938 <Value>=Sum(Fields!SumaNettoCennik.Value)</Value> 833 939 </Textbox> 834 940 </ReportItems> … … 844 950 <PaddingBottom>2pt</PaddingBottom> 845 951 </Style> 846 <ZIndex>1 0</ZIndex>952 <ZIndex>11</ZIndex> 847 953 <CanGrow>true</CanGrow> 848 954 <Value /> … … 860 966 <PaddingBottom>2pt</PaddingBottom> 861 967 </Style> 862 <ZIndex> 9</ZIndex>968 <ZIndex>10</ZIndex> 863 969 <CanGrow>true</CanGrow> 864 970 <Value /> … … 876 982 <PaddingBottom>2pt</PaddingBottom> 877 983 </Style> 984 <ZIndex>9</ZIndex> 985 <CanGrow>true</CanGrow> 986 <Value /> 987 </Textbox> 988 </ReportItems> 989 </TableCell> 990 <TableCell> 991 <ReportItems> 992 <Textbox Name="textbox28"> 993 <Style> 994 <BorderColor> 995 <Default>DarkGray</Default> 996 </BorderColor> 997 <BorderStyle> 998 <Default>Solid</Default> 999 </BorderStyle> 1000 <FontWeight>700</FontWeight> 1001 <Format>P</Format> 1002 <TextAlign>Center</TextAlign> 1003 <PaddingLeft>2pt</PaddingLeft> 1004 <PaddingRight>2pt</PaddingRight> 1005 <PaddingTop>2pt</PaddingTop> 1006 <PaddingBottom>2pt</PaddingBottom> 1007 </Style> 878 1008 <ZIndex>8</ZIndex> 879 1009 <CanGrow>true</CanGrow> 880 <Value /> 881 </Textbox> 882 </ReportItems> 883 </TableCell> 884 <TableCell> 885 <ReportItems> 886 <Textbox Name="textbox24"> 887 <rd:DefaultName>textbox24</rd:DefaultName> 888 <Style> 889 <PaddingLeft>2pt</PaddingLeft> 890 <PaddingRight>2pt</PaddingRight> 891 <PaddingTop>2pt</PaddingTop> 892 <PaddingBottom>2pt</PaddingBottom> 893 </Style> 894 <ZIndex>7</ZIndex> 895 <CanGrow>true</CanGrow> 896 <Value /> 1010 <Value>=1- (Sum(Fields!SumaNetto.Value) / Sum(Fields!SumaNettoCennik.Value))</Value> 897 1011 </Textbox> 898 1012 </ReportItems>
