February 5, 2016 at 12:47 am
Hi ,
I've a URL below with 5 multi select parameters (Branchcode, Branch, Niche, Team & Consultant) and 3 single select parameters (StartDate, EndDate & Structure).
My main report has two views controlled by a parameter called Reportview hence you see the IIF statement on the URL script.
My problem is that the URL works fine to pass values to the sub report/target report when I use single select parameters to all my parameters but when I use multi select by adding Join statement to the only 5 multi select parameters the hyperlink on the main report stops to work. When I remove the join on the last parameter called consultant the hyperlink works but it does not pass the value of consultant parameter to the target report. All the other parameters on the target report will have values passed but the consultant is empty.
See the URL below and assist.
=IIF(Parameters!ReportView.Value="ConsultantView","void(window.open(" & Parameters!FLOWSGROWTH_URL.Value & "&rs:Command=Render&StartDate="+Parameters!StartDate.Value+"&EndDate="+Parameters!EndDate.Value+"&BRANCHCODE="+Join(Parameters!BRANCHCODE.Value,"&BRANCHCODE=").ToString+"&STRUCTURE="+Parameters!STRUCTURE.Value.ToString+"&BRANCH="+Join(Parameters!BRANCH.Value,"&BRANCH=").ToString+"&NICHE="+Join(Parameters!NICHE.Value,"&NICHE=").ToString+"&TEAM="+Join(Parameters!TEAM.Value,"&TEAM=").ToString+"&CONSULTANT="+Join(Parameters!CONSULTANT.Value,"&CONSULTANT=").ToString+"','_blank'))","void(window.open(" & Parameters!FLOWSGROWTH_URL_MANAGEMENT.Value & "&rs:Command=Render&StartDate="+Parameters!StartDate.Value+"&EndDate="+Parameters!EndDate.Value+"&BRANCHCODE="+Join(Parameters!BRANCHCODE.Value,"&BRANCHCODE=").ToString+"&STRUCTURE="+Parameters!STRUCTURE.Value.ToString+"&BRANCH="+Join(Parameters!BRANCH.Value,"&BRANCH=").ToString+"&NICHE="+Join(Parameters!NICHE.Value,"&NICHE=").ToString+"&TEAM="+Join(Parameters!TEAM.Value,"&TEAM=").ToString+"&CONSULTANT="+Join(Parameters!CONSULTANT.Value,"&CONSULTANT=").ToString+"','_blank'))")
February 5, 2016 at 7:09 am
What is the length of the URL these picks are producing? You might be hitting the maximum length after concatenating those picklists. IE still has a limit of 2,083 characters as far as I am aware.
February 9, 2016 at 1:20 am
Hi SSC-Enthusiastic,
The size of the URL that I've sent above is 1,155 but if the size also includes the values passed from each parameter then the size might exceed the limit you have said.
If the URL size includes the values, is there a way I can limit the passed through values to specific number so that my URL can qualifies
February 9, 2016 at 2:46 am
My report is not working with the same URL sent when I select few values from my parameters meaning the URL includes length required the values
May 1, 2018 at 4:02 pm
I'm having the same question as above and curious if anyone has come up with a solution?
May 16, 2018 at 8:38 am
derekschumacher81 - Tuesday, May 1, 2018 4:02 PMI'm having the same question as above and curious if anyone has come up with a solution?
Multi-select parameters being passed into a viable URL is not typically practical for more than a few values, unless the URL and the underlying web site are constructed ahead of time to
be able to manage some form of URL that would include the additional values, and given the relatively small number of values that could actually be passed, given the length limit, this just seems impractical.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply