Skip to Content
0

Passing Prompt through opendocument

Apr 21, 2017 at 02:36 AM

27

avatar image

Hi experts,

In webi report Iam creating an formula variable below for capturing input control values

say in the input control radio iam selected as Aeroplane which passes Air Fare in USD as prompt values to the detail report from summary report

Test = if ReportFilter([Type]) = "Aeroplane" then "Air Fare in USD"

Detail report has optional query prompt Type which has one list of values as Air Fare in USD.

From the summary in the open document iam passing document link as lsSType="+URLEncode(""+[Test])

I have issue since the selected input control has value having Spaces in between ie. Air Fare in USD. iam not getting data in detail report.

whereas if i pass inputcontrol reportfilter as below iam getting data in detail report ie without spaces.

Test = if ReportFilter([Type]) = "Aeroplane" then "Air"

Appreciate your help here.

Thanks,

Dinya.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers