Основная информация о заказе беретс

Основная информация о заказе берется из таблицы Orders. Рядом с добавленными полями мы располагаем объект Subreport. В свойствах Subreport1 обязательно нужно выставить свойство PrintOnParent в true.Когда мы добавили на страницу отчета объект Subreport автоматически добавилась новая страница отчета. На этой странице мы создаем шаблон подотчета, который будет выводить список продуктов. Так как таблица Orders имеет связь с Order Details, то подотчет будет выводить записи, соответствующие текущему заказу. Таблица Order Details также имеет связь с таблицей Products. И мы воспользуемся данными из этой связи:

Результаты (английский) 1:

Summary of the order comes from the Orders table. Next to the fields we have added Subreport object. In Subreport1 properties definitely need to put PrintOnParent property to true.
When we added a page Subreport report object automatically add the new page of the report. On this page we are creating the subreport template that will display a list of products. Since the Orders table has a relationship with the Order Details, then accountability will display the records that match the current order. Order Details table also has a relationship with the Products table. And we use the data from this connection:

Результаты (английский) 2:

Basic information about the order is taken from the Orders table. Next to the added fields, we have a Subreport facility. In Subreport1 properties, you should definitely put the PrintOnParent property in true.
When we added a new report page to the report page, the subreport automatically added. On this page, we create a subreport template that will display a list of products. Because the Orders table is in touch with Order Details, the report will display records that correspond to the current order. The Order Details table also has a connection to the Products table. And we'll use the data from this connection:

Результаты (английский) 3:

The main information of the order comes from the orders table. In the added area, we have a sub report of the object. The subreport1 property must show that the print property is real.
When we add a sub report object to a report page, a new report page is automatically added. On this page, we create a report template that will display a list of products. Because the orders table is associated with order details, the report displays entries that match the current order. The order details table is also related to the product table. We will use this data: