Displaying UserResponse() values on Separable Rows in WEBI Report

                                  Welcome to Web Intelligence Report World

UserResponse () is the WEBI function which retrieves the value(s) of prompt by comparing the prompt text.

By using UserResponse () function, values are in the format of ‘; ‘as shown in following fig 1.1.

Normally, prompt values are retrieved from UserResponse () function by writing the prompt text in double quotes. As shown in Fig 1.1.

Fig 1.1

But our requirement is that the selected prompt values must be separate on rows, not separated by delimiter.

For solving this query, follow the following steps

Step 1:

Create a variable in WEBI Report named by Test

Variable 1: Test

=UserResponse ("Enter values for Store name :")

Fig 1.2

Here you retrieve all the prompt values in the format of delimiter in one cell.

Step 2:

Create another variable named by Value

Variable 2: Value

=Replace (UserResponse ("Enter values for Store name :");";"; Char (13) +Char (10))

Fig 1.3

You can separate the lines using the carriage return character (Char(13)) and a linefeed character(Char(10))

Fig 1.4

Here circular ares is the values of prompt on separate rows by using UserResponse() function.

Thus, we can display UserResponse () values separately in the row format in WEBI Report.

Function Used:

           UserResponse()

       Char (10)