Reports

 


The next step in the development of the applied solution will be creation of convenient reports on activities. Reports as well will be created without any programming, using only visual design tools.

Reports are located in the Reports branch of the Configuration object tree. Let us add a new report.

Figure 7-1. Creating a new report

Name the new report Expenses and then click Open data composition schema of this report.

Figure 7-2. Opening the data composition schema of the Expenses report

Since this is a new report, it does not contain any data composition schema, the platform will open Template Wizard and suggest you to create a new template. That template will contain a data composition schema. Agree by clicking Finish.

Figure 7-3. Template Wizard

After that, the platform will open the Data composition schema editor. For now, this composition schema is empty.

Figure 7-4. The empty data composition schema

Now you will define sources of data that the report will use to retrieve data, and define the structure of the report.

Add a Data set of type Query. In other words, the data for this report will be retrieved from the database, managed by 1C:Enterprise.

Figure 7-5. Creating a new query

You can enter a query manually or use Query builder. Let us use second way, for that click Query Builder…

Figure 7-6. Opening Query builder

In the Query builder window on the left there is a list of tables that can be used for retrieving data. Expand the AccumulationRegisters branch and double-click to select FinancialTransactions.BalanceAndTurnovers table.

Figure 7-7. Selecting the FinancialTransactions.BalanceAndTurnovers table

In the Tables panel that is in the middle, select the FinancialTransactionsBalanceAndTurnovers table and click Add all fields . All fields of this table will be selected as query fields.

Figure 7-8. Selecting data for query

The query is configured, click OK.

The wizard will generate the query text and automatically populate fields of the data composition schema.

Figure 7-9. Data composition schema fields

Click the Resources tab. Here, using double-clicks select following fields:

  • AmountClosingBalance
  • AmountOpeningBalance
  • AmountTurnover
  • AmountReceipt
  • AmountExpense

Figure 7-10. Data composition schema resources

Click the Settings tab. Here, in order to create the structure of the report, you will use another wizard. To do this, click Open settings wizard .

Figure 7-11. Opening Data Composition Settings Wizard

Data Composition Settings Wizard allows you to quickly create several simple variants of the report. For this tutorial purposes, List is a good choice. Therefore, do not change anything, and just click Next.

Figure 7-12. Creating a report in the form of list

On the next step, select fields that will be displayed in the report. Double-click the following fields in Available fields list:

  • Person
  • Event
  • AmountTurnover
  • AmountReceipt
  • AmountExpense

Then click Next.

Figure 7-13. Selecting report fields

Now we need to select fields that will group the data in the report. Users would like to see reports on each acquaintance, and on each event associated with the acquaintance. To achieve this, the list of available fields double-click on both Person and Event fields to select them as grouping fields.

After that, click OK. You are now done with defining the structure of the report.

Figure 7-14. Selecting group fields of the report

The platform will now show the structure of the report.

Figure 7-15. Completed structure of the report

It is almost done. Now, give a user an ability to arbitrarily set the report period. This will be useful when the register will contain large amount of records accumulated after a long period of using this application. This is easy to do as under the structure of the report, there are two parameters available, named Begin of period and End of period.

Figure 7-16. Report parameters

Right-click each of parameters and then select Custom settings item property.

Figure 7-17. Opening Custom settings item property

In the opened window, select the Include in custom settings check box and click OK.

Figure 7-18. Include in custom settings

After repeating this procedure for both Begin of period and End of period parameters, continue configuring the report. To do this, close the data composition schema editor and return to Expenses report editor. Click the Subsystems tab and include this report in the Finances subsystem.

Figure 7-19 Including Expenses report in the Finances subsystem

Start the application in 1C:Enterprise mode and take a look at the report. Notice that this report is located in the Finances section. Also, notice that the platform automatically placed the report in the Reports menu group.

Figure 7-20. Opening Expenses report

After the report is opened, click Create.

Figure 7-21. The Expenses report

Having confirmed that the report works properly and displays records of the Cash receipt and the Cash expense documents according to dimensions that were defined for the register, return to Designer mode.

Create one more simple report that can show the current balance of available funds. Name it CashBalance and include it in the Finances subsystem. Similarly, to the Expenses report, click Open data composition schema for the Cash balance report on the Main tab and create the data composition schema. Add the data set of the Query type on the Data sets tab.

Figure 7-22. Adding the query for the Cash balance report

In the opened window, use Query builder as previously. However, for the new report, select the FinancialTransactions.Balance table.

Figure 7-23. Selecting tables for the Cash balance report

Next, expand FinancialTransactionsBalance in the middle panel, click the AmountBalance field, and then double-click or click Add selected to select it.

Figure 7-24. Selecting the AmountBalance field

Click OK to close Query builder. After this, again you will see the Data Sets tab of the data composition schema editor. No changes need to be made here. Click the Resources tab, then double-click the AmountBalance resource.

Figure 7-25. Selecting the AmountBalance resource

Open the Settings tab. Here, use the Data Composition Settings Wizard  once again, confirming the default type, List.

Figure 7-26. Data Composition Settings Wizard

On the next page, double-click the Period standard field in the DataParameters group. This field will allow seeing the date, which the report is created for. Then add the AmountBalance field.

Figure 7-27. Selecting report fields

After selecting fields, click OK because there is nothing else that this report is required to display. The next thing to do is to include the Period parameter to Custom settings as you did when configuring the Expenses report.

Figure 7-28. Including Period to Custom settings

Set the default value of the Period parameter to Beginning of this day so that the report will automatically display the information for the current day.

Figure 7-30. Selecting Beginning of this day as the default value of the Period parameter

After that changes, the report settings will look as follows:

Figure 7-30. Settings of the Cash balance report

Now start the application in 1C:Enterprise mode and check the report.

Figure 7-31. Opening the Cash balance report in 1C:Enterprise mode

Information presented in the report is extremely simple but useful. Now the user can always check how much money is available now.

Figure 7-32. The data of the Cash balance report

Excellent! Now, create another report. After this report will be finished the CRM application will be complete.

Return to Designer mode, create a new report, and name it DailyChart, then include it in the Finances subsystem, and finally click Open data composition schema. Add the Data set of the Query type, and then open Query builder.

In the left panel select the FinancialTransactions.BalanceAndTurnovers table. Up to this point, the process has no difference from what you did during configuring the Expenses report.

Seeing that the report is named Daily chart you might have guessed that a new report will display not numeric data but a chart. And now the trick. To present the data from the register in the suitable for this report format, select FinancialTransactionsBalanceAndTurnovers table in the middle panel of Query builder and click Virtual table parameters .

Figure 7-33. Opening Virtual table parameters

In the opened window, in the the Periodicity field, select Day and then click OK to save and close the window.

Figure 7-34. Adjusting Virtual table parameters

Then, in the middle panel, select the Period and the AmountClosingBalance fields from the FinancialTransactionsBalanceAndTurnovers table.

Figure 7-35. The Period and the AmountClosingBalance fields

Click OK to close Query builder. Then, click the Resources tab and select the AmountClosingBalance field as a resource.

Figure 7-36. The Resources tab of the Daily chart report

Click the Settings tab and open Data Composition Settings Wizard. This time, click Chart. Data is displayed as a chart, and then click Next.

Figure 7-37. The Chart report type

After adding Period and AmountClosingBalance to selected fields, click Next.

Figure 7-38. Adding chart fields

On the next page, add the Period field to the list in the Points panel on the right side. Click Next.

Figure 7-39. Configuring Points of the chart

On the next page, add Period to order fields on the right panel. Click Next.

Figure 7-40. Data order fields of the chart

On the next page, in the Chart type field select Line. At this point, the design of chart complete, and you can click OK.

Figure 7-41. Chart types

In the same way as you did for previous reports, include the Begin of period and the End of period parameters in Custom settings using Custom settings item property.

Figure 7-42. Adding properties to custom settings

Now you can see what you have created. Start the application in 1C:Enterprise mode, open the Daily chart report, and then click Create.

Figure 7-43. The Daily chart report

From this chart users can clearly see the changes in balance of money, made by Cash receipts and Cash expenses.


Comments
0
Add comment