Zbiór zmian 153 dla trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl
- Data:
- 2009-01-12 00:17:10 (17 years ago)
- Pliki:
-
- 1 zmodyfikowane
-
trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl (zmodyfikowane) (29 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl
r146 r153 267 267 Wplaty ON FAKTURY.ID_FAKTURY = Wplaty.idFaktury LEFT OUTER JOIN 268 268 KLIENCI ON FAKTURY.ID_NABYWCY = KLIENCI.CustomerID 269 WHERE (FAKTURY.KOREKTA <> 1) AND (YEAR( FAKTURY.DATA_WYSTAWIENIA) = @rok) AND (MONTH(FAKTURY.DATA_WYSTAWIENIA) = @miesiac)269 WHERE (FAKTURY.KOREKTA <> 1) AND (YEAR(Wplaty.dataWplaty) = @rok) AND (MONTH(Wplaty.dataWplaty) = @miesiac) 270 270 GROUP BY FAKTURY.DATA_WYSTAWIENIA, FAKTURY.ID_FAKTURY, AGENCI.Symbol, CONVERT(VARCHAR, FAKTURY.NUMER) + '/' + CONVERT(VARCHAR, 271 271 FAKTURY.NUMER_ROZ) + '/' + CONVERT(VARCHAR, FAKTURY.NUMER_ROK), KLIENCI.kodKlienta, Wplaty.symbolPotwierdzenia, … … 348 348 <Query> 349 349 <DataSourceName>BAZA_REKLAM</DataSourceName> 350 <CommandText>select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null and year(DATA_W) >=200 8order by year(DATA_W)desc</CommandText>350 <CommandText>select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null and year(DATA_W) >=2009 order by year(DATA_W)desc</CommandText> 351 351 <rd:UseGenericDesigner>true</rd:UseGenericDesigner> 352 352 </Query> … … 356 356 Formatuj = Format(Value, "### ### ##0.00 zÅ") 357 357 End Function</Code> 358 <Width>2 4.07937cm</Width>358 <Width>22.07937cm</Width> 359 359 <Body> 360 360 <ColumnSpacing>1cm</ColumnSpacing> … … 406 406 <PaddingBottom>2pt</PaddingBottom> 407 407 </Style> 408 <ZIndex>1 1</ZIndex>408 <ZIndex>10</ZIndex> 409 409 <CanGrow>true</CanGrow> 410 410 <Value>=Fields!NR_FK.Value</Value> … … 434 434 <PaddingBottom>2pt</PaddingBottom> 435 435 </Style> 436 <ZIndex> 10</ZIndex>436 <ZIndex>9</ZIndex> 437 437 <CanGrow>true</CanGrow> 438 438 <Value>=Fields!kodKlienta.Value</Value> … … 462 462 <PaddingBottom>2pt</PaddingBottom> 463 463 </Style> 464 <ZIndex> 9</ZIndex>464 <ZIndex>8</ZIndex> 465 465 <CanGrow>true</CanGrow> 466 466 <Value>=Fields!Symbol.Value</Value> … … 492 492 <Language>pl</Language> 493 493 </Style> 494 <ZIndex> 8</ZIndex>494 <ZIndex>7</ZIndex> 495 495 <CanGrow>true</CanGrow> 496 496 <Value>=Fields!TERMIN_ZAPLATY.Value</Value> … … 520 520 <PaddingBottom>2pt</PaddingBottom> 521 521 </Style> 522 <ZIndex> 7</ZIndex>522 <ZIndex>6</ZIndex> 523 523 <CanGrow>true</CanGrow> 524 524 <Value>=Fields!SPOSOB_ZAPLATY.Value</Value> … … 550 550 <Language>pl</Language> 551 551 </Style> 552 <ZIndex> 6</ZIndex>552 <ZIndex>5</ZIndex> 553 553 <CanGrow>true</CanGrow> 554 554 <Value>=Fields!NETTO.Value</Value> … … 580 580 <Language>pl</Language> 581 581 </Style> 582 <ZIndex> 5</ZIndex>582 <ZIndex>4</ZIndex> 583 583 <CanGrow>true</CanGrow> 584 584 <Value>=Fields!VAT.Value</Value> … … 610 610 <Language>pl</Language> 611 611 </Style> 612 <ZIndex> 4</ZIndex>612 <ZIndex>3</ZIndex> 613 613 <CanGrow>true</CanGrow> 614 614 <Value>=Fields!BRUTTO.Value</Value> … … 638 638 <PaddingBottom>2pt</PaddingBottom> 639 639 </Style> 640 <ZIndex> 3</ZIndex>640 <ZIndex>2</ZIndex> 641 641 <CanGrow>true</CanGrow> 642 642 <Value>=Fields!rodzajPotwierdzenia.Value</Value> … … 666 666 <PaddingBottom>2pt</PaddingBottom> 667 667 </Style> 668 <ZIndex> 2</ZIndex>668 <ZIndex>1</ZIndex> 669 669 <CanGrow>true</CanGrow> 670 670 <Value>=Fields!symbolPotwierdzenia.Value</Value> … … 696 696 <Language>pl</Language> 697 697 </Style> 698 <ZIndex>1</ZIndex>699 698 <CanGrow>true</CanGrow> 700 699 <Value>=Fields!dataWplaty.Value</Value> 701 </Textbox>702 </ReportItems>703 </TableCell>704 <TableCell>705 <ReportItems>706 <Textbox Name="textbox9">707 <rd:DefaultName>textbox9</rd:DefaultName>708 <Style>709 <BackgroundColor>Azure</BackgroundColor>710 <BorderColor>711 <Default>LightGrey</Default>712 </BorderColor>713 <BorderStyle>714 <Default>Solid</Default>715 </BorderStyle>716 <BorderWidth>717 <Default>0.5pt</Default>718 </BorderWidth>719 <FontSize>8pt</FontSize>720 <Format>d</Format>721 <TextAlign>Center</TextAlign>722 <VerticalAlign>Middle</VerticalAlign>723 <PaddingLeft>2pt</PaddingLeft>724 <PaddingRight>2pt</PaddingRight>725 <PaddingTop>2pt</PaddingTop>726 <PaddingBottom>2pt</PaddingBottom>727 <Language>pl</Language>728 </Style>729 <CanGrow>true</CanGrow>730 <Value>=Fields!zaplata_data.Value</Value>731 700 </Textbox> 732 701 </ReportItems> … … 775 744 <PaddingBottom>2pt</PaddingBottom> 776 745 </Style> 777 <ZIndex>2 4</ZIndex>746 <ZIndex>22</ZIndex> 778 747 <CanGrow>true</CanGrow> 779 748 <Value>Numer faktury</Value> … … 805 774 <PaddingBottom>2pt</PaddingBottom> 806 775 </Style> 807 <ZIndex>2 3</ZIndex>776 <ZIndex>21</ZIndex> 808 777 <CanGrow>true</CanGrow> 809 778 <Value>Kod klienta</Value> … … 835 804 <PaddingBottom>2pt</PaddingBottom> 836 805 </Style> 837 <ZIndex>2 2</ZIndex>806 <ZIndex>20</ZIndex> 838 807 <CanGrow>true</CanGrow> 839 808 <Value>Agent</Value> … … 865 834 <PaddingBottom>2pt</PaddingBottom> 866 835 </Style> 867 <ZIndex> 21</ZIndex>836 <ZIndex>19</ZIndex> 868 837 <CanGrow>true</CanGrow> 869 838 <Value>Termin zapÅaty</Value> … … 895 864 <PaddingBottom>2pt</PaddingBottom> 896 865 </Style> 897 <ZIndex> 20</ZIndex>866 <ZIndex>18</ZIndex> 898 867 <CanGrow>true</CanGrow> 899 868 <Value>Rodzaj pÅatn.</Value> … … 925 894 <PaddingBottom>2pt</PaddingBottom> 926 895 </Style> 927 <ZIndex>1 9</ZIndex>896 <ZIndex>17</ZIndex> 928 897 <CanGrow>true</CanGrow> 929 898 <Value>Netto</Value> … … 955 924 <PaddingBottom>2pt</PaddingBottom> 956 925 </Style> 957 <ZIndex>1 8</ZIndex>926 <ZIndex>16</ZIndex> 958 927 <CanGrow>true</CanGrow> 959 928 <Value>VAT</Value> … … 985 954 <PaddingBottom>2pt</PaddingBottom> 986 955 </Style> 987 <ZIndex>1 7</ZIndex>956 <ZIndex>15</ZIndex> 988 957 <CanGrow>true</CanGrow> 989 958 <Value>Brutto</Value> … … 1015 984 <PaddingBottom>2pt</PaddingBottom> 1016 985 </Style> 1017 <ZIndex>1 6</ZIndex>986 <ZIndex>14</ZIndex> 1018 987 <CanGrow>true</CanGrow> 1019 988 <Value>For. potw.</Value> … … 1045 1014 <PaddingBottom>2pt</PaddingBottom> 1046 1015 </Style> 1047 <ZIndex>1 5</ZIndex>1016 <ZIndex>13</ZIndex> 1048 1017 <CanGrow>true</CanGrow> 1049 1018 <Value>Sym. potw.</Value> … … 1075 1044 <PaddingBottom>2pt</PaddingBottom> 1076 1045 </Style> 1077 <ZIndex>14</ZIndex> 1078 <CanGrow>true</CanGrow> 1079 <Value>Data zapÅaty dla wpÅat z 2009</Value> 1080 </Textbox> 1081 </ReportItems> 1082 </TableCell> 1083 <TableCell> 1084 <ReportItems> 1085 <Textbox Name="textbox8"> 1086 <rd:DefaultName>textbox8</rd:DefaultName> 1087 <Style> 1088 <BackgroundColor>WhiteSmoke</BackgroundColor> 1089 <BorderColor> 1090 <Default>LightGrey</Default> 1091 </BorderColor> 1092 <BorderStyle> 1093 <Default>Solid</Default> 1094 </BorderStyle> 1095 <BorderWidth> 1096 <Default>0.5pt</Default> 1097 </BorderWidth> 1098 <FontSize>8pt</FontSize> 1099 <FontWeight>700</FontWeight> 1100 <TextAlign>Center</TextAlign> 1101 <VerticalAlign>Middle</VerticalAlign> 1102 <PaddingLeft>2pt</PaddingLeft> 1103 <PaddingRight>2pt</PaddingRight> 1104 <PaddingTop>2pt</PaddingTop> 1105 <PaddingBottom>2pt</PaddingBottom> 1106 </Style> 1107 <ZIndex>13</ZIndex> 1108 <CanGrow>true</CanGrow> 1109 <Value>Data zapÅaty dla wpÅat z 2008/2009</Value> 1046 <ZIndex>12</ZIndex> 1047 <CanGrow>true</CanGrow> 1048 <Value>Data zapÅaty </Value> 1110 1049 </Textbox> 1111 1050 </ReportItems> 1112 1051 </TableCell> 1113 1052 </TableCells> 1114 <Height>1. 75cm</Height>1053 <Height>1.25cm</Height> 1115 1054 </TableRow> 1116 1055 </TableRows> … … 1151 1090 <Width>2cm</Width> 1152 1091 </TableColumn> 1153 <TableColumn>1154 <Width>2cm</Width>1155 </TableColumn>1156 1092 </TableColumns> 1157 1093 <Footer> … … 1160 1096 <TableCells> 1161 1097 <TableCell> 1162 <ColSpan>1 2</ColSpan>1098 <ColSpan>11</ColSpan> 1163 1099 <ReportItems> 1164 1100 <Textbox Name="textbox7"> … … 1183 1119 <PaddingBottom>2pt</PaddingBottom> 1184 1120 </Style> 1185 <ZIndex>1 2</ZIndex>1121 <ZIndex>11</ZIndex> 1186 1122 <CanGrow>true</CanGrow> 1187 1123 <Value>="LICZBA FAKTUR: " & Count(Fields!ID_FAKTURY.Value) & " RAZEM NETTO: "& Code.Formatuj(Sum(Fields!NETTO.Value)) & " VAT: " & Code.Formatuj(Sum(Fields!VAT.Value)) & " BRUTTO: " & Code.Formatuj(Sum(Fields!BRUTTO.Value))</Value> … … 1197 1133 </Table> 1198 1134 </ReportItems> 1199 <Height> 4.01984cm</Height>1135 <Height>3.51984cm</Height> 1200 1136 </Body> 1201 1137 <Language>en-US</Language>
