PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 359.3836 ms
"
  6613 | 1 | |
Label


Running total (cumulative sum) represents sum of all data on the databand from the beginning of report or from the beginning of the band until the record which is currently displayed. In Pantheon we use running total for example for displaying stock quantity and value. It can be displayed in every row or only at the end.

Example of using running total is on report '18A - Record on Retail Sale and Purchase of Goods' that is in the program menu 'Goods | Invoice Issued Report | Commercial Records'.


  var
    nNabavaNeto, nSalePrice: Double;

...

  procedure DetailOnBeforePrint(Sender: TfrxComponent);
  begin
    if (<Line#> <> 1) or (<qReportIzpis."acKey"> <> '0000000000000') then   // ignore initial balance if it exists
    begin
      nNabavaNeto := nNabavaNeto + <qReportIzpis."NabavaNeto">;
      nSalePrice  := nSalePrice  + <qReportIzpis."anSalePrice">;
    end;
  end

...

begin
  nNabavaNeto := 0;
  nSalePrice := 0;
end

Let's analize this example.

At the top of the code are declared variables  nNabavaNeto and nSalePrice. They hold values in the period, defined by report criteria (without initial balance). Then on "OnBeforePrint" event values of purchase, receiving of goods and goods sales are added. Finally variables are displayed in the report summary.

  

     


Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!