iVend POS - Report with Sub-Report

iVend POS - Report with Sub-Report

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

 


    • Related Articles

    • iVend POS Receipt Using predefined enumerators on data and additional options

      Introduction This article explains how to use predefined enumerators and additional options in the iVend POS Receipt. Any user with basic XML and programming knowledge can customize the iVend POS Receipt. Log into the iVend Management Console and ...
    • How to use Sub – Report in iVend Reports

      How to use Sub – Report in iVend Reports If using sub report, then Sub report “DataSource” should be place upper side of main report DataSource. “XTapeReport“ Data-Source which used in sub-report. “TillDetail” this Data-Source is use in Main report ...
    • iVend POS - Standard Report

      iVend Retail POS – Creating a Standard Report using the Wizard This article provides the basic steps for creating a Standard Report through the use of the Report Wizard. When creating a report using the Standard Report Wizard, the report will contain ...
    • iVend POS - Label Report

      iVend POS - Label Report This article provides the basic steps for creating a Label Report in iVend Retail. In iVend, the user can design their own label(s) using the following two options: · Thermal Label Setup · Report Designer Label Report Thermal ...
    • iVend POS - Graphical Report

      iVend Retail POS - Graphical Report This article explains the basic steps for creating a Graphical Report. 1.On the Report designer click on components and then charts. Figure 1 Report Designer Put the Chart component on a page as seen in the picture ...