October 23, 2014 at 1:07 pm
Hello all,
I have been plagued by this for several days now so I thought I would reach out for help. I have 2 reports created both with the same parameters. I am trying to link the 2 like this:
Report 1 has a textbox that I have added an Action that goes to another report. In that window, I am passing all the parameters to this report. Only 3 of the 5 parameters pass. I have made sure they were all the same format (i.e. varchar) and they still will not pass. In each stored procedure, I am using a multi-select (which has worked in the past) but did change to an IN statment with no luck.
I am not sure what I am missing but basically what happens is that I click the "hyperlink" and it moves to the next report, 2 out of the 3 parameters are blank when they should be filled out....
Is there something simple I am missing here? All other reports work fine and these 2 particular reports I just created have the issue.
Thoughts?
October 23, 2014 at 6:14 pm
Hi
If you are passing parameter through Action URL, bear in mind that there may be length limitation of URL (http://www.boutell.com/newfaq/misc/urllength.html) and you may pass values that contain lots of blank (when you use multi-select particularly). You can check the URL address to see if it contains a lot of "%20". You may need to trim it so it can go through properly. Try the below method that may help with your problem.
http://www.mssqltips.com/sqlservertip/2844/working-with-multiselect-parameters-for-ssrs-reports/[/url]
Hope this help?
C
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply