1C Using the CCD. The first report on the CCD. Create a data layout circuit inside the report

Suppose that the task is to create a report on all Documents "Implementation Services", which contain the positions of the nomenclature from the specified group. Since we will work with a managed form, create a built-in report in the configuration with the title "Test Report" and select the basic data layout diagram (Fig. 1).

Fig. 1. Creating a report

In the form that appears, you use the "Add Data Set" button and select "Add Data Set - Request" (Fig. 2)

Fig. 2. Add data set

To create a query, we will use the query constructor. Select from the "Database" panel Document "ImplementationServices" and its table part "Implementation of the service. In the "Table" panel, from the corresponding tables, select the fields - "Implementation of the service link" and "Implementation of the service. Nonenclature. Link" (Fig. 3).

Fig. 3. Creating a request

The connection between the tables will be automatically created, so we can press the "OK" button in the query constructor. Data Set - Request Ready (Fig.4).

Fig. 4. Data Set - Request

Settings

For proper work The report must specify which information will be displayed in the report. Press the "Open Settings Designer" button (Fig. 5)

Fig. 5. Constructor settings

Select the report type - list and click the Next button. Select the available fields - reference and nomenclature (Fig. 6.), after which you can click the "OK" button.

Fig. 6. Selecting the report fields

In principle, our report is ready. But in the task it was necessary to obtain not all the data, but to use the selection according to the nomenclature from the chosen group. Allowed the user to use the selection. To do this, on the "Settings" tab, we use the "Custom Settings Item Properties" button and select the selection (Fig. 7.)

Fig. 7. Custom settings

Press the "OK" button, and on this our settings are completed (Fig. 7).

To correctly call a report, it must be included in one of the subsystems. Let it be in the "Sales" subsystem (Fig. 8)

Fig. 8. Sale subsystem

Our report is ready! Update the database configuration and launch 1C: Enterprise. Go to the "Sales" subsystem and call a "test report" and then, the "Shape" button (Fig. 9.)

Fig. 9. Calling a report

By the terms of the task, we need to set the condition in the selection so that the nomenclature belongs to a certain group. To do this, choose the right setting field. Selection. The form "Editing selection" opens. By dragging from the available field fields. The nomenclature in the selection field, in the "Type of Comparison" column set "in the group", and in the "Value" column choose the group of the nomenclature " Appliances"(Fig. 10.)

Fig. 10. Setting the selection

Press the "OK" button, we form a re-selection report, and the task is solved (Fig. 11).

Fig. 11. Selection by group of nomenclature.

Various ways of forming reports (conclusion in tabular document, Report Builder, Universal Report, SCD)
Configuring reports in "1C: Enterprise" mode
Report debug tools at SCD. What kind of query actually receives data from the base?
For what you need a lot of ticks in setting up layout fields
How to override the field view in the report
How to get the correct results in reports on an ACD regardless of which fields are displayed in the report?
How to withdraw the correct remnants of documents and registrars?
How without installing only a few ticks, get erroneous results in the report?
How to use your own functions from common modules in the CCD report?
How to exclude incorrect additions USD + EUR; PC. + kg
How to create multiple views (report options) on the basis of the same data
What are the possibilities for the output of data in graphical form (charts, graphics, histograms) in the CCD, and when the resulting diagram "modest" by the program code
How to organize the output of the hierarchy data without programming? And how is it organized to receive such data at a low level?
How without program code, withdraw all dates for the period, and not just those on which data is in the report?
How to set up a report where the user can independently choose the required frequency (year, month, day)?
How without programming, lay on the form of a report "Quick" settings that need a user to form a report?
Combining selections - and, or not.
How to output the header of the field vertically, and the values \u200b\u200bthemselves are horizontally.
Conclusion in the results of only some resources
Differences in the calculation of the results in queries and SCD

The cut of the latter for each date with the help of the CCD
Working with arbitrary features of objects that the user creates in the "1C: Enterprise" mode in the CC report
Using nested schemes - Development of a new report based on existing
Practical examples of using complex function pronounced functions
Calculating / separatedGroupsOtherMassiv,
Calculate-based separation bureaucupsTextries, etc.
To solve what tasks can they be applied?
Features of working with layouts in reports at the CCD
Using manual data output to a tabular document, you can implement complex and comprehensive reports. And how to get the same report, but with all the flexible settings of the CCD (arbitrary seboctions, etc.)?
How to form a report programmatically? How to form a report with the selection of a specific product from the list of nomenclature?
The output of the generated data is not in the report, but in the table of values
Software with user settings
How to build a report on a table that turns out software or is loaded from an external system?
The implementation of the custom selection is not in reports - processing, reference books, etc. Storage of arbitrary selections entered by users in "1C: Enterprise" mode
Software processing decryption
Creating your own menu to decrypt the report
How to implement a transition from a report to a dual click in the report cell?
How to bring pictures to the report? How to form a price list with product images?
How to bring the company's logo in the CCD report?
What is the capabilities of the CCD can be used when displaying lists? Dynamic lists
How does the system provide a quick display of lists in which tens of thousands of elements can be stored?

The layout system 1C 8.3 for beginners: the first report on the CCD

If you did not read the introduction to this module - please read it :.

To fulfill the lessons you will need 1C 8.3 (not below 8.3.4.482) .

If you already have an installed 1C version 8.3 - use it. If not, download and install the training version that 1C manufactures specially for educational purposes.

For this:

Unpack the archive downloaded by reference to a separate folder on the desktop:
- link to download with Dropbox (option number 1)
- link to download with Mail.Ru (option number 2)
Run the "setup.exe" file.
Click "Next", "Next", "Install".
Wait until the installation is completed.

There should be such a shortcut on your desktop:

For all lessons from this cycle, we will use the Database "Deli" prepared by me. It completely coincides with the base we used in and school modules when learning requests. Therefore, I expect that you are familiar with its directories and documents.

If you deleted it - download the next, unpack the Bases list.

Finally, workplace Configured and now we will create our first report using the data layout system. He will be very simple to demonstrate general features data layout systems (abbreviated SCD).

We put the goal

The purpose of this lesson - Create a report that in user mode displays a list of clients with the following fields:

Name
Floor
Favorite client color.

The report must be external. This means that it will be created and configured in the configurator, and then saved as a separate (external) file on the computer.

To form such a report in 1C to the user, you will need to start the database in the user mode, open this file and click the "Shape" button.

Go!

Create a report

Run the configurator for the database "Deli":

From the main menu, select the file "File" -\u003e "New ...":

Select "External Report":

Create a data layout circuit inside the report

A window for creating an external report has been opened. Introducing: " Lesson 1", and then click the button" Open the data layout scheme":

Started the scheme creation constructor. Agree with the default name " Basic ashamcomponovkin"And click the button" Ready":

The main working window has opened, with many bookmarks and fields in which we will configure our data layout scheme.

No need to be afraid - there are really many opportunities here, but not all of them we need. Especially in the first lesson.

Now we are on the bookmark " Data sets". On it and remain.

Write a request through the designer

The data layout system (abbreviated CCD) requires us data, which she will display the user.

The easiest way - write a request To the database. We learned to write and understand the schools - so I expect you to have appropriate skills.

Click on green Plusik and in the discontinued list choose the item " Add Data Set - Request":

Our task is to write a query text in this field. You have not forgotten how it is done?

I will tell you:

In this query, we chose three fields (" Name", "Floor"And" Favorite color") From the table" Directory. Clements".

But do not hurry to write this text in the "Request" field manually.

Now we will create the same inquiry visually, only with the mouse. This method is called " Request Designer".

Click the button to call this designer. Request Designer ..."In the upper right part of the" Request "field:

In the window that opens, the topping table " Customers"From the first column in the second to specify that it is from this table that we will request the data:

It turned out like this:

Next, open the table " Customers"In the second column on the sign" A plus"To see all its fields and drag the field" Name"From the second column in the third to specify that from this table we need to request the" Name "field:

It turned out like this:

Let's do the same with the fields " Floor"And" Favorite color". The result will be like this:

Press the "OK" button to exit the request designer and see that the query text is automatically added to the "Request" field.

Moreover, on the basis of the 1C query text, the names of the fields (area above the query), which will be used by the data layout diagram:

Now that we have compiled a request, the CCD knows how to receive data for the report.

Customize data presentation

It remains somehow visualize this data For a user in the form printed form. And here the LCD can work wonders!

To create such a miracle, let's go to the tab " Settings"And press the settings constructor button ( magic wand):

In the window that opens, specify the report type " List" and click " Further":

In the next window, select (by dragging) the fields to be displayed in the list (drag all of the available to us: " Favorite color", "Name"And" Floor"):

We get this result and press the button " OK":

Designer settings closed and appeared " Detailed entries":

The report is ready, let's check it out. To do this, first save the report in the form of an external file.

Save the report as a file

Open the Main menu item " File"->"Save":

I save it on your desktop under the name " Lesson 1":

Check the report in user mode

Finally, close the configurator and go to our database in user mode:

User name "Administrator", password No:

Through the menu select the item " File"->"Open...":

And specify the report file (I saved it on the desktop under the name "lesson1.erf":

The form of the report, click the button " Shape":

Ready! Here it is our printed form with a list of customers, their favorite color and floors:

Printing can be easily printed. To do this, it is enough to choose from the menu item " File"->"Print ...":

So simply, without programming, we managed to create a full-fledged report that users will be able to open in their bases, form and print.

pupils - I answer by mail, But first look at.

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 having to write program code. Using a specific designer and settings produced in it, the programmer sets the 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 programmer great amount settings. 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 the necessary settings, create a configuration of the report option, complicate the report and display it to the user. 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 scheme programmatically using regular platform tools, and in addition to external means it is possible to operate.

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

CCD 1C is decrypted as a data layout system. CCD 1C is a new way of writing reports in 1C, which allows the user to fully customize the report independently.

Minus CCD 1C is that its settings are quite complex and not all users absorb them quickly.

Writing CC reports requires the ability to work with requests in 1C, which we discussed in.

What is the technology of creating a report of the CCC 1C:

Write a request for 1C in CCD 1C, which provides data
Specify CCD 1C field roles (calculated fields, resources)
Enter the default CCD settings.

The user remains the ability to change many settings at will.

What is the technology of creating a report on previous technologies:

Write a request in the program 1C
Develop the settings form (unique to the report), which will change only the settings selected by the N programmer
Write the code (program) execution of the query and build a print form of the report.

As you can see, CCC 1C has a significant advantage for both the user and the programmer:

Programmer - eliminates the writing program to execute a report and settings
The user - gains significant access to the report settings.

In all new configurations 1C, all reports will be used only at CCC 1C.

Let's see how to create a report on CCC 1C itself from scratch.

Create a report of CCD 1C

In the configurator, click the new file button (File / New menu).

Select File Type New Report.

A new report will be created. We introduce the name - without spaces for the configuration, synonym for the user.

Create the basic SCD 1C.

Create a request for the report of SCD 1C

Data sources for CCC 1C may be set. To use, for example, two separate requests - add the "Data Set - Combination" first, and then several requests.

In our example, we will use a simple request.

Sketch a request for data receipt.

Working with a request designer is no different from the usual, we discussed it in.

As a result of the formation of a request, CCD 1c will create a list of fields available to use and fill it by default names.

If the name is inconvenient, it can be changed here.

Please note that we used in the query parameter & data. In CCD 1C there is a default setting with the name & period and you can use it.

Moreover, you do not need to specify it in the query - it will be used automatically. However, there are subtlety - it applies to all tables, including left connections, etc., which can give birth to errors.

For example, you get residues at the beginning of the month, and the left connection receive data for today. When used, the period will be applied to all tables the same and the request will work incorrectly.

Settings CCC 1C.

On the Resources tab, specify those fields that will be summed for the results (i.e. figures). In the fields you can specify the function of summation. By default, this is the amount (i.e., summarize the numbers from all rows and get the total), and you can use the average, number, maximum, etc.

On the Parameters tab, prohibit unnecessary to us, and turn on the necessary. Here you can ask the human name of the parameter.

The main setting is made on the Settings tab:

Open it in the Enterprise mode. Please note that we did not deal with any programming, drawing forms and other things. To set the parameter, click the Settings button.

The user sees the almost the same form of settings as a programmer.

Voila. The report works.

Settings CCC 1C.

All CCD 1C report settings are made by pressing the settings button. At least in the default template. It is possible to create the form of the CCC report itself 1C and then the settings can be made to other forms drawn by the programmer on their own.

Put the warehouse from the column in the string.

Swimming a nomenclature to the warehouse.

Click OK and form a report. Hurray - we just changed the work of the report in programming mode without programming.

Right-click on the strings (and can be on any of the fields) and select a new group.

We will reveal the warehouse field and select one of its fields, such as the view of the warehouse.

Thinking, we remembered that I would like to have several fields at once in one column. Click on the newly created field twice the left mouse button. Here you can add fields.

If you add a new grouping, but the field will not select, it means "all fields" (displayed as "detailed records"). It looks like this.

Grab the left mouse button on our group (warehouse / nomenclature) and drag it to a new grouping (view of the warehouse).

The result of our settings.

In addition to settings, the action of which is easy to guess by their name (selection, sorting, etc.) is the "Other Settings" tab. It allows you to allow or disable such things as a display of results, the location of the groups in the columns, etc.

Please note that the settings can be specified for the entire report (the report is selected) or for a specific field string (select a string, such as the nomenclature, and select Settings: non-Nonmenclature).