iVend POS - Report with Parameters
Report with Parameters
This article provides the basic steps for creating a Report with Parameters.
- Create a report or open an already created one. Click on Dictionary.
Figure 1 Report Designer
- Click on Data Sources and select New Data Source
Figure 2 Dictionary- New Data Source
- Click on New Data source> iVend Connection
Figure 3 New Data Source
- Click on New Query on the Select DATA Screen.
Figure 4 Select Data
- On the New Data source enter the parameter name and insert query “Select Id, Description from InvProduct where Id=@Product. Click on the icon New Parameter
Figure 5 New Data Source- New Parameter
- The Id name should be equivalent to the Name on the right pane. The Size defined should be equivalent to size of the Id column in database. Also the data Type should be same as of the Id . The value in Expression are the once defined in variable.
Figure 6 Data source expression
- Click on the Retrieve Column button.
Figure 7 SQL Expression -Product
- Enter the Product name and click Ok. The dataset for the products appears.
Figure 8 Data Source ID and Description
- New Data appears on the Select Data Screen.
Figure 9 New Data Source
- New added Product data gest displayed with the parameter values.
Figure 10 Dictionary Parameters
- Click on Variable to create a new variable
Figure 11 New Variable
- Name of the variable should be same as Name of Parameter and type in Parameter should be same as type in Variable. Enter the Product Value and click ok.
Figure 12 Edit Variable
- The Product gets added to the Variable
Figure 13 Dictionay -product
Related Articles
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 - Simple List Report
Simple List Report This article provides the basic steps for creating Simple List report. 1. Put a DataBand on a page of a report template. Figure 1 : DataBand Figure 2 : DataBand in Report1. Edit the DataBand: · Align the DataBand by height · Change ...iVend POS - Report with Groups
Report with Groups This article explains the steps required for creating a Report with Groups. 1. Create a report or open an existing one. For example, we can take a simple list report that was created in the separate article called, "Simple List ...