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