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.