WinVask -  Faktura

Update Total Window

Update Total Window

Previous topic Next topic  

Update Total Window

Previous topic Next topic  

frb_bm53

 

The above screen capture shows the dialogue box used to create a temporary variable (storied in the computer's memory) that can temporarily store information as the report is being generated. This screen is accessed from the Dictionary.

 

Each of the entry fields (as shown above) require information from you to define the information that is gathered as the report is being generated:

 

ð        Assign Name: This entry field is blank by default; the above screen capture shows TOT2:Quantity as the fictional name for this variable. It is a good idea to create a name that resembles the content of the variable, and use a standardized naming convention. It is a good idea to use the standardized naming convention of PREFIX:NAME when defining variables; the prefix can be 1-4 characters in length; the colon character (:) is mandatory, and then a name that can be 1-12 characters in length. By using the same prefix name (e.g. TOT2) you will be able to more easily find and understand their purpose in the Report Builder.
ð        Field/Expression To Total: Click the button to the right of the entry field to display the Dictionary to help select the database field(s) that you want to be added together as the report is being generated.
ð        Picture: Click the button to the right of the entry field to display the Picture Wizard to define how this variable will be printed onto the report page.
ð        Total Type: The droplist has the following options available to define what action to take on the "field/expression to total" database field that you selected:
ð        Sum
ð        Average
ð        Count
ð        Minimum
ð        Maximum
ð        Evaluate
ð        Evaluate On: The droplist has the following options available to define when to do something against the "field/expression to total" database field that you selected:
ð        At each record retrieve
ð        At the end of the group
ð        At the end of the report
ð        At the end of every page