Post reply

parent-child report

  • October 3, 2012 at 2:35 pm

    #282614

    I have simple report which display the list report_folder and report_name

    for example

    Parent Report

    Report_folder Report_Name

    ABC REPORT_A

    XYZ REPORT_X

    Now when user will click on Report_A , a action will happen to open the that child report in new window

    I went to Action -- GOTO URL ---

    ="void(window.open('" + Globals!ReportServerUrl + "%2f" +Fields!Report_folder.Value & "\" & Fields!Report_Name.Value + "'rs:Command=render))"

    however this action opens the link in new window but giving error like path is not correct.

  • October 4, 2012 at 8:29 am

    #1545579

    Your function is missing the question mark between the reportserver URL and report path and you are missing the ampersand between the report name and rs:Command.

    Put your formula into a textbox so you can see what you are getting before using it in the action. I'd also recommend looking into using URLEncode to ensure you create valid links. Here's a blog post to get you started:

    http://capstonebi.blogspot.co.uk/2010/04/url-encoding-in-reporting-services.html

    I.e.

    ="javascr1pt:void(window.open('" & Globals!ReportServerUrl & "?%2f" & Fields!Report_folder.Value & "%2f" & Fields!Report_Name.Value + "&rs:Command=render'))"

    n.b. replace the 1 with i.

  • October 4, 2012 at 12:23 pm

    #1545725

    sweet it worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply