SQL Developer - Connecting Databases

Hi Selvar

Thanks for confirming this limitation of SSRS 2008. This works indeed fine in the browser but not in a report subscription (MHTML). And as you stated it DID work in SSRS 2005.

As your workaround only works with hard coded parameters I'm wondering whether you can think of a workaround of passing more flexible parameters...

My rptParent has a multi-value parameter named Vertical. This parameters is split and joined to be used in a stored procedure as follows:

=split(join(Parameters!Vertical.Value,","),",")

rptChild has the same multi valued parameter named Vertical. The action from rptParent to run rptChild are to join the parameters again:

=Join(Parameters!Vertical.Value,", ")

The parameters passed should match the ones that were selected in the rptParent (subscription) and they vary for different users.

Any suggestions are appreciated!

Cheers

Sander

Hi Sander,

        Looks like you want to automate the parameter building process for multi value parameters. For this we need to write a piece of custom code and here is that i've done it for you.

Under Report-> Report Properties -> Code, Paste the following

Public Shared Function BuildParams(ByVal param As String, ByVal paramname As String) As String

       Dim params() As String = Split(param, ",")

       Dim url As New System.Text.StringBuilder

       For Each val As String In params

           url.Append("&" + paramname + "=" + val)

       Next

       Return url.ToString()

   End Function

All i'm doing in the above code is just getting the parameter collection and building the url dynamically.

Now in the textbox properties, Action -> go to URL, you need to do the following,

=Globals.ReportServerURL & "?" & Uri.EscapeDataString(Globals.ReportFolder & "/" & "Child") & Code.BuildParams(Join(Parameters!empid.Value,","),"empid")

Where  Code.BuildParams(Join(Parameters!empid.Value,","),"empid") is calling the above written function with the list of values from the parameter and then the actual name of the target report parameter(s). The final built URL will look some thing like,

http://machinename/ReportServer?%2FMhtmlDrillThroughBug%2FChild&empid=2&empid=5

HTH!

Selva.

Hi Selva

Sorry it has taken me some time to get back to you.

I have now been able to try your solution and it works a treat! Thanks for your help!

Cheers

Sander