In 1C:Enterprise mode

Let us check the report.

  1. Run 1C:Enterprise in the debug mode.
  2. In the Services section, on the Report menu, click Generic report.
  3. Click Create.

    You can see that the resulting report is empty because row groupings, column groupings, and the list of selected fields are empty. Let us specify these quick user settings.
  4. In the Selection field, click the Select  button and select Revenue Turnover.
  5. In the Rows field, click the Select button and add a grouping by the Material or service field with the Hierarchy type.
  6. In the Columns field, click the Select button and add a grouping by the Technician field.
  7. Click Create.

    The report should look as shown in fig. 13.112.


    Fig. 13.112. Resulting report

    Note that scrolling the report horizontally or vertically does not move the report header and its leftmost column. The platform automatically freezes the top and left report areas for usability purposes. Alternatively, you can specify the rows and columns to freeze using the FixLeft and FixTop output parameters. 
  8. Add Cost Turnover to the list of selected fields.
  9. Change the row grouping from Material or service to Customer and create the report.

    The report should look as shown in fig. 13.113.


    Fig. 13.113. Resulting report 
  10. Exclude Cost Turnover from the list of selected fields.
  11. Change the row grouping to Material or service with the Hierarchy only type.
  12. Add a column grouping by the Customer field, move it to the beginning of the grouping list, and click Create.

    The report should look as shown in fig. 13.114.


    Fig. 13.114. Resulting report

So you have created a report that offers users the option to create a variety of custom reports based on the Sales register.

Next page: Theory. Virtual query tables

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.