Open Doc (Hyperlink) from WebI- WebI (4.0) i.e., Mother WebI Report to Child WebI Report

Note: This document gives the step by step process, to open the child report based on the prompts passed from the Mother Report.

Data Source: Southeast Sales Universe

Step 1: Create a Mother Report (Parent Report). Here Region, City and Net Sales are result objects as shown below.

/wp-content/uploads/2013/11/1_322039.jpg

Step 2: Create a Child Report having parameter. Here Region is the parameter from mother to child report

Note: Here R is the Parameter text.

/wp-content/uploads/2013/11/3_322053.jpg

    The below screen gives the Child Report.

/wp-content/uploads/2013/11/2_322052.jpg

Step 3: Copy the URL from child report.

Go to Documents –> Right-click on the Child Report –> Document link

/wp-content/uploads/2013/11/6_322113.jpg

/wp-content/uploads/2013/11/5_322054.jpg

Step 4: Go to Mother report, Right-click on the object Region –> Linking –>Add Hyperlink as shown below.

/wp-content/uploads/2013/11/6_322113.jpg

Step 5: Paste the Child report Document link

/wp-content/uploads/2013/11/7_322065.jpg

Step6: Here Region is the parameter, so add &lsSR along with the document link and Parse

           ( As It is a single parameter so &lsSR=([Region] in the below link)

   Where lsS is single value and R is parameter text of child report prompt and Region is the Dimension

/wp-content/uploads/2013/11/7_322065.jpg

Step 7: Select the object as Region as shown in the below screen.

/wp-content/uploads/2013/11/9_322067.jpg

Step 8: select the Target window.

/wp-content/uploads/2013/11/10_322068.jpg

Step 9: As the Region will be highlighted with the link as shown in below screen.

Now select the Region from Mother Report that will open the child report.

Step 10: Here I have selected the Region EEMEA in the Mother report, The child report as to get the data for the same prompt.

/wp-content/uploads/2013/11/11_322103.jpg

The below screen Shows the Child Report:

/wp-content/uploads/2013/11/14_322112.jpg

Hope this documents helps,

Thanks & Regards,

Shivani.

To report this post you need to login first.

16 Comments

You must be Logged on to comment or reply to a post.

    1. shivani yemula Post author

      Yeah Gaurav, R is the parameter text, By default the parameter text will be like Enter Region: But I have changed it to R for the Convenience.. Please find the screen shot for your reference.

      Please let me know if you need for clarification.

      /wp-content/uploads/2013/11/3_322698.jpg

      (0) 
  1. Priya K

    Thanks for sharing. I have tried the same but its not working. Please help to resolve this issue.

    I have created Level1 report and its showing Store name,State,City,Sales Revenue.

    For above created one chart in the same report and done “Element Link” for State & City.

    Created Level2 Report and set the store name as prompt and just execute the report by giving prompt value “Store name” as “e-Fashion Austin” and save the report and copied the document link.

    After that adding hyperlink for “Store name” column in the Level1 report and done the steps given in the blog. After click the hyperlink my Level2 report showing the details for store name as “e-Fashion Austin” but in my level1 report, clicked the store name as “e-Fashion Austin”.

    I have noticed that level2 report is showing the details according the prompt which i selected while creating a report.

    And its working fine with doucment link option.

    Also plz anybody can explain abt “Use complete URL path to create hyperlink”?? in Document Link. I tired this option by giving document link in the url but i didnt find any difference with this option enabled or disabled 🙁

    (0) 
  2. Lakshminarasimhan N

    Hi, you have used “open document” or “Hyperlink” to connect the parent and child report. Same can be easily achieved via “Document linking”? Is there any reason to choose “Hyperlink” rather than “Document linking”?

    (0) 

Leave a Reply