How to Display Report Parameter in XML
Introduction
This knowledge base article will assist you with how to create a Report Parameter in XML and then how to reflect it in a Parameter Window.
Overview
The report parameter may contain multiple values in the parameter dropdown. A dropdown parameter can be used when there is a condition on an object and data needs to be retrieved based on a set condition.
Using a Dropdown Parameter in XML
Follow these steps mentioned below, which are based on filter criteria when a user wants to display multiple columns in a report:
1. Set filter criteria in a report using iVend Report Designer.
2. Now add the following code snippet in the XML file of the Parameter report.
<Parameter name="ValueCalculation" objecttype="36" caption="Values At" multiselect="false" ValidValues ="ValueCalculation"/>
<ValueCalculation>
<CostPrice>CostPrice</CostPrice>
<RetailPrice>RetailPrice</RetailPrice>
</ValueCalculation>
3. Save the Parameter XML file.
4. Import the XML and .IRT file in the iVend Report Manager.
Refer to the screen image below that illustrates the dropdown parameter.
Figure 1 Stock Cover
Parameter List
The following table documents a list of Parameters, which contains the Parameter Name and Object Type (objecttype):
Parameter List |
Parameter Name | Object Type |
Free Text | 0 |
Date Only | 1 |
Time Only | 2 |
Date Time | 3 |
Decimal | 4 |
Integer | 5 |
Boolean | 6 |
Store | 7 |
POS | 8 |
Product Group | 9 |
Product | 10 |
Customer Group | 11 |
Customer | 12 |
Till | 13 |
User | 14 |
Payment Type | 15 |
Warehouse | 16 |
Gift Certificate | 17 |
Event | 18 |
Vendor | 19 |
Manufacturer | 20 |
Product Category | 21 |
Tax | 22 |
Coupon | 23 |
Department | 24 |
Reason Codes | 25 |
Fulfillment Plan | 26 |
Loyalty Customer | 27 |
Loyalty Top Bottom | 28 |
Minimum Slab Value Calculated on | 29 |
Date Range | 30 |
Member Transaction Calculation on | 31 |
Boolean Type | 32 |
Price List | 33 |
Promotion Bonus Buys | 34 |
Subsidiary | 35 |
Drop Down List | 36 |
Location | 37 |
Employee Position | 38 |
Security Role | 39 |
Loyalty Program | 40 |
Product Class | 41 |
Till Master | 42 |
Related Articles
Customizing the Report Parameter for Scheduling
Customising the Report Parameter for Scheduling This knowledge base article will assist you with how to customize report parameters in XML and reflect them in the Parameter Window. Going through this article, you will be provided with an overview, ...
X-Tape Report
iVend Retail – X-Tape Report In iVend Retail the X-Tape report enables the POS user to see a summary of the POS Till in use. The X-Tape report is available from the Point of Sale “User Menu”. This is accessed by clicking on the iVend Retail Logo ...
Suspended Transaction XML Receipt Format
Suspended Transaction XML Receipt Format Environment- iVend 6.6 Problem statement – There is no by default base XML Receipt Format for Suspended Transaction. Resolution/Work Around: As per ivend current System design there is no such by default ...
Number of Records to Display on Default Search Parameter on Retail Profile
Product version: 6.5 Update 6 Problem statement - At the time of Search product when clicking the search button in the product search window its showing only top 1000 records especially during exporting a complete list of products. Proposed solution: ...
customer display screen not able to launch in Taskbar.
Environment iVend 6.6 Problem Description Generally ,after enabling customer display parameter on POS configuration screen ,it will auto lunch customer display screen in taskbar while opening POS Solution Need to check the connection string in ...