HelpPages

Home | Configuration | New Report | New Report Basic

New Report Basic

   To design a basic report of a single line, you must access the new report option, fill in the corresponding title or name of the report in the box and leave the multiline box unchecked. If this report will be part of a multiline report and do not wish to appear on the menu, we must check the avoid menu box.

    Then select the main table that bring the statistical data. Normally it will be tables of movements.

    Then indicate the fields that will be used to limit the selection of data in the table. We use L, when we want the data to go between limits (to), and S when we want a selective data.

    Finally we access the screen for detailed report settings.

                        -----------------------

   Axis X. In this box indicate the expression to calculate the coordinate X. In many cases it is derived from the date of the data. If the data correspond to the X coordinate of the days of month or months of the year, they will not require any correction while for the year it is usual to substract the initial year. The following shows how to extract day, month and year of a date:

- Day:   D=FN#VALN(FN$MIDS(TABLE_FIELD{};7;2))
- Month: M=FN#VALN(FN$MIDS(TABLE_FIELD{},5,2))
- Year:  Y=FN#VALN(FN$MIDS(TABLE_FIELD{},1,4))

    If we want a graphical representation for years, usually we will not do it from the year zero, so we have to subtract the calculated year by the above formula, the base year or date corresponding to the initial date:

Y=FN#VALN(FN$MIDS(TABLE_FIELD{},1,4))-FN#VALN(FN$MIDS(_ACCEPT$(n),1,4)) where n is the number of edit box where we have introduced the initial date.

                        -----------------------

   Axis Y. The coordinate Y is usually easier to calculate since it coincides with the value we want to show in the graph. Imagine a table with one row per year with a value  in the VALUE{} field. The expression to represent these values would be simply VALUE{}. It is slightly complicated when we have more than one row per year, since we have to accumulate values. It's all we do with the expression S#(_n_)+VALUE{} where S# is the storage variable.

                        -----------------------

   Reset. The expression of this box is processed at the beginning of each calculation. You must set the dimension of the storage variable to use, with the number of coordinates X we use. For example S#(12) tells us that we will have a maximum of twelve values for the storage variable. We must also reset to zero these values for if the statistics is repeated. FN#ACUM function is often very suitable for this, such as FN# ACUM(S#(x)=0;x;0;12). The value returned by the expression must be alphanumeric and is used for labels  in the base of the graph. An example might be this:

   S#(12);FN#ACUM(S#(x)=0;x;0;12);'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec'

                        -----------------------

   Scan Condition. In this box we can indicate an expression to filter data within the set limits, if necessary.

                        -----------------------

   Store variables Here we indicate the storage variable used excluding parentheses. For the current example would be S#.