Hyperlinking 2 reports in Webi using prompt text

[abdul_nahas3]

Hi Experts,

I need to pass prompt text as input in open doc statement. For example, If I need to pass fiscal period JUN 2016 from parent report, I have to provide 006.2016. Please let me know how to pass JUN 2016 from the parent report to prompt instead of 006.2016.

Regards,

Abdul

[former_member198519]

Try using it like:

openDocument.jsp?iDocID=342& sType=wid&sRefresh=Y&lsSObjectName=" + [Variable Name]

for [variable] you try to create is as below:

[Month Name] = Month(todate("01/"+userresponse("Enter Month and year");"dd/MM/yyyy"))

[Year] = Year(todate("01/"+userresponse("Enter Month and year");"dd/MM/yyyy"))

[Variable Name]= [Month Name]+"."+[Year]

See if that works 🙂