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

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