PostERP developers can design reports at will and seamlessly merge them to thin client by attaching them to any screen. End users can then either preview and print these reports or output the SQL results to file. Virtually all database tables can be used as the data source of reports.
To embed parameters in SQL for end users' input, add symbol : in front of that symbol like this:
Now bd and ed are two parameters. Switch to page Parameter and specify their purposes and meanings and then these parameters are ready for end user's input.
If type casting PostgreSQL columns is required, type cast it like this: CAST(f1 AS TEXT) rather than this: f1::TEXT, which will confuse PostERP thin client program (and cloud version's report server).
PostERP provides handy PostgreSQL fuctions MonthBegin() and MonthEnd() as described in Chapter 8.
PostERP protects SQL injection attack. Because end users can only enter parameters for reporting. PostERP subsequently insert these parameters into SQL text. PostgreSQL aborts the SQL execution when it encounters an invalid SQL text.
System development tasks can be performed using either cloud version or desktop version of PostERP. There is, however, one exception - report template design can only be done on desktop version.
Tera Rows's partner developers will therefore download thin client program tc.exe from GitLab and use it to design report templates. Run the tc.exe and connect to your development server whose IP address is shown on this web page after you sign in as a partner developer.
The current version of PostERP can print only Bitmap and JPEG at this moment.
The main DataSet name in static report templates must be mds.
Leverage PostERP internationalization features to design report templates for end users speaking various languages by utilizing these techniques:
Refer to Section 17.1 for information about setting phrases.
Imagine you are designing a report template which has a field title "Employee Name" in English. Because this report template will be used by global users speaking various languages, directly embedding constant literal Employee Name in this template apparently will not work for non-English speaking users.
The correct approach is adding a report field with value C245. Here literal C is constant and must not be changed, and number 245, which immediately follows constant literal C, is the phrase# (not the long description#). With this set, end users will get Employee Name in their own languages when running this report.
This variable (case sensitive) will be substituted by the report name (not the long report description) when end users run reports.
PostERP converts the variables embedded in SQL text (see Section 17.9.1) to report variables (case sensitive). The values entered by end users when running reports are taken by report variables and displayed as the corresponding report field values.
This variable (case sensitive) will be substituted by the working company name in active language when end users run reports. This variable is most frequently used as report title.
If Image elements exist in template and meet all the following conditions, PostERP automatically prints company logo in those elements.
Image source: selects option Database field:.
DataSetCompanyLogo.logo (case sensitive) is filled in the box to the right of Database field:.
Logo will be retrieved from table.column t45.f5 in database.
Report outputs can be saved to files in Excel format.
Some report template design can not be achieved by using only one SQL.
Take accounting journal in PostERP as an example. Amount records are indexed by sequence#. Every sequence# associates with multiple tag. Given such schema, if we place the data set extracted by a single SELECT command on report detail band and sub-total the amount field, we will get wrong amount sub-total, which is the sub-total of amount in detail records of duplicated occurrences determined by the number of tag rows associated with its sequence#.
The correct solution for designing such reports is utilizing sub report technique.
Please refer to report# 3 attached on screen [MzF5].
Please refer to report# 1 and report# 2 attached on screen [MzF5].