git.roojs.org Git - xtuple/blob - foundation-database/public/tables/report/BriefEarnedCommissions.xml

   1 <!DOCTYPE openRPTDef>
   2 <report>
   3  <title>Brief Earned Commissions</title>
   4  <name>BriefEarnedCommissions</name>
   5  <description></description>
   6  <grid>
   7   <snap/>
   8   <show/>
   9   <x>0.05</x>
  10   <y>0.05</y>
  11  </grid>
  12  <size>Letter</size>
  13  <portrait/>
  14  <topmargin>50</topmargin>
  15  <bottommargin>50</bottommargin>
  16  <rightmargin>50</rightmargin>
  17  <leftmargin>50</leftmargin>
  18  <querysource>
  19   <name>head</name>
  20   <sql>SELECT &lt;? if exists("salesrep_id") ?>
  21          ( SELECT salesrep_name
  22              FROM salesrep
  23             WHERE (salesrep_id=&lt;? value("salesrep_id") ?>) )
  24        &lt;? else ?>
  25          text('All Sales Reps')
  26        &lt;? endif ?>
  27        AS salesrep,
  28        formatDate(&lt;? value("startDate") ?>) AS startdate,
  29        formatDate(&lt;? value("endDate") ?>) AS enddate;</sql>
  30  </querysource>
  31  <querysource loadFromDb="true">
  32   <name>detail</name>
  33   <mqlgroup>briefEarnedCommission</mqlgroup>
  34   <mqlname>detail</mqlname>
  35  </querysource>
  36  <rpthead>
  37   <height>221</height>
  38   <label>
  39    <rect>
  40     <x>30</x>
  41     <y>140</y>
  42     <width>103</width>
  43     <height>20</height>
  44    </rect>
  45    <font>
  46     <face>Arial</face>
  47     <size>10</size>
  48     <weight>normal</weight>
  49    </font>
  50    <right/>
  51    <vcenter/>
  52    <string>End Date:</string>
  53   </label>
  54   <label>
  55    <rect>
  56     <x>165</x>
  57     <y>200</y>
  58     <width>50</width>
  59     <height>15</height>
  60    </rect>
  61    <font>
  62     <face>Arial</face>
  63     <size>8</size>
  64     <weight>normal</weight>
  65    </font>
  66    <hcenter/>
  67    <vcenter/>
  68    <string>Cust. #</string>
  69   </label>
  70   <line>
  71    <xstart>5</xstart>
  72    <ystart>215</ystart>
  73    <xend>745</xend>
  74    <yend>215</yend>
  75    <weight>2</weight>
  76   </line>
  77   <label>
  78    <rect>
  79     <x>5</x>
  80     <y>200</y>
  81     <width>50</width>
  82     <height>15</height>
  83    </rect>
  84    <font>
  85     <face>Arial</face>
  86     <size>8</size>
  87     <weight>normal</weight>
  88    </font>
  89    <hcenter/>
  90    <vcenter/>
  91    <string>#</string>
  92   </label>
  93   <field>
  94    <rect>
  95     <x>140</x>
  96     <y>100</y>
  97     <width>385</width>
  98     <height>20</height>
  99    </rect>
 100    <font>
 101     <face>Arial</face>
 102     <size>10</size>
 103     <weight>bold</weight>
 104    </font>
 105    <left/>
 106    <vcenter/>
 107    <data>
 108     <query>head</query>
 109     <column>salesrep</column>
 110    </data>
 111   </field>
 112   <label>
 113    <rect>
 114     <x>665</x>
 115     <y>200</y>
 116     <width>80</width>
 117     <height>15</height>
 118    </rect>
 119    <font>
 120     <face>Arial</face>
 121     <size>8</size>
 122     <weight>normal</weight>
 123    </font>
 124    <hcenter/>
 125    <vcenter/>
 126    <string>Base Commision</string>
 127   </label>
 128   <label>
 129    <rect>
 130     <x>585</x>
 131     <y>200</y>
 132     <width>80</width>
 133     <height>15</height>
 134    </rect>
 135    <font>
 136     <face>Arial</face>
 137     <size>8</size>
 138     <weight>normal</weight>
 139    </font>
 140    <hcenter/>
 141    <vcenter/>
 142    <string>Base Ext. Price</string>
 143   </label>
 144   <label>
 145    <rect>
 146     <x>30</x>
 147     <y>100</y>
 148     <width>103</width>
 149     <height>20</height>
 150    </rect>
 151    <font>
 152     <face>Arial</face>
 153     <size>10</size>
 154     <weight>normal</weight>
 155    </font>
 156    <right/>
 157    <vcenter/>
 158    <string>Sales Rep:</string>
 159   </label>
 160   <label>
 161    <rect>
 162     <x>425</x>
 163     <y>200</y>
 164     <width>80</width>
 165     <height>15</height>
 166    </rect>
 167    <font>
 168     <face>Arial</face>
 169     <size>8</size>
 170     <weight>normal</weight>
 171    </font>
 172    <left/>
 173    <vcenter/>
 174    <string>Invc. Number</string>
 175   </label>
 176   <label>
 177    <rect>
 178     <x>345</x>
 179     <y>200</y>
 180     <width>80</width>
 181     <height>15</height>
 182    </rect>
 183    <font>
 184     <face>Arial</face>
 185     <size>8</size>
 186     <weight>normal</weight>
 187    </font>
 188    <hcenter/>
 189    <vcenter/>
 190    <string>S/O #</string>
 191   </label>
 192   <label>
 193    <rect>
 194     <x>60</x>
 195     <y>200</y>
 196     <width>106</width>
 197     <height>15</height>
 198    </rect>
 199    <font>
 200     <face>Arial</face>
 201     <size>8</size>
 202     <weight>normal</weight>
 203    </font>
 204    <left/>
 205    <vcenter/>
 206    <string>Sales Rep.</string>
 207   </label>
 208   <label>
 209    <rect>
 210     <x>30</x>
 211     <y>120</y>
 212     <width>103</width>
 213     <height>20</height>
 214    </rect>
 215    <font>
 216     <face>Arial</face>
 217     <size>10</size>
 218     <weight>normal</weight>
 219    </font>
 220    <right/>
 221    <vcenter/>
 222    <string>Start Date:</string>
 223   </label>
 224   <label>
 225    <rect>
 226     <x>220</x>
 227     <y>200</y>
 228     <width>50</width>
 229     <height>15</height>
 230    </rect>
 231    <font>
 232     <face>Arial</face>
 233     <size>8</size>
 234     <weight>normal</weight>
 235    </font>
 236    <hcenter/>
 237    <vcenter/>
 238    <string>Customer</string>
 239   </label>
 240   <field>
 241    <rect>
 242     <x>140</x>
 243     <y>120</y>
 244     <width>200</width>
 245     <height>20</height>
 246    </rect>
 247    <font>
 248     <face>Arial</face>
 249     <size>10</size>
 250     <weight>bold</weight>
 251    </font>
 252    <left/>
 253    <vcenter/>
 254    <data>
 255     <query>head</query>
 256     <column>startdate</column>
 257    </data>
 258   </field>
 259   <label>
 260    <rect>
 261     <x>275</x>
 262     <y>10</y>
 263     <width>450</width>
 264     <height>37</height>
 265    </rect>
 266    <font>
 267     <face>Arial</face>
 268     <size>18</size>
 269     <weight>bold</weight>
 270    </font>
 271    <right/>
 272    <vcenter/>
 273    <string>Brief Earned Commissions</string>
 274   </label>
 275   <field>
 276    <rect>
 277     <x>140</x>
 278     <y>140</y>
 279     <width>200</width>
 280     <height>20</height>
 281    </rect>
 282    <font>
 283     <face>Arial</face>
 284     <size>10</size>
 285     <weight>bold</weight>
 286    </font>
 287    <left/>
 288    <vcenter/>
 289    <data>
 290     <query>head</query>
 291     <column>enddate</column>
 292    </data>
 293   </field>
 294   <label>
 295    <rect>
 296     <x>505</x>
 297     <y>200</y>
 298     <width>80</width>
 299     <height>15</height>
 300    </rect>
 301    <font>
 302     <face>Arial</face>
 303     <size>8</size>
 304     <weight>normal</weight>
 305    </font>
 306    <hcenter/>
 307    <vcenter/>
 308    <string>Invc. Date</string>
 309   </label>
 310  </rpthead>
 311  <pghead>
 312   <firstpage/>
 313   <height>6</height>
 314  </pghead>
 315  <pghead>
 316   <height>26</height>
 317   <label>
 318    <rect>
 319     <x>165</x>
 320     <y>5</y>
 321     <width>50</width>
 322     <height>15</height>
 323    </rect>
 324    <font>
 325     <face>Arial</face>
 326     <size>8</size>
 327     <weight>normal</weight>
 328    </font>
 329    <hcenter/>
 330    <vcenter/>
 331    <string>Cust. #</string>
 332   </label>
 333   <label>
 334    <rect>
 335     <x>585</x>
 336     <y>5</y>
 337     <width>80</width>
 338     <height>15</height>
 339    </rect>
 340    <font>
 341     <face>Arial</face>
 342     <size>8</size>
 343     <weight>normal</weight>
 344    </font>
 345    <hcenter/>
 346    <vcenter/>
 347    <string>Ext. Price</string>
 348   </label>
 349   <label>
 350    <rect>
 351     <x>5</x>
 352     <y>5</y>
 353     <width>50</width>
 354     <height>15</height>
 355    </rect>
 356    <font>
 357     <face>Arial</face>
 358     <size>8</size>
 359     <weight>normal</weight>
 360    </font>
 361    <hcenter/>
 362    <vcenter/>
 363    <string>#</string>
 364   </label>
 365   <label>
 366    <rect>
 367     <x>345</x>
 368     <y>5</y>
 369     <width>80</width>
 370     <height>15</height>
 371    </rect>
 372    <font>
 373     <face>Arial</face>
 374     <size>8</size>
 375     <weight>normal</weight>
 376    </font>
 377    <hcenter/>
 378    <vcenter/>
 379    <string>S/O #</string>
 380   </label>
 381   <label>
 382    <rect>
 383     <x>425</x>
 384     <y>5</y>
 385     <width>80</width>
 386     <height>15</height>
 387    </rect>
 388    <font>
 389     <face>Arial</face>
 390     <size>8</size>
 391     <weight>normal</weight>
 392    </font>
 393    <left/>
 394    <vcenter/>
 395    <string>Invc. Number</string>
 396   </label>
 397   <label>
 398    <rect>
 399     <x>60</x>
 400     <y>5</y>
 401     <width>106</width>
 402     <height>15</height>
 403    </rect>
 404    <font>
 405     <face>Arial</face>
 406     <size>8</size>
 407     <weight>normal</weight>
 408    </font>
 409    <left/>
 410    <vcenter/>
 411    <string>Sales Rep.</string>
 412   </label>
 413   <label>
 414    <rect>
 415     <x>220</x>
 416     <y>5</y>
 417     <width>50</width>
 418     <height>15</height>
 419    </rect>
 420    <font>
 421     <face>Arial</face>
 422     <size>8</size>
 423     <weight>normal</weight>
 424    </font>
 425    <hcenter/>
 426    <vcenter/>
 427    <string>Customer</string>
 428   </label>
 429   <label>
 430    <rect>
 431     <x>665</x>
 432     <y>5</y>
 433     <width>80</width>
 434     <height>15</height>
 435    </rect>
 436    <font>
 437     <face>Arial</face>
 438     <size>8</size>
 439     <weight>normal</weight>
 440    </font>
 441    <hcenter/>
 442    <vcenter/>
 443    <string>Commision</string>
 444   </label>
 445   <line>
 446    <xstart>5</xstart>
 447    <ystart>20</ystart>
 448    <xend>745</xend>
 449    <yend>20</yend>
 450    <weight>2</weight>
 451   </line>
 452   <label>
 453    <rect>
 454     <x>505</x>
 455     <y>5</y>
 456     <width>80</width>
 457     <height>15</height>
 458    </rect>
 459    <font>
 460     <face>Arial</face>
 461     <size>8</size>
 462     <weight>normal</weight>
 463    </font>
 464    <hcenter/>
 465    <vcenter/>
 466    <string>Invc. Date</string>
 467   </label>
 468  </pghead>
 469  <section>
 470   <name>detail</name>
 471   <detail>
 472    <key>
 473     <query>detail</query>
 474    </key>
 475    <height>16</height>
 476    <field>
 477     <rect>
 478      <x>345</x>
 479      <y>0</y>
 480      <width>80</width>
 481      <height>15</height>
 482     </rect>
 483     <font>
 484      <face>Arial</face>
 485      <size>8</size>
 486      <weight>bold</weight>
 487     </font>
 488     <right/>
 489     <vcenter/>
 490     <data>
 491      <query>detail</query>
 492      <column>cohist_ordernumber</column>
 493     </data>
 494    </field>
 495    <field>
 496     <rect>
 497      <x>585</x>
 498      <y>0</y>
 499      <width>80</width>
 500      <height>15</height>
 501     </rect>
 502     <font>
 503      <face>Arial</face>
 504      <size>8</size>
 505      <weight>bold</weight>
 506     </font>
 507     <right/>
 508     <vcenter/>
 509     <data>
 510      <query>detail</query>
 511      <column>f_sumbaseextprice</column>
 512     </data>
 513    </field>
 514    <field>
 515     <rect>
 516      <x>665</x>
 517      <y>0</y>
 518      <width>80</width>
 519      <height>15</height>
 520     </rect>
 521     <font>
 522      <face>Arial</face>
 523      <size>8</size>
 524      <weight>bold</weight>
 525     </font>
 526     <right/>
 527     <vcenter/>
 528     <data>
 529      <query>detail</query>
 530      <column>f_sumbasecommission</column>
 531     </data>
 532    </field>
 533    <field>
 534     <rect>
 535      <x>165</x>
 536      <y>0</y>
 537      <width>50</width>
 538      <height>15</height>
 539     </rect>
 540     <font>
 541      <face>Arial</face>
 542      <size>8</size>
 543      <weight>bold</weight>
 544     </font>
 545     <hcenter/>
 546     <vcenter/>
 547     <data>
 548      <query>detail</query>
 549      <column>cust_number</column>
 550     </data>
 551    </field>
 552    <field>
 553     <rect>
 554      <x>505</x>
 555      <y>0</y>
 556      <width>80</width>
 557      <height>15</height>
 558     </rect>
 559     <font>
 560      <face>Arial</face>
 561      <size>8</size>
 562      <weight>bold</weight>
 563     </font>
 564     <hcenter/>
 565     <vcenter/>
 566     <data>
 567      <query>detail</query>
 568      <column>f_invcdate</column>
 569     </data>
 570    </field>
 571    <field>
 572     <rect>
 573      <x>220</x>
 574      <y>0</y>
 575      <width>120</width>
 576      <height>15</height>
 577     </rect>
 578     <font>
 579      <face>Arial</face>
 580      <size>8</size>
 581      <weight>bold</weight>
 582     </font>
 583     <left/>
 584     <vcenter/>
 585     <data>
 586      <query>detail</query>
 587      <column>cust_name</column>
 588     </data>
 589    </field>
 590    <field>
 591     <rect>
 592      <x>60</x>
 593      <y>0</y>
 594      <width>100</width>
 595      <height>15</height>
 596     </rect>
 597     <font>
 598      <face>Arial</face>
 599      <size>8</size>
 600      <weight>bold</weight>
 601     </font>
 602     <left/>
 603     <vcenter/>
 604     <data>
 605      <query>detail</query>
 606      <column>salesrep_name</column>
 607     </data>
 608    </field>
 609    <field>
 610     <rect>
 611      <x>425</x>
 612      <y>0</y>
 613      <width>80</width>
 614      <height>15</height>
 615     </rect>
 616     <font>
 617      <face>Arial</face>
 618      <size>8</size>
 619      <weight>bold</weight>
 620     </font>
 621     <right/>
 622     <vcenter/>
 623     <data>
 624      <query>detail</query>
 625      <column>cohist_invcnumber</column>
 626     </data>
 627    </field>
 628    <field>
 629     <rect>
 630      <x>5</x>
 631      <y>0</y>
 632      <width>50</width>
 633      <height>15</height>
 634     </rect>
 635     <font>
 636      <face>Arial</face>
 637      <size>8</size>
 638      <weight>bold</weight>
 639     </font>
 640     <hcenter/>
 641     <vcenter/>
 642     <data>
 643      <query>detail</query>
 644      <column>salesrep_number</column>
 645     </data>
 646    </field>
 647   </detail>
 648  </section>
 649  <pgfoot>
 650   <height>16</height>
 651   <label>
 652    <rect>
 653     <x>615</x>
 654     <y>0</y>
 655     <width>85</width>
 656     <height>15</height>
 657    </rect>
 658    <font>
 659     <face>Arial</face>
 660     <size>8</size>
 661     <weight>normal</weight>
 662    </font>
 663    <right/>
 664    <vcenter/>
 665    <string>Page:</string>
 666   </label>
 667   <field>
 668    <rect>
 669     <x>90</x>
 670     <y>0</y>
 671     <width>100</width>
 672     <height>15</height>
 673    </rect>
 674    <font>
 675     <face>Arial</face>
 676     <size>8</size>
 677     <weight>bold</weight>
 678    </font>
 679    <left/>
 680    <vcenter/>
 681    <data>
 682     <query>Context Query</query>
 683     <column>report_date</column>
 684    </data>
 685   </field>
 686   <label>
 687    <rect>
 688     <x>0</x>
 689     <y>0</y>
 690     <width>85</width>
 691     <height>15</height>
 692    </rect>
 693    <font>
 694     <face>Arial</face>
 695     <size>8</size>
 696     <weight>normal</weight>
 697    </font>
 698    <right/>
 699    <vcenter/>
 700    <string>Report Date:</string>
 701   </label>
 702   <field>
 703    <rect>
 704     <x>705</x>
 705     <y>0</y>
 706     <width>40</width>
 707     <height>15</height>
 708    </rect>
 709    <font>
 710     <face>Arial</face>
 711     <size>8</size>
 712     <weight>bold</weight>
 713    </font>
 714    <left/>
 715    <vcenter/>
 716    <data>
 717     <query>Context Query</query>
 718     <column>page_number</column>
 719    </data>
 720   </field>
 721  </pgfoot>
 722  <rptfoot>
 723   <height>16</height>
 724   <label>
 725    <rect>
 726     <x>468</x>
 727     <y>0</y>
 728     <width>80</width>
 729     <height>15</height>
 730    </rect>
 731    <font>
 732     <face>Arial</face>
 733     <size>8</size>
 734     <weight>normal</weight>
 735    </font>
 736    <right/>
 737    <vcenter/>
 738    <string>Totals:</string>
 739   </label>
 740   <field>
 741    <rect>
 742     <x>585</x>
 743     <y>0</y>
 744     <width>80</width>
 745     <height>15</height>
 746    </rect>
 747    <font>
 748     <face>Arial</face>
 749     <size>8</size>
 750     <weight>bold</weight>
 751    </font>
 752    <right/>
 753    <vcenter/>
 754    <data>
 755     <query>detail</query>
 756     <column>sumbaseextprice</column>
 757    </data>
 758    <format builtin="true">money</format>
 759    <tracktotal/>
 760   </field>
 761   <field>
 762    <rect>
 763     <x>665</x>
 764     <y>0</y>
 765     <width>80</width>
 766     <height>15</height>
 767    </rect>
 768    <font>
 769     <face>Arial</face>
 770     <size>8</size>
 771     <weight>bold</weight>
 772    </font>
 773    <right/>
 774    <vcenter/>
 775    <data>
 776     <query>detail</query>
 777     <column>sumbasecommission</column>
 778    </data>
 779    <format builtin="true">money</format>
 780    <tracktotal/>
 781   </field>
 782  </rptfoot>
 783 </report>