How to Display Report Parameter in XML

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