Use of selections in the CCD. Data Layout System - Practice Development System Console - Studying Data Layout System Online Course System Layout System

Expanding query language for data layout system

Expanding the query language for the data layout system is carried out using special syntactic instructions enclosed in curly brackets and placed directly to the text of the query.

Syntax elements for expanding the data layout system query

CHOOSE

This proposal describes the fields that the user can choose to output. After this keywords Through the comma, the pseudonyms of fields from the master list of the query sampling that will be available for configuration are listed.

For example:

(Select Nomenclature, Warehouse)

After the pseudonym, the field can be a combination of characters "*", which means the possibility of using child fields from this field.

For example, an entry nomenclature. * Indicates the possibility of using subsidiaries of the field "Nomenclature" (for example, fields "nomenclature. Code"). The selected item may be present only in the first association request.

WHERE

Fields are described to which the user can apply selection. This proposal uses table fields. The use of aliases of the sampling list fields is unacceptable. Each part of the combination may contain its own element where.

(Where the nomenclature *, warehouse)

Suffen example

It is necessary to get sales for the period + to derive the entire nomenclature, regardless of whether there were sales or not. That is, you need to select data from the price of the sales register, data from the directory nomenclature. We lower the question why we need the whole nomenclature.

To solve the problem, you can make a request that connects the left compound the nomenclature and the sales table of the sale, as a result, for a nomenclature that was not sold in the selected period, we get the values \u200b\u200bof the fields Counterparty, Treaty, number, Sum \u003d NULL. Such a request:

Choose Sprnomenclature. Link as a nomenclature, sale.

Here is the result:

Counterparty	Treaty	Nomenclature	number	Sum
NULL	nULL	_Test1	nULL	nULL
LLC "Rog and hooves"	Contract1	Slippers	10	1200
"Gazprom"	Cool contract	Boots	5	13000
nULL	nULL	Galoshi	nULL	nULL
nULL	nULL	Shale	nULL	nULL

IN this example There was no sales of the nomenclature: "Galoshi" and "shale"

And anything, if we grouped a sample on the counterparty, the entire non-selling nomenclature will fall into a separate grouping, where the counterpart \u003d , but the client wants to have an arbitrary selection on the counterparty field (naturally mean a counterparty from the sale register). How to be? After all, in essence, we need to filter only the table Sales. If we use autocomplete in the designer of the CCD, then the field will get the field Counterparty, everything seems to be good, but when executing a report with the selection according to the counterparty, we will lose all records from the connection with the nomenclature. For example, install the selection: Counterparty \u003d LLC "Rog and hooves". The result will look like this:

Not at all what we need, right?

To solve the task, you can of course add a parameter to a request, for example, in the parameters of the virtual table ReceivedBut at the same time the flexibility of the type of comparison type is lost.

The solution is: for this in designer requests On the tab Data layout => Tables Add a field condition to the conditions of the virtual table Received and change him alias on Counterpartybor.

In order not to confuse the user with the selection fields, turn off the condition field Counterparty and change the header for the field Counterpartybor.

As a result of the execution of this scheme with the on-selected partition, the resulting request will take the form:

Choose a sprounce. Link as a nomenclature, and recesses. Contractor as a counterparty, and reinforcement. CONTRAFTERGENT AS CONTRIBUTURENT TRANSFER, INCLUDESS. COLOR WORLD OBJECT as\u003e Quantity, Requires Sprnomenclature. Representation as a nomenclature representation from the reference book. Nomelaclature as a sprnomensclature Left connection of the regisparnation. Sale. Rotates (& p ,,, counterparty \u003d & p3) How to research on Sprnomenclature. Link \u003d SALES.

And, accordingly, the result:

Counterparty	Treaty	Nomenclature	number	Sum
NULL	nULL	_Test1	nULL	nULL
LLC "Rog and hooves"	Contract1	Slippers	10	1200
NULL	NULL	Boots	nULL	nULL
nULL	nULL	Galoshi	nULL	nULL
NULL	nULL	Shale	nULL	nULL

Test1 is a group in the Handbook of the Nomenclature, in which everything lies

The Publication is attached to the XML diagram of the report used to publish. The scheme created in the complex automation, but I think everything will work perfectly and in the UPP and in UT 10

Summarizing

This example shows how to create your selection settings in the LCD and turn off the road output if you design the scheme with the flag on Autocomplete.

If you have enough experience to create schemes without using Auto-complete - This advice does not make sense.

Used software

• Program for creating screenshotsSnimok!
• XML file editor

There were times, sitting without work, developed a course on the SCD, thought to teach it in the online dirzy through the Internet. Now there is no time, there is no time to teach it. I saw your project, I think you can use it

Sincerely, Dmitry Salikhov.

IN this course There is both theoretical and practical side of the foundations (and not only thereof) work with the layout. In fact, in a small methodical manual, Dmitry, almost everything is collected, with which programmers are facing when using the CCD.

What is the course?

The course consists of methodical manual In PDF format on 63 sheets. The heads of the manual are decorated like articles on this resource. Those. The theoretic part reinforced with screenshots.
Also, the course is attached to the discharge of the test base (format.dt) and external reports, examples of which are considered in the methodological manual.

What questions are addressed in the course?

As I said, everything is being considered to know the programmer using the CC. Examples from a simple report without programming, to program work with decoding, etc.

• Step one. Simple report without coding;
• A bit of theory. Data layout system device;
• Step second. Working with parameters and selections;
• Step Three. Work with various data sets. External data sets;
• Step fourth. Data layout layouts. Creating your own layouts;
• Pitch fifth. Use characteristics. Conditional design. Calculated fields;
• Step six. Decoding

The end result of the accounting in any program 1C is reports - a means of analyzing data, representing the result of activity and its results. The version 8 platform shows a powerful report development tool - Data layout system. The CCD makes it easy and quickly prepare the desired type of output form (printed document, graphics, consolidated tables) By providing the user flexible settings, effectively using system resources.

You can learn how to develop reports only in the process of solving practical problems. That is why the specialists of the center V8 created a program Practice of application of SKD 1c enterprise 8allowing consultants and developers not only to get acquainted with reporting technology, but also get practical experience their settings from scratch.

At the heart of the training program Practice of the use of SCD Les interactive technology:

Creating reports (practical tasks) directly in the program 1C;

System automatic check solutions;

Qualitative methodical materials;

Technical support for students.

The CCD study program presents several dozen tasks - from creating a simple report before the formation of a multipurpose data analysis tool. Training provides for the user of basic knowledge under the program of use of the query language.

Detailed description of the topics studied

Practical tasks are presented to the following sections:

- Creating simple reports:

Simple report without program code
- generating data lists
- Basic settings Report presentation

- The main possibilities of the CCD and the design of the data layout scheme:

Setting up report fields
- The calculation of the results of resources
- Management of general outcome
- Data output in cross-table
- Communication of multiple data sources
- Combining multiple data sources
- Calculated and custom fields
- Using parameters in the report
- standard periods in the report parameters
- Installation of predefined parameter values
- Using a group of selections
- description of the report group and charts

- Report submission:

Configuring Presentation and Grouping Fields
- location of fields and groups
- Conditional registration in the report
- Setting up a layout for report regions

- Extended CCD capabilities:

Conclusion of a growing outcome
- Addition period
- Using the frequency of cars
- output features of objects in the report
- complex calculated fields with expressions
- calculated data sorting value
- withdrawal of extended field values
- Submission of results for weeks
- Setup Report Group Invested Schemes

- Independent work (several tasks).

The tasks consider the features of the SCD platform 1c enterprise 8.3.

The SCD study program is certified by 1C and is recommended not only for independent training of technical specialists, but also for the organization of the educational process in the framework of CSO, AUTS, training centers, etc.

The presence of rights to use the platform is not mandatory.

Start work

Select the program with the program:

Installation instructions for your computer

1. Install and configure training version 1c on your computer

Run the downloaded file setup.exe.
(in case of danger warning, allow the file launch);

Follow the installation program instructions.

Important! The program requires connecting to the Internet.

3. Start the training program and select the information base.

Run the learning program through the Label Site Label on the desktop;
- in the list information bases Select previously created;
- Start "1C: Enterprise".

You can also expand the methodological support for the free program,

Description

Program capabilities:

Creating reports directly in the 1C program (setting up layout circuits);
- checking the settings of the CCD and issuance of error information;
- availability of personal statistics on setting tasks;
- Ability to view the general ranking of participants;
- technical support students;
- Methodical materials and documentation on the skc and platform 1c enterprise 8;
- Recommendations for solving applications for creating reports;
- Access to illustrated instructions containing descriptions of the report configuration features.

Novice and advanced technical specialists who wish to master the features of the technology of creating reports on the CCD. Specialists 1C Enterprise 7.7 The product will help to quickly adapt in the 1c enterprise's platform technologies.

- Select Course - Course Microsoft Office. Excel - 16h Course Microsoft Office PowerPoint - 18h Intensive Seminar Technology Creating Financial Models in Excel - 8h Express Workshop Applied Budgeting For Beginners - 8Ch Course Operator 1C Wide Profile - 26h Course Operator 1C - 16h Course 1C Accounting 8 Red.3.0.Practical Mastering accounting from the very beginning - 80 h Course 1C Accounting 8 Red.3.0. Using the configuration - 32h Course 1C Accounting Course 8 - 24h Course Step by step transition to new budget accounting standards in 1C: Accounting of the State Institution 8 - 16h Seminar 1C Features of VAT accounting in Program 1C: Company Accounting 8 (Edition 3.0) - 8C Seminar Calculations with accountable persons: from theory before practice in 1C: Accounting 8 - 6h seminar Accounting for foreign employees in 1C: ZUP 8 - 8h Seminar Children in 1C: ZUP 8 - 8h VAT seminar and income tax 2019 - 7 hours Salary 2019 Seminar 2019 - 7 h. Seminar Financial Analysis for an accountant - 7 hours. Seminar Accounting for WED operations - 7 hours. Course 1C Error in accounting - Find and neutralize! - 9h Course 1C Simple Transition to VAT 20% - 5h Course 1C Accounting VAT (value added tax) - 24h Course 1C Accounting 8. First steps - 10h Course 1C Salary and personnel management 8. First steps - 10h Course 1C Trade Management 8 . First steps - 10h Course 1C: Enterprise 8 Tax Account Automation - 24h Course Theory accounting For beginners - 24h Course 1C Trade management Editorial board 11.3 - 40h Course 1C Trade management 8, ed.11. In-depth study of the program's capabilities - 32h Course 1C Personnel Management 8 - 16h Course 1C Salary and Personnel Management 8 Ed. 3.1 - 32h Course 1C Theory and Practice of Payroll in 1c Enterprise 8 - 80h Course 1C Salary and Frames of the Budgetary Institution - 32h Course Personnel Accounting in 1C: Salary and Personnel Management 3.0 - 24h Express Course Management Accounting in 1C: Salary and Management Personnel Corp - 6h Course 1C Retail 8. Using the Configuration - 20h Course 1C: Comprehensive Automation 8 - 40h Course 1C: Comprehensive Automation 8. Trading Operations - 24h Course 1C: Complex Automation 8. Regulated Accounting - 32h Course Operational Management In Male Business using the program 1C management of our company 8, Red.1.4 - 24h Course 1C: Document Drive 8 - 16h Course 1C UPP 8. (Red.1.3) Concept and Trade Functional - 24h Course 1C UPP 8. (Red.1.3) Planning and budgeting - 16h Course 1C UPP 8. (Ed. 1.3) Regulated Accounting, Frames, Salary - 24h Course 1C UPP 8. (Ed. 1.3) Production Accounting - 16h Course Concept Applied Solution 1C: ERP Enterprise Management 2 - 24h Course Manufacturing and repairs in the application solution 1C: ERP Enterprise Management 2 - 32ч Course Management Costs, Financial Results in Applied Solution 1C: ERP Enterprise Management 2 - 24h Course Application Solution Concept 1C: ERP Enterprise Management 2 - 24h Course Content Manager 1c -Bitrix: Management site. Basic course - 16h Course Administrator 1c-Bitrix: Site Management "and" 1C-Bitrix24: Corporate Portal "- 16h Course Developer 1C-Bitrix: Site Management" and "1C-Bitrix24: Corporate Portal" - 16h Course Developer 1C-Bitrix: Site Management "And" 1C-Bitrix24: Corporate portal. Level 2 "- 16h Course 1C Enterprise. Introduction to Configuration - 24h Course Aza Programming in System 1C: Enterprise 8.3 - 24h Course Integration Tools and Data Exchange System Enterprise 8 - 24h Course Using Query Language in System 1C Enterprise 8.3 - 24h Course 1C Data Layout System - Drawing up Reports in the System "1C: Enterprise 8" - 24h Course Administration System 1C: Enterprise 8 - 32h Course 1C Accounting When applying a simplified taxation system in 1C: Accounting 8 - 24h Course 1C: Enterprise 8. Solution of operational Tasks - 16h Course 1C Configuration in System 1C: Enterprise 8.3 Decision of accounting tasks - 24h Course 1C Configuration in System 1C: Enterprise 8. Solution of settlement tasks - 20h Course Basics graphic design in Adobe Photoshop. For beginners - 16h course Practical use Bit.Finance in the part of the Treasury Subsystems and Budgeting - 32h Course Practical Settings Mechanism of Broadcasting in Bit. Finance - 16h CCS Course "Practice Application of the Program" 1C: Accounting 8 "in manufacturing enterprises - 16 AK. h. CCM Course Practice Application of the Program "1C: Accounting 8" in trade - 16h CCS Course Practice Application of the Program "1C: Accounting 8" in the service sector - 16h Course Practical application BIT. FINANCE IN PARTS OF IFRS AND CONSOLIDATION - 24h Course Practical Application Bit.Finance in part of the Subsystem Contract Management - 16h Course Bit. Building Module Contractor - 16h Course Bit. Building. For payment - 4h Course Bit. Building Module "Supply and Warehouse" - 16h Course Fast start In the program "Bit.ZhKKh 8" - 8h course of benefits and recalculation in the program "Bit.ZhKKh 8" - 8Ch Course Integration of BIT.ZhKX and "1C: Accounting Professional" - 8h Seminar 1C: Managing Trade 8 Ed.11.3 for warehouse staff and 1C operators - 8 h Seminar 1C: Trade Management 8 Ed.11.3 For employees of the warehouse and operators 1C - 8h Seminar 1C: Managing Trade 8 Ed.11.3 For employees of the warehouse and operators 1C - 8C seminar 1c, the maintenance of tax accounting and reflection In the program 1C: Accounting 8 - 5h Seminar Features of VAT accounting in the program 1C Accounting company 8 (editors 3.0) - 10h Seminar Advanced Accounting for fixed assets in the program 1C Accounting 8 Edition 3.0 - 6h Seminar OPP for Accountant - 6h Course 1C: Salary and Management personnel. Transition C 2.5 to version 3.1 School of Programming for Children Tutorial 1C Participation in the action I find it difficult to answer / another course

The data layout system (CCD) is a powerful 1c platform mechanism (8.2 and newer) to develop reports, and not at all the access control system.

What was the "Data Layout System" for? The system was invented in order to declaratively create reports. The report is created without the need to write program code. Using a specific designer and settings produced in it, the programmer sets desired result, the data layout system understands and displays this result to the user. If it took something to change in the report, it is enough to turn to the constructor again, make the necessary changes, and the changed report is ready.

Video tutorial to create a report "Document Journal" in 1CKD:

At the same time, since the system is in principle universal, for all occasions, there is a huge number of settings at the programmer. With all the abundance of choice, the most perhaps unpleasant is that some settings in the data layout circuit are designed to solve quite rarely implemented tasks.

Get 267 video tutorials for 1C for free:

All this, of course, climbs the layout diagram, and the inexperienced specialist understand it is quite difficult. Since when opening the designer, it appears a huge number of different settings, the meaning of which is sometimes not obvious.

Despite the fact that CCD in 1C 8.3 can be created interactively using the appropriate designer, you can and programmatically perform the same actions. You can go from the very beginning. Software Create a data layout scheme, perform all necessary settings, Create a configuration of the report option, complain the report and display it to the user to the screen. This is a more laborious task, but still performing.

It is also worth noting that the data layout system is used not only in the process of creating a report. If you wish, you can also implement the printed form of the document using the data layout circuit. The principal difficulties are not observed here, but it is important to understand to create such printed forms, as the overall system works and from which interconnected elements it consists.

The basis of the controlled interface 1C - SCD

In concept managed forms Also lies the system layout system. All selections, conditional design settings, which we have for, exactly the same as the LCD. It is also worth noting that all the elements of the CCD have the ability to be implemented. Therefore, we can create a software diagram using staten tools Platforms, and except for this and external means it is possible to operate.

How to master and learn how to make reports on the CCD?