Zbiór zmian 322 dla trunk/RaportySQL
- Data:
- 2009-02-09 16:44:45 (17 years ago)
- Pliki:
-
- 1 zmodyfikowane
-
trunk/RaportySQL/WplywyWgWplaty.rdl (zmodyfikowane) (19 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/RaportySQL/WplywyWgWplaty.rdl
r319 r322 149 149 AND (AgencjaId IN (@agencja)) 150 150 GROUP BY AgencjaId, Agencja, Tytul 151 152 /* 153 UNION 154 155 SELECT AgencjaId, Agencja, Tytul, 156 SUM(FakturaNetto) AS FakturaNetto, 157 SUM(FakturaBrutto) AS FakturaBrutto, 158 SUM(WplataBrutto) AS WplataBrutto 159 FROM FakturyZaplaconePoznanKatowice 160 WHERE 161 Rok = @rok 162 AND Miesiac IN (@ms) 163 AND (AgencjaId IN (@agencja)) 164 GROUP BY AgencjaId, Agencja, Tytul*/ 165 151 166 ORDER BY Agencja, Tytul</CommandText> 152 167 <QueryParameters> … … 271 286 <PaddingBottom>2pt</PaddingBottom> 272 287 </Style> 273 <ZIndex>1 4</ZIndex>288 <ZIndex>11</ZIndex> 274 289 <CanGrow>true</CanGrow> 275 290 <Value>=Fields!Agencja.Value</Value> … … 297 312 <PaddingBottom>2pt</PaddingBottom> 298 313 </Style> 299 <ZIndex>1 3</ZIndex>314 <ZIndex>10</ZIndex> 300 315 <CanGrow>true</CanGrow> 301 316 <Value> … … 327 342 <PaddingBottom>2pt</PaddingBottom> 328 343 </Style> 329 <ZIndex> 12</ZIndex>344 <ZIndex>9</ZIndex> 330 345 <CanGrow>true</CanGrow> 331 346 <Value>=Sum(Fields!FakturaNetto.Value)</Value> … … 356 371 <PaddingBottom>2pt</PaddingBottom> 357 372 </Style> 358 <ZIndex> 11</ZIndex>373 <ZIndex>8</ZIndex> 359 374 <CanGrow>true</CanGrow> 360 375 <Value>=Sum(Fields!FakturaBrutto.Value)</Value> 361 </Textbox>362 </ReportItems>363 </TableCell>364 <TableCell>365 <ReportItems>366 <Textbox Name="textbox11">367 <rd:DefaultName>textbox11</rd:DefaultName>368 <Style>369 <BackgroundColor>WhiteSmoke</BackgroundColor>370 <BorderColor>371 <Default>LightGrey</Default>372 </BorderColor>373 <BorderStyle>374 <Default>Solid</Default>375 </BorderStyle>376 <BorderWidth>377 <Default>0.5pt</Default>378 </BorderWidth>379 <FontSize>8pt</FontSize>380 <FontWeight>600</FontWeight>381 <Format>C</Format>382 <PaddingLeft>2pt</PaddingLeft>383 <PaddingRight>2pt</PaddingRight>384 <PaddingTop>2pt</PaddingTop>385 <PaddingBottom>2pt</PaddingBottom>386 </Style>387 <ZIndex>10</ZIndex>388 <CanGrow>true</CanGrow>389 <Value>=Sum(Fields!WplataBrutto.Value)</Value>390 376 </Textbox> 391 377 </ReportItems> … … 398 384 </TableGroup> 399 385 </TableGroups> 386 <Width>12.61904cm</Width> 400 387 <Details> 401 388 <TableRows> … … 412 399 <PaddingBottom>2pt</PaddingBottom> 413 400 </Style> 414 <ZIndex> 4</ZIndex>401 <ZIndex>3</ZIndex> 415 402 <CanGrow>true</CanGrow> 416 403 <Value> … … 439 426 <PaddingBottom>2pt</PaddingBottom> 440 427 </Style> 441 <ZIndex> 3</ZIndex>428 <ZIndex>2</ZIndex> 442 429 <CanGrow>true</CanGrow> 443 430 <Value>=Fields!Tytul.Value</Value> … … 466 453 <PaddingBottom>2pt</PaddingBottom> 467 454 </Style> 468 <ZIndex> 2</ZIndex>455 <ZIndex>1</ZIndex> 469 456 <CanGrow>true</CanGrow> 470 457 <Value>=Fields!FakturaNetto.Value</Value> … … 493 480 <PaddingBottom>2pt</PaddingBottom> 494 481 </Style> 495 <ZIndex>1</ZIndex>496 482 <CanGrow>true</CanGrow> 497 483 <Value>=Fields!FakturaBrutto.Value</Value> 498 </Textbox>499 </ReportItems>500 </TableCell>501 <TableCell>502 <ReportItems>503 <Textbox Name="WplataBrutto">504 <rd:DefaultName>WplataBrutto</rd:DefaultName>505 <Style>506 <BorderColor>507 <Default>LightGrey</Default>508 </BorderColor>509 <BorderStyle>510 <Default>Solid</Default>511 </BorderStyle>512 <BorderWidth>513 <Default>0.5pt</Default>514 </BorderWidth>515 <FontSize>8pt</FontSize>516 <Format>C</Format>517 <PaddingLeft>2pt</PaddingLeft>518 <PaddingRight>2pt</PaddingRight>519 <PaddingTop>2pt</PaddingTop>520 <PaddingBottom>2pt</PaddingBottom>521 </Style>522 <CanGrow>true</CanGrow>523 <Value>=Fields!WplataBrutto.Value</Value>524 484 </Textbox> 525 485 </ReportItems> … … 551 511 <PaddingBottom>2pt</PaddingBottom> 552 512 </Style> 553 <ZIndex>1 9</ZIndex>513 <ZIndex>15</ZIndex> 554 514 <CanGrow>true</CanGrow> 555 515 <Value>Agencja</Value> … … 570 530 <PaddingBottom>2pt</PaddingBottom> 571 531 </Style> 572 <ZIndex>1 8</ZIndex>532 <ZIndex>14</ZIndex> 573 533 <CanGrow>true</CanGrow> 574 534 <Value>Tytuł</Value> … … 589 549 <PaddingBottom>2pt</PaddingBottom> 590 550 </Style> 591 <ZIndex>1 7</ZIndex>551 <ZIndex>13</ZIndex> 592 552 <CanGrow>true</CanGrow> 593 553 <Value>Faktura Netto</Value> … … 608 568 <PaddingBottom>2pt</PaddingBottom> 609 569 </Style> 610 <ZIndex>1 6</ZIndex>570 <ZIndex>12</ZIndex> 611 571 <CanGrow>true</CanGrow> 612 572 <Value>Faktura Brutto</Value> 613 </Textbox>614 </ReportItems>615 </TableCell>616 <TableCell>617 <ReportItems>618 <Textbox Name="textbox7">619 <rd:DefaultName>textbox7</rd:DefaultName>620 <Style>621 <FontSize>8pt</FontSize>622 <FontWeight>700</FontWeight>623 <TextAlign>Center</TextAlign>624 <PaddingLeft>2pt</PaddingLeft>625 <PaddingRight>2pt</PaddingRight>626 <PaddingTop>2pt</PaddingTop>627 <PaddingBottom>2pt</PaddingBottom>628 </Style>629 <ZIndex>15</ZIndex>630 <CanGrow>true</CanGrow>631 <Value>Wpłata Brutto</Value>632 573 </Textbox> 633 574 </ReportItems> … … 652 593 <Width>2.53968cm</Width> 653 594 </TableColumn> 654 <TableColumn>655 <Width>2.53968cm</Width>656 </TableColumn>657 595 </TableColumns> 658 596 <Footer> … … 670 608 <PaddingBottom>2pt</PaddingBottom> 671 609 </Style> 672 <ZIndex> 9</ZIndex>610 <ZIndex>7</ZIndex> 673 611 <CanGrow>true</CanGrow> 674 612 <Value /> … … 686 624 <PaddingBottom>2pt</PaddingBottom> 687 625 </Style> 688 <ZIndex> 8</ZIndex>626 <ZIndex>6</ZIndex> 689 627 <CanGrow>true</CanGrow> 690 628 <Value /> … … 714 652 <PaddingBottom>2pt</PaddingBottom> 715 653 </Style> 716 <ZIndex> 7</ZIndex>654 <ZIndex>5</ZIndex> 717 655 <CanGrow>true</CanGrow> 718 656 <Value>=Sum(Fields!FakturaNetto.Value)</Value> … … 742 680 <PaddingBottom>2pt</PaddingBottom> 743 681 </Style> 744 <ZIndex> 6</ZIndex>682 <ZIndex>4</ZIndex> 745 683 <CanGrow>true</CanGrow> 746 684 <Value>=Sum(Fields!FakturaBrutto.Value)</Value> 747 </Textbox>748 </ReportItems>749 </TableCell>750 <TableCell>751 <ReportItems>752 <Textbox Name="textbox16">753 <rd:DefaultName>textbox16</rd:DefaultName>754 <Style>755 <BackgroundColor>WhiteSmoke</BackgroundColor>756 <BorderColor>757 <Default>LightGrey</Default>758 </BorderColor>759 <BorderStyle>760 <Default>Solid</Default>761 </BorderStyle>762 <BorderWidth>763 <Default>0.5pt</Default>764 </BorderWidth>765 <FontSize>8pt</FontSize>766 <FontWeight>700</FontWeight>767 <Format>C</Format>768 <PaddingLeft>2pt</PaddingLeft>769 <PaddingRight>2pt</PaddingRight>770 <PaddingTop>2pt</PaddingTop>771 <PaddingBottom>2pt</PaddingBottom>772 </Style>773 <ZIndex>5</ZIndex>774 <CanGrow>true</CanGrow>775 <Value>=Sum(Fields!WplataBrutto.Value)</Value>776 685 </Textbox> 777 686 </ReportItems>
