Hi,
I am trying to pass more then one parameter from URL , Below is my URL
="javascript:void(window.showModalDialog('http://in-mh-co-dt0030/ReportServer_SQLSERVER2012TAB/Pages/ReportViewer.aspx?%2fTest%2fProduct_WiseV1.0&rs:Command=Render&Lob="+Fields!Line_of_Business.Value+"&Year="+Sum(Fields!Year_list.Value, "Year_Param_DS")+"', ''))"
Lob parameter is in the same dataset , But Year parameter is from different Dataset(Year_Param_DS).
But If I am passing second parameter (Year) like Sum(Fields!Year_list.Value, "Year_Param_DS") i am not able to open the popup.
If i am removing the sum word Main report is giving an error that "Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope."
Please suggest me the syntax (I am working using MDX query) to pass two parameter through url, one from same dataset and 2nd is from another dataset.
Or it is not possible to pass the value field from other Dataset in URL (Go to URL option).
Thanks in advance.