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
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 ...iVend POS Drill-Down Report
iVend Retail POS - Drill-Down Report This article explains the basic steps for creating a drill-down report. A Drill-Down report is an interactive report in which blocks can collapse and expand their contents by clicking on the block title. Follow ...