Reports are used to retrieve data from a 1C:Enterprise infobase.
In 1C:Enterprise mode, you can generate a report with predefined settings or customize the settings. Experienced users can create custom report options.
A typical appearance of a report form is shown below.
To generate a report with the predefined settings, in the report command bar, click Create.
If multiple options are provided for a report, you need to select an option before creating the report by clicking the Select option button. For more information about report options, see chapter "5.2. Report options".
To customize a report, you can use either the quick settings field or a dedicated dialog box opened by clicking the Settings button. For more information about report settings, see sections "5.3.1. Using quick settings" and "5.3.2. Settings".
Once a report is generated and displayed as a spreadsheet document, you can use the drill down feature. For more information, see section "5.4. Drilling down".
Depending on the report settings, a report form may include the following commands on the More menu:
- Settings. Open the report settings.
- Select settings. Load previously saved report settings.
- Save settings. Save the report settings.
- Set standard settings. Load the default settings for the current report option.
- Delete saved chart colors - cancel chart color user settings. It is displayed, only if charts are available in report option settings;
- Change option. Open the report option settings.
- Select option. Select a report option.
- Save option. Save the report option.
- Open a new window. Open a new report window with the current settings applied.
- Change form. Open the report form settings.
For more information about report settings, see sections "Using quick settings" and "Report options" later in this document.
For more information about drilling down, see section "5.4. Drilling down".
NOTE. The example figures show forms where system commands are hidden.
5.1. Customizing reports
You can edit some report settings in a new window. When a report is created, these settings are applied in addition to the main report settings.
To open the settings editor window, in the report form, click Settings.
To save the settings, click Finish editing.
To edit the settings displayed in the report form, click More – Change settings assortment. This opens a settings list editing form.
All available report settings are listed on the left, and the settings displayed in the report form are on the right.
To change the user settings list, use the following buttons:
- Add. Adds a setting from the list on the left to the right.
- Add all. Adds all settings from the list on the left to the right.
- Remove. Removes a setting from the list on the right.
- Remove all. Removes all settings from the list on the right.
To restore the default settings list, click More – Set default settings.
If editing the settings does not give you the report that you want, you can create a custom report option. This feature is recommended for experienced users only. For more information about report options, see chapter "Chapter 6. Report options".
When a report form is closed or a current report option is changed, the customized settings are saved automatically (separately for each report option).
You can select some frequently used settings (for example, filter by product in a Sales dynamics report or filter by company in an accounting report) to edit them directly in the report form.
If you set a filter in the report settings form, a filter item is added to the settings list and to the settings displayed in the report form.
To use a setting in a report, specify its value
by doing one of the following (depending on the setting type):
- In the setting field, click Select and select a value from the list.
- In the setting field, click Select and select a value in a new window.
The following figure shows editing a report setting.
When you finish editing report settings, the report is not generated automatically.
To generate a report with the new settings, click Create.
To disable the use of a setting in a report, clear the respective check box.
A report can have multiple options. Each report option defines a view for data displayed in a report. For example, for a Sales dynamics report, you can create an option where sales of goods by period are displayed as a chart and another option where sales by customer are displayed as a table. Each report option has its own list of settings.
You can create report options in 1C:Enterprise mode. Before doing this, carefully study section Chapter 6. Report options. Once you start creating a report option, the new option is saved to the infobase.
You can create multiple options for each report.
For detailed information about customizing report settings, see chapter "Chapter 6. Report options".
5.3. Using reports
Let us study the report operations on the example of a Sales dynamics report of the managed application demo configuration. To run the report, use a command on the actions panel. This opens the report form.
When you open the report for the first time, the Chart by Periods option is selected. To view another option,
click Select option and then click Sales of Goods by Customers.
Note that the following settings have been selected for this report option: Period: This year and grouping by Product and Customer fields.
To view the report, click Create.
NOTE. If a report contains a single table or grouping, the report header is automatically docked for viewing convenience. But if the header size exceeds the visible area, it is not docked.
For example, to generate a report for a custom period, change the Period parameter and click Create.
If the displayed report parameters (Period and Grouping) are not sufficient for getting the report view that you want, you can view all available report option parameters by clicking Settings. This opens a new window with several tabs.
To set a filter, click the Filter tab.
- On the command bar of the tab, click Add new item or drag a field from the Available fields list to the list on the right.
- In the Comparison type column, click Select to select the comparison type.
- To set a filter value, click Select and select a value from the list, or enter a value.
- To change the order of filter items, select an item and then, on the More menu, click Move up or Move down. To group filter items, select them and click Group conditions.
- Click Finish editing.
For more information about filters and comparison types, see section "188.8.131.52. Filters".
To specify sorting for report lines, click the Order tab.
On the tab, click Add new item or drag a field from the Available fields list to the list on the right. You can also add an auto order item by clicking Add new auto order item. For more information about auto order items, see section "184.108.40.206. Sorting".
- Select Sort direction (Ascending / Descending).
- To change the order of order items, select an item and then, on the More menu, click Move up or Move down.
- Click Finish editing.
If you specify multiple order items, the report data is sorted by the first field followed by the second field, and so on.
For more information about sorting, see section "220.127.116.11. Sorting".
For example, to sort the Payments report by supplier and by document date for each supplier, use the following settings:
Then click Finish editing. The resulting report looks as follows:
To specify conditional appearance for report lines, click the Conditional Appearance tab. On the tab, click Add and specify the appearance settings.
- On the Format tab, specify the appearance parameters: background color, font color, and so on.
- On the Condition tab, specify the condition for applying the formatting. It is similar to specifying filter conditions.
- On the Formatted fields tab, select the fields where the appearance is applied when the condition is met.
- To change the order of conditional appearance items, select an item and then, on the More menu, click Move up or Move down.
The order of appearance items defines the order of applying them to report items. If several conditional appearances are applicable to a field, the last one is applied.
- On the Additional tab, select the report areas to apply the conditional appearance.
- Click Finish editing.
For more information about conditional appearance, see section "18.104.22.168. Using conditional appearance in lists".
Conditional appearance example
To highlight documents associated with Electronics store in the Payments report,
open the report settings and do the following:
- On the Conditional appearance tab, add a conditional appearance item.
- On the Format tab, in the Font row, click the selection button and then, in the Select font dialog box, select the Bold check box.
- On the Condition tab, add the following condition: Contractor Equal to "Animal Husbandry, LLC".
- Click OK and ensure that the value in the Formatted fields column is <All fields> and the value in the Usage area column is <Always>.
The setting for a conditional appearance of a report will look as shown below:
In the report option settings dialog box, click Finish editing. The resulting report looks as follows:
To specify grouping for report lines, click the Grouping tab.
- Click Add
- Select Field for grouping and specify the grouping type:
- Elements. The group only includes nonhierarchical records (items).
- Hierarchy. The group includes both hierarchical and nonhierarchical records (items and folders).
- Hierarchy only. The group only includes hierarchical records (folders).
- Click Finish editing.
- To change the order of groupings, select an item and then click More – Move up or Move down.
- In the report grouping settings dialog box, click Finish editing.
For more information about groupings, see section "22.214.171.124. Grouped fields".
For example, to group the Payments report by supplier, select the Supplier field with Hierarchy type.
The resulting report looks as follows:
When you move the pointer over a report cell that can be drilled down, the pointer changes (see the figure). Double-clicking that cell opens the cell value in a new window, while double-clicking a cell with resources prompts you to select a field for drilling down and then displays the result.
Right-clicking the cell displays its drill-down menu.
Drill down displays detailed information about the field value. All drilled-down details are displayed in a new window.
For example, to find out when Bosch15 kettles were sold, you can create a Sales dynamics report, click the Bosch15 cell, run the Drill down command, and then, in the field selection window, select Period.
Once you click Select, the details are displayed in a new window.
The Open "..." command opens a form for viewing cell data. For example, a list item form.
The Filter by command filters the current report structure item by the value of the selected field. To set a filter by another field, click Other field and specify a filter condition. For example, you can filter the report to display only rows with Amount (Turnover) over 10,000:
The result is displayed in a new window.
The Order by command orders the current report structure item by the value of the selected field. To order by another field, click Other field and specify a field. For example, you can order a report by the Product field.
The Group by command sets a grouping by the value of the selected field for the current report structure item. For example, in the Inventory Balance report, to find out which goods are available in each warehouse, apply grouping by Warehouse field.
Then filter the report by Product In group "Footwear". The resulting report looks as follows:
The Apply Appearance command sets conditional appearance for the current report structure item. For example, you can highlight the fields where Quantity Balance < 10 items.
Search everywhere launches the global search for data by the value in the selected cell. To alternatively start global search, press Alt + F. For more information, see section "8.1. Global Search".