Skip to Content

Hyperlinking 2 reports in Webi using prompt text

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Add comment
    10|10000 characters needed characters exceeded