Saturday, February 25, 2012

Report Action + multi parameters

Hi

Using Report Action, Can accept multi parameters from Excel Pivot Table?

Exist some way of doing this.

Please help me

thanks for your commentaries

carlos

Your probably better off using an url action instead of report action(which behind the covers is basically the same). Because if you want to specify more than one value you must specify that parameter over and over again at design time(i think), instead of concatenating a string. This because a url with a multivalue parameter looks like this:

http://localhost/ReportServer?%2fCatalog%2fMultiReport&rs:Command=Render&ParameterTest=1&ParameterTest=2

Look at these two links, i think you will get on how to do it in a URL action:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1047470&SiteID=1
http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||

Hi, thank for the help.

But, When I select several cells, since I do to pass them as parameters to the URL?

Is it possible?

|||

Actions are executed for specific cells based on the co-ordinates of that cell, so I would not expect the Excel user interface to allow you to launch an action when multile cells are selected.

|||

Ok, thank a lot for you help

No comments:

Post a Comment