Hi All, I have main matrix report and I want to navigate my sub report from main report by Jump To URL:(Using below JavaScript function) method. ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&RP_cll_typ_l1="+Join(Parameters!RP_cll_typ_l1.Value,",")+"'))" It is ok for the Single valued but giving exception for the multivalued Like An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the data set DS_GRID_DATA. (rsErrorReadingNextDataRow)Conversion failed when converting the nvarchar value '1,2,3,4' to data type int. Basically I have defined Parameters!RP_cll_typ_l1 as multivalued into my subreport as per ssrs multivalued parameter passing method. The value is going on sub report as '1,2,3,4' (not understandable by data set) It should be like as '1’,’2’,’3’,’4' or 1,2,3,4 How can I resolve this please help if any have solution? Thanks Kali Charan Tripathi(India)tripathi_soft@yahoo.co.inkalicharan.tripathi@in.schneider-electric.com Tripathi_soft

You need to generate the URL as follows ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&RP_cll_typ_l1=" "+Join(Parameters!RP_cll_typ_l1.Value,"&RP_cll_typ_l1=")+"'))"In other words, for every value of the parameter you need to add RP_cll_typ_l1=value to the URL.RegardsTuan MCITP: Business Intelligence

Hi Tuan, I am very thankful for this help its worked for me.Now another thing is that I have various drop down list on main SSRS report (containing approx 26000 characters as list values) for filtrations.Can I pass all these values on URL as multivalued parameters on my sub report because as per limit in IE we can pass only 2083 characters on URL? One more thing I am not displaying my sub report in browser instead of this I am directly rendering it into various format like xls, csv, pdf from main matrix report as per requirement. If you have any solution it will be certainly help full for me.Thank You Very muchTripathi_soft

You should probably see if you can use keys instead of 26000 characters to pass on as you will have a max length of the request in the web config.MCITP: Business Intelligence

Thanks for your reply,Actually i am passing keys now but it is not opening for approx 1000 characters.I is taking approx 600 characters but when i adding any another multivalued parameters (with 400 characters ) in script it is just processing but not opening new window.Can i do something with the rsreportserver.config or any web config files because it seems not working for feasible no of characters or with javascript function itself.Please help me if you have any solution.Thanks.Tripathi_soft

Yes, locate the file web.config in your report server fodler, edit it and replace <httpRuntime executionTimeout="9000"/> by <httpRuntime executionTimeout="9000" maxRequestLength="10240"/> MCITP: Business Intelligence

Hi Kali,Base on your descriptions, I would suggest you adding another "dummy" parameter to the sub report. The new parameter is used to receive string value like this "1,2,3,4" and so on. In the default value of original parameter "RP_cll_typ_l1", we will use the function "Split" to split the value of the new parameter to a array again.Below are the detailed steps:1.Open the sub report in design report.2.Add a report parameter to the report.3.Move the parameter to be on the original parameter "RP_cll_typ_l1".4.Set the default value of the original parameter to be =Split(Parameters!newParameter.Value, ",")5.Now, we can open the sub report with this URL:="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&?New parameter="+Join(Parameters!RP_cll_typ_l1.Value,",")+"'))"Please feel free to ask, if you have any more questions.Thanks,Jin ChenJin Chen - MSFT

Hi Jin, Thank You for your valuable suggestion it works for me. Now I have to pass approx 7000 characters as multivalued parameters values from main report to sub report as key values in URL. I am able to pass till 1700 characters but not able to pass 7000 characters (I am aware about the limit of 2083 characters on URL). Can you please give some tips to achieve this in SSRS 2005 expressions? = "javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fTest_EXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&M_DATE="+Fields!Mon_YY.Value+"&RP_STTS="+Join(Parameters!RP_cll_stts.Value,",")+"&RP_CT1="+Join(Parameters!RP_cll_typ_l1.Value,",")+"&RP_CT2="+Join(Parameters!RP_cll_typ_l2.Value,",")+"&RP_CS1="+Join(Parameters!RP_cust_clssfctn_l1.Value,",")+"&RP_CS2="+Join(Parameters!RP_cust_clssfctn_l2.Value,",")+"&RP_PS1="+Join(Parameters!RP_prdct_sgmnt_l1.Value,",")+"&RP_PS2="+Join(Parameters!RP_prdct_sgmnt_l2.Value,",")+"'))"One more thing I am not displaying my sub report in browser instead of this I am directly rendering it into various format like xls, csv, pdf from main matrix report as per requirement.Tripathi_soft

Hi Jin,Should i have to modified our machine.config file maxRequestLength up to '7000' it is currently as per given below data... < httpRuntime executionTimeout="90"maxRequestLength="4096"useFullyQualifiedRedirectUrl="false"minFreeThreads="8"minLocalRequestFreeThreads="4"appRequestQueueLimit="100"enableVersionHeader="true"/>I alraedy increase maxRequestLength of web.config in report server fodler (as per Tuan suggesstion)..thanks.Tripathi_soft

Hi All,Any tips on the given upper things.If you have pls let me know.Thank You.Tripathi_soft

Maybe try the web.config in |the ReportManager folder as well.MCITP: Business Intelligence

Jin Chen, Can you please help me. I have been trying to get this example to work but to no avail. Can see where I am going wrong. Can you please put together and example using a Report1 and Report2 with one parameter (department) and one field (department). I am desparately at the end of the time rope here and need assistance quickly. Thanks in advance. OS

Yes, locate the file web.config in your report server fodler, edit it and replace <httpRuntime executionTimeout="9000"/> by <httpRuntime executionTimeout="9000" maxRequestLength="10240"/> This is applicable only to the size of the RDL and nothing to do with the IE URL limit. As far as I know there is no work around to overcome this limit.

If your users are OK with rendering the report on the same window, then go for Go to Report instead of Go To URL. Another work around I can think of is , though I dont like it and never tried, from the summary report create a global temporary table and insert the selected parameters into it along with a unique identifier. Then pass this unique identifier to the detail report. In the detail report, query the global temporary table to get the parameter list. Once queried, delete the values from the global temporary table. This approach has its own drawback. It has the potential to fillup your table and also may have permission issues (not sure about it)

You need to generate the URL as follows ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&RP_cll_typ_l1=" "+Join(Parameters!RP_cll_typ_l1.Value,"&RP_cll_typ_l1=")+"'))" In other words, for every value of the parameter you need to add RP_cll_typ_l1=value to the URL. Regards Tuan MCITP: Business Intelligence Hi Tuan Greeting for you !!!! I am trying to acheive the same functionality which you have suggested above but I am having error when I use the following code Could you please tell where am I going wrong & the error which I am getting is as shown below Error 1 [rsCompilerErrorInExpression] The Hyperlink expression for the textbox ‘Project_ID’ contains an error: [BC30205] End of statement expected. D:\Test_Project\Test_Project\Throughput_Detail.rdl ="javascript:void(window.open('http://localhost/Reportserver?/Test_Project/Project_Detail&rs:Command=Render&PROJECT_ID="+Fields!Project_ID.Value+"&BU_KEY=" "+Join(Parameters!BU_KEY.Value,"&BU_KEY=")+" &MONTH_KEY=" "+Join(Parameters!MONTH_KEY.Value,"&MONTH_KEY=")+" &STATUS=" "+Join(Parameters!STATUS.Value,"&STATUS=")+"'))"

You need to generate the URL as follows ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&RP_cll_typ_l1=" "+Join(Parameters!RP_cll_typ_l1.Value,"&RP_cll_typ_l1=")+"'))" In other words, for every value of the parameter you need to add RP_cll_typ_l1=value to the URL. Regards Tuan MCITP: Business Intelligence Hi Tuan Greeting for you !!!! I am trying to acheive the same functionality which you have suggested above but I am having error when I use the following code Could you please tell where am I going wrong & the error which I am getting is as shown below Error 1 [rsCompilerErrorInExpression] The Hyperlink expression for the textbox ‘Project_ID’ contains an error: [BC30205] End of statement expected. D:\Test_Project\Test_Project\Throughput_Detail.rdl ="javascript:void(window.open('http://localhost/Reportserver?/Test_Project/Project_Detail&rs:Command=Render&PROJECT_ID="+Fields!Project_ID.Value+"&BU_KEY=" "+Join(Parameters!BU_KEY.Value,"&BU_KEY=")+" &MONTH_KEY=" "+Join(Parameters!MONTH_KEY.Value,"&MONTH_KEY=")+" &STATUS=" "+Join(Parameters!STATUS.Value,"&STATUS=")+"'))" Hi Tuan I am able to resolve the above issue by interchanging the order of parameters but when I deploy I am not getting the hyperlink Please help me out on this. Your help is highly appreciated on this. Thanks & Regards Ramesh Sripathi

I am trying to construct a multi-value parameter using the syntax above, however I need to wrap an escape() around the parameter value to special characters will translate correctly. I do not want to include the &ParameterName in the escape() as the URL requires the & in order to recognize this is a parameter. Thank you