Sign in

Microsoft.com

Microsoft

Remove From My Forums

SSRS CRM Report: Pass more than one row (GUID) thru a tablix click action

Question
0

Sign in to vote
Hi All

So let me try to describe the Problem:

I have made a report which shows data in a table.
Now Within this table I group on date (month) and some other unnecessary criteria.
Therefore the data which will be shown is summarized. Please see pic below.

But exactly there’s my problem. In the subreport I always get the first id. But that’s not quite what I was expecting.

I would expect the following behaviour:

Sum
'--> sumarized amount of several rows (eg. id of row one, id of row two, if of row n)
'--> pass n id's
'--> parameter PreFiltering of the Subreport contains an array of the passed id's

Final question: Is it even possible to pass more than one id within a parameter with this approach?

Things I’ve already tried without success:

JOIN functionality
SPLIT functionality
- Edited by Claudio Vincenzo Thursday, August 29, 2013 6:33 AM
Wednesday, August 28, 2013 8:28 PM

All replies

1

Sign in to vote

Hi Claudio,

You will have to create Multivalued parameter in the Sub Report.

Use the below link for this.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ae5ac615-1076-428d-9fcf-6c27e5fee1f0/parameter-passing-from-master-to-subreport

http://andreaswijayablog.blogspot.in/2011/04/ssrs-repeat-subreport-with-multivalue.html

Hope this helps!

Thanks!

Thursday, August 29, 2013 6:01 AM
0

Sign in to vote
Thanks a lot for your attention

But, im not sure if this is gonna help me.

Please see the screenshot below

So the goal would be:

click on the "700"

'--> it opens the subreport

'--> within the supreport i can do stuff with the three passed row id's (eg. 333d3..., 444e4..., 555f5...)
- Edited by Claudio Vincenzo Thursday, August 29, 2013 7:09 AM
Thursday, August 29, 2013 7:00 AM