Zbiór zmian 596
- Data:
- 2009-04-21 13:24:31 (17 years ago)
- Lokalizacja:
- trunk/RaportySQL
- Pliki:
-
- 4 zmodyfikowane
-
RozliczenieWplywowWgDatyWplaty2009.rdl (zmodyfikowane) (30 diffs)
-
RozliczenieWplywowWgDatyWplaty2009.rdl.data (zmodyfikowane) (poprzedni)
-
Zaleglosci2009.rdl (zmodyfikowane) (3 diffs)
-
Zaleglosci2009.rdl.data (zmodyfikowane) (poprzedni)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl
r466 r596 608 608 <TableCell> 609 609 <ReportItems> 610 <Textbox Name="DATA_ZAPÅATY"> 611 <rd:DefaultName>DATA_ZAPÅATY</rd:DefaultName> 612 <Style> 613 <BorderColor> 614 <Default>LightGrey</Default> 615 </BorderColor> 616 <BorderStyle> 617 <Default>Solid</Default> 618 </BorderStyle> 619 <BorderWidth> 620 <Default>0.5pt</Default> 621 </BorderWidth> 622 <FontSize>8pt</FontSize> 623 <FontWeight>=iif(Fields!roznica_nowa.Value>60 OR Fields!roznica_stara.Value>60,"Bold","Normal")</FontWeight> 624 <Format>d</Format> 625 <TextAlign>Center</TextAlign> 626 <VerticalAlign>Middle</VerticalAlign> 627 <PaddingLeft>2pt</PaddingLeft> 628 <PaddingRight>2pt</PaddingRight> 629 <PaddingTop>2pt</PaddingTop> 630 <PaddingBottom>2pt</PaddingBottom> 631 <Language>pl</Language> 632 </Style> 633 <ZIndex>24</ZIndex> 634 <CanGrow>true</CanGrow> 635 <Value>=Fields!dataWplaty.Value</Value> 636 </Textbox> 637 </ReportItems> 638 </TableCell> 639 <TableCell> 640 <ReportItems> 610 641 <Textbox Name="FAKTURA_FORMA_PÅATNOÅCI"> 611 642 <rd:DefaultName>FAKTURA_FORMA_PÅATNOÅCI</rd:DefaultName> … … 629 660 <PaddingBottom>2pt</PaddingBottom> 630 661 </Style> 631 <ZIndex>2 4</ZIndex>662 <ZIndex>23</ZIndex> 632 663 <CanGrow>true</CanGrow> 633 664 <Value>=Fields!SPOSOB_ZAPLATY.Value</Value> … … 660 691 <Language>pl</Language> 661 692 </Style> 662 <ZIndex>2 3</ZIndex>693 <ZIndex>22</ZIndex> 663 694 <CanGrow>true</CanGrow> 664 695 <Value>=SUM(Fields!NETTO.Value)</Value> … … 691 722 <Language>pl</Language> 692 723 </Style> 693 <ZIndex>2 2</ZIndex>724 <ZIndex>21</ZIndex> 694 725 <CanGrow>true</CanGrow> 695 726 <Value>=SUM(Fields!VAT.Value)</Value> … … 722 753 <Language>pl</Language> 723 754 </Style> 724 <ZIndex>2 1</ZIndex>755 <ZIndex>20</ZIndex> 725 756 <CanGrow>true</CanGrow> 726 757 <Value>=SUM(Fields!BRUTTO.Value)</Value> … … 751 782 <PaddingBottom>2pt</PaddingBottom> 752 783 </Style> 753 <ZIndex> 20</ZIndex>784 <ZIndex>19</ZIndex> 754 785 <CanGrow>true</CanGrow> 755 786 <Value>=Fields!procentProwizji.Value</Value> … … 781 812 <Language>pl</Language> 782 813 </Style> 783 <ZIndex>1 9</ZIndex>814 <ZIndex>18</ZIndex> 784 815 <CanGrow>true</CanGrow> 785 816 <Value>=SUM(Fields!procentProwizji.Value * Fields!NETTO.Value)</Value> … … 810 841 <PaddingBottom>2pt</PaddingBottom> 811 842 </Style> 812 <ZIndex>1 8</ZIndex>843 <ZIndex>17</ZIndex> 813 844 <CanGrow>true</CanGrow> 814 845 <Value>=Fields!rodzajPotwierdzenia.Value</Value> … … 839 870 <PaddingBottom>2pt</PaddingBottom> 840 871 </Style> 841 <ZIndex>1 7</ZIndex>872 <ZIndex>16</ZIndex> 842 873 <CanGrow>true</CanGrow> 843 874 <Value>=Fields!symbolPotwierdzenia.Value</Value> 844 </Textbox>845 </ReportItems>846 </TableCell>847 <TableCell>848 <ReportItems>849 <Textbox Name="DATA_ZAPÅATY">850 <rd:DefaultName>DATA_ZAPÅATY</rd:DefaultName>851 <Style>852 <BorderColor>853 <Default>LightGrey</Default>854 </BorderColor>855 <BorderStyle>856 <Default>Solid</Default>857 </BorderStyle>858 <BorderWidth>859 <Default>0.5pt</Default>860 </BorderWidth>861 <FontSize>8pt</FontSize>862 <FontWeight>=iif(Fields!roznica_nowa.Value>60 OR Fields!roznica_stara.Value>60,"Bold","Normal")</FontWeight>863 <Format>d</Format>864 <TextAlign>Center</TextAlign>865 <VerticalAlign>Middle</VerticalAlign>866 <PaddingLeft>2pt</PaddingLeft>867 <PaddingRight>2pt</PaddingRight>868 <PaddingTop>2pt</PaddingTop>869 <PaddingBottom>2pt</PaddingBottom>870 <Language>pl</Language>871 </Style>872 <ZIndex>16</ZIndex>873 <CanGrow>true</CanGrow>874 <Value>=Fields!dataWplaty.Value</Value>875 875 </Textbox> 876 876 </ReportItems> … … 1017 1017 <TableCell> 1018 1018 <ReportItems> 1019 <Textbox Name="textbox55"> 1020 <rd:DefaultName>textbox55</rd:DefaultName> 1021 <Style> 1022 <BorderColor> 1023 <Default>LightGrey</Default> 1024 </BorderColor> 1025 <BorderStyle> 1026 <Default>Solid</Default> 1027 </BorderStyle> 1028 <BorderWidth> 1029 <Default>0.5pt</Default> 1030 </BorderWidth> 1031 <PaddingLeft>2pt</PaddingLeft> 1032 <PaddingRight>2pt</PaddingRight> 1033 <PaddingTop>2pt</PaddingTop> 1034 <PaddingBottom>2pt</PaddingBottom> 1035 </Style> 1036 <ZIndex>8</ZIndex> 1037 <CanGrow>true</CanGrow> 1038 <Value /> 1039 </Textbox> 1040 </ReportItems> 1041 </TableCell> 1042 <TableCell> 1043 <ReportItems> 1019 1044 <Textbox Name="textbox49"> 1020 1045 <rd:DefaultName>textbox49</rd:DefaultName> … … 1034 1059 <PaddingBottom>2pt</PaddingBottom> 1035 1060 </Style> 1036 <ZIndex> 8</ZIndex>1061 <ZIndex>7</ZIndex> 1037 1062 <CanGrow>true</CanGrow> 1038 1063 <Value /> … … 1064 1089 <Language>pl</Language> 1065 1090 </Style> 1066 <ZIndex> 7</ZIndex>1091 <ZIndex>6</ZIndex> 1067 1092 <CanGrow>true</CanGrow> 1068 1093 <Value>=Fields!NETTO.Value</Value> … … 1094 1119 <Language>pl</Language> 1095 1120 </Style> 1096 <ZIndex> 6</ZIndex>1121 <ZIndex>5</ZIndex> 1097 1122 <CanGrow>true</CanGrow> 1098 1123 <Value>=Fields!VAT.Value</Value> … … 1124 1149 <Language>pl</Language> 1125 1150 </Style> 1126 <ZIndex> 5</ZIndex>1151 <ZIndex>4</ZIndex> 1127 1152 <CanGrow>true</CanGrow> 1128 1153 <Value>=Fields!BRUTTO.Value</Value> … … 1153 1178 <PaddingBottom>2pt</PaddingBottom> 1154 1179 </Style> 1155 <ZIndex> 4</ZIndex>1180 <ZIndex>3</ZIndex> 1156 1181 <CanGrow>true</CanGrow> 1157 1182 <Value>=Fields!procentProwizji.Value</Value> … … 1183 1208 <Language>pl</Language> 1184 1209 </Style> 1185 <ZIndex> 3</ZIndex>1210 <ZIndex>2</ZIndex> 1186 1211 <CanGrow>true</CanGrow> 1187 1212 <Value>=Fields!procentProwizji.Value * Fields!NETTO.Value</Value> … … 1208 1233 <PaddingBottom>2pt</PaddingBottom> 1209 1234 </Style> 1210 <ZIndex> 2</ZIndex>1235 <ZIndex>1</ZIndex> 1211 1236 <CanGrow>true</CanGrow> 1212 1237 <Value /> … … 1218 1243 <Textbox Name="textbox54"> 1219 1244 <rd:DefaultName>textbox54</rd:DefaultName> 1220 <Style>1221 <BorderColor>1222 <Default>LightGrey</Default>1223 </BorderColor>1224 <BorderStyle>1225 <Default>Solid</Default>1226 </BorderStyle>1227 <BorderWidth>1228 <Default>0.5pt</Default>1229 </BorderWidth>1230 <PaddingLeft>2pt</PaddingLeft>1231 <PaddingRight>2pt</PaddingRight>1232 <PaddingTop>2pt</PaddingTop>1233 <PaddingBottom>2pt</PaddingBottom>1234 </Style>1235 <ZIndex>1</ZIndex>1236 <CanGrow>true</CanGrow>1237 <Value />1238 </Textbox>1239 </ReportItems>1240 </TableCell>1241 <TableCell>1242 <ReportItems>1243 <Textbox Name="textbox55">1244 <rd:DefaultName>textbox55</rd:DefaultName>1245 1245 <Style> 1246 1246 <BorderColor> … … 1437 1437 <TableCell> 1438 1438 <ReportItems> 1439 <Textbox Name="textbox36"> 1440 <Style> 1441 <BackgroundColor>WhiteSmoke</BackgroundColor> 1442 <BorderColor> 1443 <Default>LightGrey</Default> 1444 </BorderColor> 1445 <BorderStyle> 1446 <Default>Solid</Default> 1447 </BorderStyle> 1448 <BorderWidth> 1449 <Default>0.5pt</Default> 1450 </BorderWidth> 1451 <FontSize>8pt</FontSize> 1452 <FontWeight>700</FontWeight> 1453 <TextAlign>Center</TextAlign> 1454 <VerticalAlign>Middle</VerticalAlign> 1455 <PaddingLeft>2pt</PaddingLeft> 1456 <PaddingRight>2pt</PaddingRight> 1457 <PaddingTop>2pt</PaddingTop> 1458 <PaddingBottom>2pt</PaddingBottom> 1459 </Style> 1460 <ZIndex>38</ZIndex> 1461 <CanGrow>true</CanGrow> 1462 <Value>Data zapÅaty </Value> 1463 </Textbox> 1464 </ReportItems> 1465 </TableCell> 1466 <TableCell> 1467 <ReportItems> 1439 1468 <Textbox Name="textbox17"> 1440 1469 <rd:DefaultName>textbox17</rd:DefaultName> … … 1459 1488 <PaddingBottom>2pt</PaddingBottom> 1460 1489 </Style> 1461 <ZIndex>3 8</ZIndex>1490 <ZIndex>37</ZIndex> 1462 1491 <CanGrow>true</CanGrow> 1463 1492 <Value>Rodzaj pÅatn.</Value> … … 1489 1518 <PaddingBottom>2pt</PaddingBottom> 1490 1519 </Style> 1491 <ZIndex>3 7</ZIndex>1520 <ZIndex>36</ZIndex> 1492 1521 <CanGrow>true</CanGrow> 1493 1522 <Value>Netto</Value> … … 1519 1548 <PaddingBottom>2pt</PaddingBottom> 1520 1549 </Style> 1521 <ZIndex>3 6</ZIndex>1550 <ZIndex>35</ZIndex> 1522 1551 <CanGrow>true</CanGrow> 1523 1552 <Value>VAT</Value> … … 1549 1578 <PaddingBottom>2pt</PaddingBottom> 1550 1579 </Style> 1551 <ZIndex>3 5</ZIndex>1580 <ZIndex>34</ZIndex> 1552 1581 <CanGrow>true</CanGrow> 1553 1582 <Value>Brutto</Value> … … 1579 1608 <PaddingBottom>2pt</PaddingBottom> 1580 1609 </Style> 1581 <ZIndex>3 4</ZIndex>1610 <ZIndex>33</ZIndex> 1582 1611 <CanGrow>true</CanGrow> 1583 1612 <Value>% pro.</Value> … … 1609 1638 <PaddingBottom>2pt</PaddingBottom> 1610 1639 </Style> 1611 <ZIndex>3 3</ZIndex>1640 <ZIndex>32</ZIndex> 1612 1641 <CanGrow>true</CanGrow> 1613 1642 <Value>Prowizja</Value> … … 1639 1668 <PaddingBottom>2pt</PaddingBottom> 1640 1669 </Style> 1641 <ZIndex>3 2</ZIndex>1670 <ZIndex>31</ZIndex> 1642 1671 <CanGrow>true</CanGrow> 1643 1672 <Value>For. potw.</Value> … … 1669 1698 <PaddingBottom>2pt</PaddingBottom> 1670 1699 </Style> 1671 <ZIndex>3 1</ZIndex>1700 <ZIndex>30</ZIndex> 1672 1701 <CanGrow>true</CanGrow> 1673 1702 <Value>Sym. potw.</Value> 1674 </Textbox>1675 </ReportItems>1676 </TableCell>1677 <TableCell>1678 <ReportItems>1679 <Textbox Name="textbox24">1680 <rd:DefaultName>textbox24</rd:DefaultName>1681 <Style>1682 <BackgroundColor>WhiteSmoke</BackgroundColor>1683 <BorderColor>1684 <Default>LightGrey</Default>1685 </BorderColor>1686 <BorderStyle>1687 <Default>Solid</Default>1688 </BorderStyle>1689 <BorderWidth>1690 <Default>0.5pt</Default>1691 </BorderWidth>1692 <FontSize>8pt</FontSize>1693 <FontWeight>700</FontWeight>1694 <TextAlign>Center</TextAlign>1695 <VerticalAlign>Middle</VerticalAlign>1696 <PaddingLeft>2pt</PaddingLeft>1697 <PaddingRight>2pt</PaddingRight>1698 <PaddingTop>2pt</PaddingTop>1699 <PaddingBottom>2pt</PaddingBottom>1700 </Style>1701 <ZIndex>30</ZIndex>1702 <CanGrow>true</CanGrow>1703 <Value>Data zapÅaty </Value>1704 1703 </Textbox> 1705 1704 </ReportItems> … … 1726 1725 <TableColumn> 1727 1726 <Width>2cm</Width> 1727 </TableColumn> 1728 <TableColumn> 1729 <Width>2.05291cm</Width> 1728 1730 </TableColumn> 1729 1731 <TableColumn> … … 1751 1753 <Width>2cm</Width> 1752 1754 </TableColumn> 1753 <TableColumn>1754 <Width>2.05291cm</Width>1755 </TableColumn>1756 1755 </TableColumns> 1757 1756 <Height>3.0754cm</Height> … … 1793 1792 <ColSpan>6</ColSpan> 1794 1793 <ReportItems> 1795 <Textbox Name="textbox 20">1796 <rd:DefaultName>textbox 20</rd:DefaultName>1794 <Textbox Name="textbox35"> 1795 <rd:DefaultName>textbox35</rd:DefaultName> 1797 1796 <Style> 1798 1797 <BackgroundColor>WhiteSmoke</BackgroundColor> -
trunk/RaportySQL/Zaleglosci2009.rdl
r466 r596 165 165 <Field Name="brutto"> 166 166 <DataField>brutto</DataField> 167 <rd:TypeName>System.D ecimal</rd:TypeName>167 <rd:TypeName>System.Double</rd:TypeName> 168 168 </Field> 169 169 <Field Name="suma_zaplat"> … … 224 224 SUM(brutto) AS brutto, 225 225 SUM(wplata_brutto) AS suma_zaplat, 226 Sum(zalega) AS zalega,226 CAST(Sum(zalega) AS DECIMAL(9)) AS zalega, 227 227 SUM(waluta_brutto) AS brutto_waluta, 228 228 SUM(wplata_brutto_waluta) AS suma_zaplat_waluta, … … 245 245 wplaty.brutto AS wplata_brutto, 246 246 wplaty.waluta_brutto AS wplata_brutto_waluta, 247 V1.brutto - wplaty.bruttoAS zalega,247 ROUND(V1.brutto - wplaty.brutto, 0) AS zalega, 248 248 V1.waluta_brutto - wplaty.waluta_brutto as zalega_waluta, 249 249 dbo.AGENCJE.Symbol AS Agencja
