Adding an external report to the database. Adding an external report to the database Additional report 1s 8.3 managed forms

Data composition system 1C 8.3 for beginners: first report on SKD

If you have not read the introduction to this module, please read it: .

To complete the lessons you will need 1C 8.3 (not lower 8.3.13.1644 ) .

If you already have 1C version 8.3 installed, use it. If not, download and install the educational version, which 1C produces specifically for educational purposes: .

The following shortcut should appear on your desktop:

For all the lessons in this series we will use the Gastronom database I prepared. It completely coincides with the base that we used in the school modules when studying queries. Therefore, I expect you to be familiar with its reference books and documents.

If you deleted it, download it again using the following one, unpack it and add it to the list of databases.

Finally, the workbench is set up and now we will create our first report together using the data composition system. It will be very simple to demonstrate the general capabilities of a data composition system (abbreviated SKD).

Setting a goal

Purpose of this lesson- create a report that, in user mode, displays a list of clients with the following fields:

Name
Floor
Client's favorite 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 generate such a report in 1C, the user will need to launch the database in user mode, open this file and click the “Generate” button.

Go!

Creating a report

We launch the configurator for the Gastronom database:

From the main menu, select "File" -> "New...":

Select "External report":

Creating a data layout diagram inside the report

The window for creating an external report opens. For the name, enter: " Lesson 1", and then press the button " Open data composition diagram":

The schema creation designer has started. We agree with the default name" MainData Layout Schema" and press the button " Ready":

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

There is no need to be scared - there are really a lot of opportunities here, but we don’t need all of them. Especially in the first lesson.

Now we are on the bookmark " Datasets"We'll stay there."

We write a request through the constructor

The data composition system (abbreviated as DCS) requires us to data, which it will display to the user.

The easiest way - write a request to the base. In school we learned to write and understand requests - so I expect you to have the appropriate skills.

Click on green plus sign and in the drop-down list select the item " Add Dataset - Query":

Our task is to write the request text in this field. Have you forgotten how to do this yet?

I'll give you a hint:

In this query we have selected three fields (" Name", "Floor" And " Favorite color") from table " Directory.Clients".

But don’t rush to write this text in the “Request” field manually.

Now we will create the same request visually, only using the mouse. This method is called " Query constructor".

To call this constructor, click the button " Query constructor..." in the upper right part of the "Request" field:

In the window that opens, drag the table " Clients" from the first column to the second to indicate that it is from this table that we will query the data:

It turned out like this:

Next, we will open the table " Clients"in the second column by sign" Plus"to see all its fields and drag the field" Name" from the second column to the third to indicate that from this table we need to query 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:

Click the "OK" button to exit the query builder and see that the query text is automatically added to the "Query" field.

Moreover, based on the text of the request, 1C itself pulled out the names of the fields (the area above the request) that will be used by the data composition scheme:

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

Setting up data presentation

It remains somehow visualize this data for the user in the form of a printed form. And this is where ACS can work wonders!

To create such a miracle, let's go to the tab " Settings" and click the settings designer button ( Magic wand):

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

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

Let's get this result and press the button " OK":

The settings designer closed and the item " Detailed entries":

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

Save the report as a file

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

I'll save it to my desktop under the name " Lesson 1":

Checking the report in user mode

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

Username "Administrator", no password:

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

And specify the report file (I saved it to the desktop under the name “Lesson1.erf”:

The report form has opened, click the button " Form":

Ready! Here is our printable with a list of clients, their favorite color and gender:

The printable form can be easily printed. To do this, just select the item " File"->"Seal...":

Just like that, without programming, we managed to create a full-fledged report that users can open in their databases, generate and print.

students - I answer by mail, but first look at.

Working with software products supplied by 1C involves not only entering and systematizing primary information (filling out directories and timely entering documents), but also creating various printed forms based on this data. For these purposes, a special object has been created - reports. Reports in 1C help to analyze the current situation in the company in terms of various indicators and provide the opportunity to make competent management decisions based on this information.

Reports and processing

Generally speaking, there are no significant differences between these two types of objects:

They may contain layouts of printed forms;
They may have procedures in their modules for making changes to information;
They can be internal or built-in;
External reports and external processing in standard configurations are stored in the same directory.

You can conditionally divide the report and processing according to the principle of use. Layout is necessary to display information in a user-friendly form, processing is created to make changes to the database. Additionally, in the output tables, you can specify the main layout scheme, which will serve to form the appearance of the returned documents, as well as settings for storing parameters.

The objects physically considered in the article differ from external processing by file extension:

External processing – epf;
External report – erf.

External and built-in reports

If you look closely at the tree of any configuration in 1C, you will notice that there is also a reporting branch (Fig. 1)

There are practically no differences between external and internal processors. Moreover, any ert file can be embedded in the configuration and vice versa, the built-in mechanism can be uploaded to an external resource. For example, if we want to make changes to the standard “Analysis of Contributions to Funds” processor, we must call the context menu of the corresponding object and select the submenu “Save as external...” (Fig. 2)

Rice. 2

The reverse action is called by the “Replace with external” submenu, but for this the configuration must be open for change.

The only difference between a built-in object is that it can be accessed from the program code of modules; for an external report this is quite difficult to do unless you add it to the appropriate reference book.

Creating an external report

You can create an external report only in the Configurator mode; for this you will definitely need knowledge of the built-in programming language and, most likely, the ability to work with the language and the query designer.

Basically, the programmer has two options to assemble the data extracted from the database tables:

Use the data composition system (DCS) mechanism;
Programmatically fill out a spreadsheet document using a pre-prepared layout.

In the second case, the developer will have to independently think through the interface, selections, groupings and other things that can be created in the access control system as the user works.

But, regardless of the selected mechanism, you need to start from the “File” menu, the “New” submenu. The developer is presented with a menu for selecting the object to be created (Fig. 3).

Rice. 3

Rice. 4

Here we see:

A name that summarizes the purpose of the object as accurately as possible;
Synonym and comment are intended for complete description;
Basic layout scheme – here you can specify the scheme that will be used to print the report;
The “Open diagram…” button opens the designer of the processing result;
Window for describing forms, details and layouts.

By clicking the “Actions” button you can open the module of the object being created.

Layout diagram

Using ACS to create a report greatly simplifies the developer’s work:

There is no need to think through and create the shape of the object;
Selection, groupings, columns of the displayed form can be dynamically changed in user mode;
It is possible to create and store several options for generating the final table.

This is why data layout schemes are becoming increasingly popular in modern solutions. If you click the appropriate button, the ACS designer opens in front of the developer. (Fig. 5)

Rice.
5

The schema is stored in object layouts.

In addition to internal and built-in reports, there is another possibility for storing and accessing these objects - the “Additional Processing” directory.

Registering external objects in the database

For managed forms, on which modern 1C software products are based, the form for registering external processing in the database has changed significantly.

If previously (on regular forms) it was enough to create a new element in the corresponding directory, specify the type of stored handler and determine the path to the ert format file, then on managed forms registration occurs from the module of the registered object.

To do this, the External Processing Information export function must be defined in the handler module. (Fig. 6)

Rice. 6

Figure 6 shows an approximate set of commands that will allow you to register a file in the directory.

In addition to the function with information, here are presented: another procedure (Add Command) and a function (Get Command Table). Their contents are shown in Fig. 7

Rice. 7

In our example, the report shows the output of products and services by divisions, product groups and by month.

Here is the main page of the report:

This page is called from the configurator in the menu File – New – External report.

First we add a dataset (DataSet1). In the “Query” window, you can type it yourself, create it using the Query Builder, or load it from a file. The most convenient way is to use the query constructor. Read how the constructor works.

Everything you need is filled in automatically, but some things need to be tweaked.

For example, column headings (the “Quantity” checkbox in the figure above allows you to enter any heading text for this field), you can set the data output format (see Format in the Quantity line). The format can be edited for any type of data – strings, dates, numbers.

On the Resources tab, select the resources themselves and configure the display of results for them:

The Parameters tab contains everything that changes the content of the report (for example, the period for which data will be selected). Filled in automatically based on the request parameters (see first page). Using checkboxes you can adjust the visibility and availability of these parameters, set the initial value, etc.:

Get 267 video lessons on 1C for free:

And finally, Settings. Here the appearance of the report is drawn - columns, rows, their position relative to each other, groupings, etc. The “Open Settings Designer” button will help you arrange the lines and columns in the desired order. The “Custom Element Settings” button will allow you to display the parameters in the report header:

Pay attention to the column Period.PartsDate.NameMonth. How to display the name of the month in the column header? This is where it comes out.

By the way, it is this setting that allows you to display data for several periods at once in adjacent report columns:

Another important tab is Selected Fields. If it is empty, the report will not be generated. Usually filled in automatically by clicking the “Open Settings Designer” button:

Actually, that’s all you need from the minimum required. As a result, we will have a report that looks like this:

They say that the name 1C originally meant the phrase “one second”, i.e. programs must produce reports quickly, “in one second.” The speed of the reports is very important, but it is even more important that the reports provide the correct information - we will understand this using the example of creating a simple report in 1C 8.3 based on the Trade Management 10.3 configuration. To create correct reports, it is desirable (even strongly recommended) to be able to configure 1C and to be able to program a little in the internal language and query language of 1C, although, on the other hand, creating reports is an excellent opportunity to start mastering these skills.

This description is educational for understanding the basic principles of creating 1C reports

How to create a report in 1C 8.3

To create a report, you need to open 1C in configurator mode; to do this, in the 1C launch window, select the desired database in the list and click the Configurator button:

In the configurator itself, go to the File menu and select New:

In the menu that appears, select External report and click OK:

After this, a new report window will open. In the Name field, enter the name of the report; it must be without spaces or special characters:

How to make a report using a layout

This method most requires programming skills in 1C, but here we will not analyze the mechanisms for receiving and processing data, we will make a simple report to understand the mechanism for launching the report and displaying the report form on the screen:

In the report window (which opens when creating a report), in the lower list, place the cursor on the Layouts item and, when you right-click, click Add in the menu that appears:

In the layout designer that opens, you can specify the name of the layout, Spreadsheet Document should be selected as the layout type, and then click the Finish button in the designer:

This will open a layout window resembling an Excel sheet:

In this layout, you need to create areas - groups of rows or columns that the program will use as templates, insert data received from the database into them and display these templates on the screen, thereby putting together a report from these parts.

Let's create a report that displays a list of items. To do this, we will create two layout areas: the report header and the item line.

To create a header area, left-click on the line header (where the line number is indicated) to select the line like this (the entire line should be selected with one click on the header):

After that, go to the Table menu of the main menu, go to the Names submenu and click on the Assign name item:

The program will prompt you to specify the Area Name, the name should also not contain spaces or special characters, after that click OK, it should look like this:

Now in the created area you need to enter the text that will be displayed in the report and format it. To do this, enter text in the first cell, for example, “List of items.” Working with cells is similar to Excel.

To format text in a cell, right-click on the cell and click on Properties. The cell properties window will open on the right. Scrolling down the contents of the window, find the Font field and click on the “...” button:

In the window that opens, in the Style section, check the Bold box and click OK:

The layout should look like this:

In the same way, we create the item line area, but do not highlight it in bold:

In the line area you need to indicate that Name is a parameter, i.e. that the real name of the item will be substituted there when outputting the report. To do this, open the properties of the cell with the name and in the properties in the Filling field, select the value Option, this completes the layout setup:

We return to the main report window and in the lower list, right-click on the Forms item and click Add:

In the report form designer that opens, click the Finish button, the report form will open, double-click on the Generate button:

As a result, the button properties window will open on the right side of the screen; in the Action field, click on the magnifying glass:

After this, a form module will open in which you need to program the generation of a report:

First, replace the selected text with the following program code:

//create a spreadsheet document that will be filled with parts of the report and displayed on the screen

TabDocument = New TabularDocument;

//next, we get the layout that was created when creating the report

Layout = GetLayout("Layout");

//now we need to display the report header, for this we get the header area from the layout and display it in a spreadsheet document

AreaHeader = Layout.GetArea("Header");

TabDocument.Output(AreaHeader);

//using a query we get a selection of item names that need to be displayed in the report

Request = New Request;

Request.Text = "

|SELECT

| Name

|FROM

| Directory.Nomenclature

|";

//get the item line area from the layout - we will access it in a loop to display each item

AreaString = Layout.GetArea("String");

//process each name from the resulting selection in a loop

Select = Query.Run().Select();

While Select.Next() Loop

//to display the next line, you need to specify the next name in the area parameter (we configured the parameter itself when creating the layout)

AreaString.Parameters.Name = Selection.Name;

//the parameter has been filled in, now you can display the string

TabDocument.Output(AreaString);

EndCycle;

//the spreadsheet document has been generated, now we display it on the screen

TabDocument.Show("List of items");

When the text is copied into the form module, lines starting with a double slash “//” will be highlighted in green - these are comments that describe what each line of code does:

Let's summarize what lines of program code are needed to generate a report:

It is necessary to create a spreadsheet document that will be filled with parts of the report and displayed on the screen; this is done with the line “TabDocument = New TabularDocument;”
We need to get the report layout, from it we will get the report structure in parts (areas), this is done with the line “Layout = GetLayout(“Layout”)”
To display each of the areas, you need to get it from the layout and output it to a spreadsheet document, this is done with the lines "Header Area = Layout.GetArea("Header")" and "TabDocument.Output(HeaderArea)"
If you need to fill in parameters that become known only when the program is executed, then before displaying the area you need to fill in such parameters, this is done with the line “AreaString.Parameters.Name = Selection.Name”
And only when the spreadsheet document is filled with all the necessary parts of the report, it is displayed on the screen, this is done with the line “TabDocument.Show(“List of items”)”

And now you can check the operation of the report - open 1C in enterprise mode (button 1C: Enterprise in the 1C launch window). In the main menu, go to the file menu, click Open:

Find and open the saved report file. In the form that opens, click the Generate button:

and we get a list of nomenclature:

This is just one way to create reports in 1C. In the following articles we will look at others.

In the top menu go to Service->->.

After this, the directory list form will appear. In the top menu click Add.

The window for adding a new report appears. Press the button Open.

Select the file with the desired report and click Open. After adding the file, if necessary, change the name of the report (how it will be displayed in the list). Click OK.

As a result, the new report appears in the list.

After this, the report can be used, adding is completed. To open this report later, we also go to Service->Additional reports and processing->Additional external reports.

For BP 3.0, ZUP 3.0, UT 11, ERP 2.0.

To add an external report in 1C:Enterprise 8.3 configurations in a managed interface (using Accounting 3.0 as an example), let’s enter the corresponding section of the program:

It is necessary that the option to use additional reports is enabled, follow the hyperlink:

In the list that opens, click the button Create:

After this, a file selection dialog box with a report will immediately open, in which you need to select the desired file (in my case, it is a file with a plan-actual cost analysis).

Now you need to configure accommodation(the place in the program where the report will be available):