Hi

Can some please review and let me know what am I doing wrong in this piece of code.... cannot seem to get around this.

="javascript:void(window.open('"+Globals!ReportServerUrl +"/Pages/ReportViewer.aspx?"+Globals!ReportFolder+"/"+Parameters!SubreportName.Value+ "?Param1="&Parameters!Param1.Value.ToString()+ "&Param2="&Parameters!Param2.Value+ "','_blank'))

Basically, I'm trying to open a subreport using ActionURL but stuck this js.

It opens up the root folder rather instead of report... 

I also refereed this post: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6462b0f6-d784-4c7a-afe0-2813bec5770a/url-action-with-javascript-and-ssas-parameter?forum=sqlreportingservices

Version - SQL Server 2008R2

• Edited by StSingh 11 hours 57 minutes ago

Hi StSingh,

Check this thread

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/368043b4-e9cb-4c93-b44c-2843bc5e8689/how-to-add-a-subreport-in-a-new-window?forum=sqlreportingservices

Thanks for the quick response but its not helpful.

Hi StSingh,

According to your description, you want to create a URL action to open a subreport via JavaScript, right?

In your scenario, it seems that both main report and subreport contain report parameters. If parameters in those two reports are multivalued, you can pass the parameter values from the main report to subreport with this section in JavaScript code:
&<subreport parameterer>=" &join(Parameters!<main report parameter>.Value,"& <main report parameter>=")
You can refer to this similar thread: Passing Multivalue Parameter in URL in SSRS 2008 not working.

If both parameters are not multivalued, you can refer to this thread: SSRS: How to open linked report with parameter in a new tab.

If you have any question, please feel free to ask.

Best regards,
Qiu

Is datasource based on sql table or a cube?

Views.