Report

Report defines a report: its query, criteria, sub reports, layout and printing options. It is where the standard design is saved.

Where

Application Configuration › Reports and Widgets (ACRT)

Who uses it

ABS consultants

When

When the product’s configuration is changed

Needs first

Nothing

What it is for

These are configuration screens: they change the product for every client that shares the configuration, so they are worked by ABS consultants, normally on the development system. A report is saved on the development system only. A company’s own design is kept on Client Report Design instead. See Lists, boards and reports.

Every field in plain words

General

Field	What it means	What to put
Report	The report code.	Required. A short code; it cannot be changed once the record exists.
Print Count Field	Field that counts prints.	Optional.
Financial Dimension Criteria	Offers financial dimension criteria.	Tick or leave clear.
Crystal: Map Header and Footer	Maps header and footer (Crystal).	Tick or leave clear.
Offer Print on Letterhead	Offers Print on Letterhead.	Tick or leave clear.
Crystal: Header on Report	Header on the report (Crystal).	Tick or leave clear.
Crystal: Header on Every Page	Header on every page (Crystal).	Tick or leave clear.
Crystal: Footer on Report	Footer on the report (Crystal).	Tick or leave clear.
Crystal: Footer on Every Page	Footer on every page (Crystal).	Tick or leave clear.

Criteria

Column	What it means	What to put
Report	A report.	Optional. Pick from the Report list.
Help Object	The lookup list.	Optional. Pick from the Report list.
Criteria Field	The criteria field. Required.	Optional.
Order	Order.	Optional.
Table Alias in Query	Table alias in the query.	Optional.
Column in Query	Column in the query.	Optional.
Default Value	Default value.	Optional.
Mandatory	Required.	Optional.
Several Values	Several values allowed.	Optional.
Choose Condition	User may choose the comparison.	Optional.
Lookup	Lookup for the value.	Optional. Pick from the Help Object list.
Add to WHERE	Added to the query’s WHERE by itself.	Optional.
Document Number	Holds the document number.	Optional.
Show in Short Form	Shown in the short form.	Optional.
Help Where	Extra condition on the lookup.	Optional.

Sub Reports

Column	What it means	What to put
Sub Report Name	Sub report name.	Optional.
Query (SQL)	The query.	Optional.

Layout

Field	What it means	What to put
Layout	The layout.	Optional.

Query

Field	What it means	What to put
Query (SQL)	The query.	Optional.

How to configure it

These are configuration screens: they change the product for every client that shares the configuration, so they are worked by ABS consultants, normally on the development system.

What it is connected to

• Picked on these company setup screens: Client Report Design, Help Object, Object.
• Picked on POS Setting, POS Till / Register in Sales.

If something looks wrong

• “A report is configuration: it is saved on development only.”
• “Please replace Businessflowconfiguration with «CONF» in report query”