Skip to Content

Hyperlinking 2 reports in Webi using prompt text

Jan 23, 2017 at 05:32 AM


avatar image

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.



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

1 Answer

Kuldeep Ghosh Jan 24, 2017 at 12:25 PM

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 :)

10 |10000 characters needed characters left characters exceeded