Lesson 13 (4:30). Reports
Since the overall duration of the lesson is quite long, you can go through the lesson in parts and pause after the development of each of the six reports included in the lesson.
Now it is time to learn the data composition system, which is a significant part of the 1C:Enterprise platform. In this lesson you will implement several reports for your configuration. We will explain the main features of the data composition system on the example of these reports.
As a rule, a report is based on a complex selection of data that is grouped and ordered as specified. The data composition system is a powerful and flexible tool covering all major report functionality, from obtaining data from various sources to displaying the data in a user-friendly manner.
In most scenarios the report source data is located in the database. You can use 1C:Enterprise query language for specifying the data sources for the data composition system and which data is retrieved from these sources.
On the report development stage you can define the default report settings, so that users can run the report right away. At the same time a user can change the report settings manually and then run the report. At that the data composition system generates another query and presents the result in a different manner, according to the user-specified settings.
At the beginning of the lesson we will provide general information about the 1C:Enterprise query language and the data composition system.
Then we will explain how to use the data composition system for solving practical tasks on the example of several reports.
- Theory. Data access methods
- Selecting data from a single table
- Selecting data from two tables
- Breaking down by days in the selected period
- Getting current values from a periodic information register
- Using calculated fields in reports
- Displaying data as a spreadsheet
- Theory. Virtual query tables