About the system layout data must have heard everyone who has ever experienced with the development of reports in "1C: Enterprise 8". At present, the way to develop the report is the fastest and sometimes the most effective. In this article we consider the main opportunities and advantages of the system layout data. What is the layout of the data system (CDS)? First, the system is designed to quickly build various reports, as well as output, which has a complex structure and contains an arbitrary set of tables and charts. In other words, the CDS – is a "programming arm." Ie to develop its report in "1C: Enterprise 8", have enough skills to work with ACS, with the basic settings of the report will be created automatically, and only the developer will correct them for their demands. The layout system data allows for the following features: create a report without programming using the automatically generated forms to view and report settings, partition performance report on the steps, pursuant to separate stages of constructing a report on different computers, independent of a part of the layout of data management of the software running the report. Let us consider in more detail the structure of CDS.
Main elements of the layout of the data presented in the following diagram (Fig. 1): Fig. 1. The structure of the layout of data first, you create a layout data, which describes the query text, data sets, communication between them, the available fields, parameters, data acquisition, and specifies the layout of the original settings – the report design, layout, design data, etc. For example, a layout can contain the following data set (Fig. 2): Fig. 2.
Example of a layout of report layout data, which will receive a developer is not just a table of records that satisfy the query. It has a complex hierarchical structure and can consist of various elements, such as grouping, tables and charts. In this case the developer can modify existing or create entirely new structure of the report, he needs to configure the selection, design elements structure of the report, a transcript of each element, and more. etc. For example, can be given a report structure (Fig. 3). Fig. 3. Example of a report in the report table will consist of journal entries accumulation VypuskProduktsii of products released by the enterprise. These recordings will be grouped by department. In general, the system layout database is a collection of multiple objects. At formation and execution of the report is serial data transfer from one object to another ACS, to obtain the final result – a document shown to the developer. The algorithm of interaction of these objects as follows: a developer creates a layout data and the default settings. In general, based on a single circuit layout data can be a large number of different reports. On the basis of the scheme layout and available settings layout layout layout creates. In this model contains the necessary layout requests, layouts and other areas of the report layout data processor selects from the knowledge base according to the layout configuration, aggregates and prepares the data. The result is processed by the layout processor output, and in the end user receives the resulting spreadsheet document (Figure 4). Fig. 4. Sample output from this report , the ACS has a flexible configuration, ease of handling and the development of new reports of varying complexity and structure in the system "1C: Enterprise 8".