Report with Sub-Report

The following are the steps to create a Report displaying the Sub-Report data:

On the report Designer right clock on the iVend Connection under the Data source. Then click on New Data Source

Figure 1 Report Designer

Click on iVend Connection on the Data Source screen

Figure 2 Data Source Screen

Click on New Query on the Data Select Screen.

Figure 3  Report Designer-New Query

In Query screen enter the query for the item for which report is required. Like in this case item name is Customer.

Figure 4 SQL Query

The customer table gets created and is displayed on the Select Data Screen. Select the check-box for newly created table

Figure 5 Report Designer

The Table gets added to the Data Source in the Dictionary

Figure 6 iVend Connection

Now create new Data Source with query. Click Ok to reflect the new Data Source which will be Sub data in report.

Figure 7 New Data Source Query

Select the new created table and click Ok.

Figure 8 Select Data

The new Data Source which is our Sub report data, gets added and listed in the Dictionary

Figure 9 Dictionary -iVend Connection

On the Dictionary, select the Data Source which needs to be a sub data in report should be moved  up above the main data in report. Like in this case since ds_CusA is sub-data of ds_Cus, the ds_CusA is moved above the ds_cus datasource.

Figure 10 Dictionary –move up ds_CusA

Note: This is an important step for the sub data to be displayed in the reports.

Now create report layout for main report. Like in this case report layout for ds_cus.

Figure 11 Sub Report

Figure 12 Sub Report Layout

Create SubReport Layout for Sub-Report. Like in this case for ds_CusA

Figure 13 Report Layout

Figure 14 Header CusA

Double click on Data band, select filter option to make a relationship between main report and sub report.

Figure 15 Select Filters

Preview the report by clicking on the preview button. The report displays the Report data and also the Sub-Report Data.

​

Figure 16 Customer Address Info