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 ...