Zbiór zmian 681 dla trunk/RaportySQL/adMotoRaportFaktury.rdl
- Data:
- 2009-06-03 17:36:03 (17 years ago)
- Pliki:
-
- 1 skopiowane
-
trunk/RaportySQL/adMotoRaportFaktury.rdl (skopiowane) (skopiowane from trunk/RaportySQL/adMotoRaportProwizja.rdl) (36 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/RaportySQL/adMotoRaportFaktury.rdl
r539 r681 75 75 </ValidValues> 76 76 </ReportParameter> 77 <ReportParameter Name="tytul">78 <DataType>String</DataType>79 <DefaultValue>80 <Values>81 <Value>adMot</Value>82 </Values>83 </DefaultValue>84 <Prompt>tytul</Prompt>85 <Hidden>true</Hidden>86 </ReportParameter>87 77 </ReportParameters> 88 78 <rd:DrawGrid>true</rd:DrawGrid> … … 138 128 <DataSourceName>BAZA_REKLAM</DataSourceName> 139 129 <CommandType>StoredProcedure</CommandType> 140 <CommandText>sp_adMotoRaport Prowizja</CommandText>130 <CommandText>sp_adMotoRaportFaktury</CommandText> 141 131 <QueryParameters> 142 <QueryParameter Name=" @rok">132 <QueryParameter Name="rok"> 143 133 <Value>=Parameters!rok.Value</Value> 144 134 </QueryParameter> 145 <QueryParameter Name=" @miesiac">135 <QueryParameter Name="miesiac"> 146 136 <Value>=Parameters!miesiac.Value</Value> 147 </QueryParameter>148 <QueryParameter Name="@tytul">149 <Value>=Parameters!tytul.Value</Value>150 137 </QueryParameter> 151 138 </QueryParameters> … … 171 158 </DataSets> 172 159 <Code /> 173 <Width>1 8.75cm</Width>160 <Width>12cm</Width> 174 161 <Body> 175 162 <ColumnSpacing>1cm</ColumnSpacing> … … 178 165 <rd:DefaultName>textbox19</rd:DefaultName> 179 166 <Top>0.5cm</Top> 180 <Width>1 8cm</Width>167 <Width>11.25cm</Width> 181 168 <Style> 182 169 <FontWeight>700</FontWeight> … … 191 178 <Left>0.5cm</Left> 192 179 <Height>0.7cm</Height> 193 <Value>="Rozliczenie reklamyza " + CStr(Parameters!rok.Value) + ", " + CStr(Parameters!miesiac.Value)</Value>180 <Value>="Rozliczenie prowizji za sprzedaÅŒ reklam za " + CStr(Parameters!rok.Value) + ", " + CStr(Parameters!miesiac.Value)</Value> 194 181 </Textbox> 195 182 <Table Name="table1"> 196 183 <DataSetName>SprzedazWplywy</DataSetName> 197 184 <Top>1.5cm</Top> 198 <Width>14.5cm</Width>199 185 <Details> 200 186 <TableRows> … … 219 205 <PaddingBottom>2pt</PaddingBottom> 220 206 </Style> 221 <ZIndex> 5</ZIndex>207 <ZIndex>4</ZIndex> 222 208 <CanGrow>true</CanGrow> 223 209 <Value>=Fields!Agent.Value</Value> … … 243 229 <PaddingBottom>2pt</PaddingBottom> 244 230 </Style> 245 <ZIndex> 4</ZIndex>231 <ZIndex>3</ZIndex> 246 232 <CanGrow>true</CanGrow> 247 233 <Value>=Fields!SymbolFaktury.Value</Value> … … 268 254 <PaddingBottom>2pt</PaddingBottom> 269 255 </Style> 270 <ZIndex> 3</ZIndex>256 <ZIndex>2</ZIndex> 271 257 <CanGrow>true</CanGrow> 272 258 <Value>=Fields!DataWplaty.Value</Value> … … 293 279 <PaddingBottom>2pt</PaddingBottom> 294 280 </Style> 295 <ZIndex> 2</ZIndex>281 <ZIndex>1</ZIndex> 296 282 <CanGrow>true</CanGrow> 297 283 <Value>=Fields!Netto.Value</Value> … … 318 304 <PaddingBottom>2pt</PaddingBottom> 319 305 </Style> 320 <ZIndex>1</ZIndex>321 306 <CanGrow>true</CanGrow> 322 307 <Value>=Fields!Prowizja.Value</Value> 323 </Textbox>324 </ReportItems>325 </TableCell>326 <TableCell>327 <ReportItems>328 <Textbox Name="textbox14">329 <rd:DefaultName>textbox14</rd:DefaultName>330 <Style>331 <BorderStyle>332 <Default>Solid</Default>333 </BorderStyle>334 <BorderWidth>335 <Default>0.5pt</Default>336 </BorderWidth>337 <FontSize>8pt</FontSize>338 <TextAlign>Center</TextAlign>339 <PaddingLeft>2pt</PaddingLeft>340 <PaddingRight>2pt</PaddingRight>341 <PaddingTop>2pt</PaddingTop>342 <PaddingBottom>2pt</PaddingBottom>343 </Style>344 <CanGrow>true</CanGrow>345 <Value>=Fields!Agencja.Value</Value>346 308 </Textbox> 347 309 </ReportItems> … … 379 341 <PaddingBottom>2pt</PaddingBottom> 380 342 </Style> 381 <ZIndex> 35</ZIndex>343 <ZIndex>29</ZIndex> 382 344 <CanGrow>true</CanGrow> 383 345 <Value>Akwizytor</Value> … … 405 367 <PaddingBottom>2pt</PaddingBottom> 406 368 </Style> 407 <ZIndex> 34</ZIndex>369 <ZIndex>28</ZIndex> 408 370 <CanGrow>true</CanGrow> 409 371 <Value>Faktura</Value> … … 431 393 <PaddingBottom>2pt</PaddingBottom> 432 394 </Style> 433 <ZIndex> 33</ZIndex>395 <ZIndex>27</ZIndex> 434 396 <CanGrow>true</CanGrow> 435 397 <Value>Data zapÅaty</Value> … … 457 419 <PaddingBottom>2pt</PaddingBottom> 458 420 </Style> 459 <ZIndex> 32</ZIndex>421 <ZIndex>26</ZIndex> 460 422 <CanGrow>true</CanGrow> 461 423 <Value>Netto</Value> … … 483 445 <PaddingBottom>2pt</PaddingBottom> 484 446 </Style> 485 <ZIndex> 31</ZIndex>447 <ZIndex>25</ZIndex> 486 448 <CanGrow>true</CanGrow> 487 449 <Value>Prowizja</Value> 488 </Textbox>489 </ReportItems>490 </TableCell>491 <TableCell>492 <ReportItems>493 <Textbox Name="textbox13">494 <rd:DefaultName>textbox13</rd:DefaultName>495 <Style>496 <BackgroundColor>WhiteSmoke</BackgroundColor>497 <BorderStyle>498 <Default>Solid</Default>499 </BorderStyle>500 <BorderWidth>501 <Default>0.5pt</Default>502 </BorderWidth>503 <FontSize>8pt</FontSize>504 <FontWeight>700</FontWeight>505 <TextAlign>Center</TextAlign>506 <PaddingLeft>2pt</PaddingLeft>507 <PaddingRight>2pt</PaddingRight>508 <PaddingTop>2pt</PaddingTop>509 <PaddingBottom>2pt</PaddingBottom>510 </Style>511 <ZIndex>30</ZIndex>512 <CanGrow>true</CanGrow>513 <Value>Agencja</Value>514 450 </Textbox> 515 451 </ReportItems> … … 536 472 <Width>2cm</Width> 537 473 </TableColumn> 538 <TableColumn>539 <Width>3cm</Width>540 </TableColumn>541 474 </TableColumns> 542 475 <Footer> … … 554 487 <PaddingBottom>2pt</PaddingBottom> 555 488 </Style> 556 <ZIndex> 11</ZIndex>489 <ZIndex>9</ZIndex> 557 490 <CanGrow>true</CanGrow> 558 491 <Value /> … … 570 503 <PaddingBottom>2pt</PaddingBottom> 571 504 </Style> 572 <ZIndex> 10</ZIndex>505 <ZIndex>8</ZIndex> 573 506 <CanGrow>true</CanGrow> 574 507 <Value /> … … 586 519 <PaddingBottom>2pt</PaddingBottom> 587 520 </Style> 588 <ZIndex> 9</ZIndex>521 <ZIndex>7</ZIndex> 589 522 <CanGrow>true</CanGrow> 590 523 <Value /> … … 613 546 <PaddingBottom>2pt</PaddingBottom> 614 547 </Style> 615 <ZIndex> 8</ZIndex>548 <ZIndex>6</ZIndex> 616 549 <CanGrow>true</CanGrow> 617 550 <Value>=SUM(Fields!Netto.Value)</Value> … … 640 573 <PaddingBottom>2pt</PaddingBottom> 641 574 </Style> 642 <ZIndex> 7</ZIndex>575 <ZIndex>5</ZIndex> 643 576 <CanGrow>true</CanGrow> 644 577 <Value>=SUM(Fields!Prowizja.Value)</Value> 645 </Textbox>646 </ReportItems>647 </TableCell>648 <TableCell>649 <ReportItems>650 <Textbox Name="textbox15">651 <rd:DefaultName>textbox15</rd:DefaultName>652 <Style>653 <PaddingLeft>2pt</PaddingLeft>654 <PaddingRight>2pt</PaddingRight>655 <PaddingTop>2pt</PaddingTop>656 <PaddingBottom>2pt</PaddingBottom>657 </Style>658 <ZIndex>6</ZIndex>659 <CanGrow>true</CanGrow>660 <Value />661 578 </Textbox> 662 579 </ReportItems> … … 677 594 <PaddingBottom>2pt</PaddingBottom> 678 595 </Style> 679 <ZIndex>1 7</ZIndex>596 <ZIndex>14</ZIndex> 680 597 <CanGrow>true</CanGrow> 681 598 <Value /> … … 693 610 <PaddingBottom>2pt</PaddingBottom> 694 611 </Style> 695 <ZIndex>1 6</ZIndex>612 <ZIndex>13</ZIndex> 696 613 <CanGrow>true</CanGrow> 697 614 <Value /> … … 709 626 <PaddingBottom>2pt</PaddingBottom> 710 627 </Style> 711 <ZIndex>1 5</ZIndex>628 <ZIndex>12</ZIndex> 712 629 <CanGrow>true</CanGrow> 713 630 <Value /> … … 732 649 <PaddingBottom>2pt</PaddingBottom> 733 650 </Style> 734 <ZIndex>1 4</ZIndex>651 <ZIndex>11</ZIndex> 735 652 <CanGrow>true</CanGrow> 736 653 <Value /> … … 755 672 <PaddingBottom>2pt</PaddingBottom> 756 673 </Style> 757 <ZIndex>13</ZIndex> 758 <CanGrow>true</CanGrow> 759 <Value /> 760 </Textbox> 761 </ReportItems> 762 </TableCell> 763 <TableCell> 764 <ReportItems> 765 <Textbox Name="textbox25"> 766 <rd:DefaultName>textbox25</rd:DefaultName> 767 <Style> 768 <PaddingLeft>2pt</PaddingLeft> 769 <PaddingRight>2pt</PaddingRight> 770 <PaddingTop>2pt</PaddingTop> 771 <PaddingBottom>2pt</PaddingBottom> 772 </Style> 773 <ZIndex>12</ZIndex> 674 <ZIndex>10</ZIndex> 774 675 <CanGrow>true</CanGrow> 775 676 <Value /> … … 792 693 <PaddingBottom>2pt</PaddingBottom> 793 694 </Style> 794 <ZIndex> 23</ZIndex>695 <ZIndex>19</ZIndex> 795 696 <CanGrow>true</CanGrow> 796 697 <Value /> … … 808 709 <PaddingBottom>2pt</PaddingBottom> 809 710 </Style> 810 <ZIndex> 22</ZIndex>711 <ZIndex>18</ZIndex> 811 712 <CanGrow>true</CanGrow> 812 713 <Value /> … … 824 725 <PaddingBottom>2pt</PaddingBottom> 825 726 </Style> 826 <ZIndex>21</ZIndex> 827 <CanGrow>true</CanGrow> 828 <Value /> 829 </Textbox> 830 </ReportItems> 831 </TableCell> 832 <TableCell> 833 <ReportItems> 834 <Textbox Name="textbox38"> 835 <rd:DefaultName>textbox38</rd:DefaultName> 836 <Style> 837 <BorderWidth> 838 <Default>0.5pt</Default> 839 </BorderWidth> 840 <PaddingLeft>2pt</PaddingLeft> 841 <PaddingRight>2pt</PaddingRight> 842 <PaddingTop>2pt</PaddingTop> 843 <PaddingBottom>2pt</PaddingBottom> 844 </Style> 845 <ZIndex>20</ZIndex> 727 <ZIndex>17</ZIndex> 846 728 <CanGrow>true</CanGrow> 847 729 <Value /> … … 860 742 <PaddingBottom>2pt</PaddingBottom> 861 743 </Style> 862 <ZIndex>1 9</ZIndex>863 <CanGrow>true</CanGrow> 864 <Value> Zysk:</Value>744 <ZIndex>16</ZIndex> 745 <CanGrow>true</CanGrow> 746 <Value>Suma netto:</Value> 865 747 </Textbox> 866 748 </ReportItems> … … 886 768 <PaddingBottom>2pt</PaddingBottom> 887 769 </Style> 888 <ZIndex>1 8</ZIndex>889 <CanGrow>true</CanGrow> 890 <Value>= (SUM(Fields!Netto.Value)-SUM(Fields!Prowizja.Value))</Value>770 <ZIndex>15</ZIndex> 771 <CanGrow>true</CanGrow> 772 <Value>=SUM(Fields!Netto.Value)</Value> 891 773 </Textbox> 892 774 </ReportItems> … … 907 789 <PaddingBottom>2pt</PaddingBottom> 908 790 </Style> 909 <ZIndex>2 9</ZIndex>791 <ZIndex>24</ZIndex> 910 792 <CanGrow>true</CanGrow> 911 793 <Value /> … … 923 805 <PaddingBottom>2pt</PaddingBottom> 924 806 </Style> 925 <ZIndex>2 8</ZIndex>807 <ZIndex>23</ZIndex> 926 808 <CanGrow>true</CanGrow> 927 809 <Value /> … … 939 821 <PaddingBottom>2pt</PaddingBottom> 940 822 </Style> 941 <ZIndex>27</ZIndex> 942 <CanGrow>true</CanGrow> 943 <Value /> 944 </Textbox> 945 </ReportItems> 946 </TableCell> 947 <TableCell> 948 <ReportItems> 949 <Textbox Name="textbox29"> 950 <rd:DefaultName>textbox29</rd:DefaultName> 951 <Style> 952 <BorderWidth> 953 <Default>0.5pt</Default> 954 </BorderWidth> 955 <PaddingLeft>2pt</PaddingLeft> 956 <PaddingRight>2pt</PaddingRight> 957 <PaddingTop>2pt</PaddingTop> 958 <PaddingBottom>2pt</PaddingBottom> 959 </Style> 960 <ZIndex>26</ZIndex> 823 <ZIndex>22</ZIndex> 961 824 <CanGrow>true</CanGrow> 962 825 <Value /> … … 975 838 <PaddingBottom>2pt</PaddingBottom> 976 839 </Style> 977 <ZIndex>2 5</ZIndex>978 <CanGrow>true</CanGrow> 979 <Value> Prowizja:</Value>840 <ZIndex>21</ZIndex> 841 <CanGrow>true</CanGrow> 842 <Value>Suma prowizji:</Value> 980 843 </Textbox> 981 844 </ReportItems> … … 1001 864 <PaddingBottom>2pt</PaddingBottom> 1002 865 </Style> 1003 <ZIndex>2 4</ZIndex>1004 <CanGrow>true</CanGrow> 1005 <Value>= (SUM(Fields!Netto.Value)-SUM(Fields!Prowizja.Value))*0.75</Value>866 <ZIndex>20</ZIndex> 867 <CanGrow>true</CanGrow> 868 <Value>=SUM(Fields!Prowizja.Value)</Value> 1006 869 </Textbox> 1007 870 </ReportItems>
