Matrix: Jump to Report based on Subtotal

Question

Hi,

I want to jump to a new report based on the cell clicked in the Matrix report. I am able to do all that using the Java script technique and the embedded jump to report option. The only issue is that when I click on the Subtotal data, the report is grabbing the first data row appearing for that subtotal along with  the column and giving me the data in the other report. So basically I am not able to tell in the expression that this cell is a subtotal cell.

Using the image below:

Scenario 1 : I click on 34 from the row 20130123 and Gross-- I am able to pass this date and Gross value to other report and get the details displayed in that report.

Scenario 2: If I click on 920 from Jan (Subtotal in the matrix on month name) and Gross, the values passed are for Gross and the first date data it find for Jan (which is 20130123 in this case). What I want is to somehow figure out that this is a subtotal row and therefore grab the month information and pass it as parameter to the other report.

I am using SSRS 2005 btw.

Appreciate anyone's help in advance.

Answer 1

You need write custom code.

Use this to pass the parameter. With this link embedded with this code - when the report opened will get those parameters.

=Code.OpenURL(“http://[Your Server]/ReportServer?/Folder/ReportName&rs:Command=Render
&MyFirstParam=<Date>&MySecondParam=” & Fields!MyField.Value)

---

Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

Answer 2

Thanks for looking into this and replying.

But I was able to solve it using combination of In scope function for the month row and Date row.

Answer 3

Better if you share the details high level so that it helps rest of the forum visitors/some on who has similar requirement.

Regards,

---

Phaneendra Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Answer 4

I will try.

From my example above, when month level is not expanded and numbers are subtotaled at month level then below will be applicable.

NOT(Inscope("date field group")) will result in  False

This can be used to determine if the row group is expanded or not and therefore can be used to pass the parameters to the target report accordingly.

Answer 5

I also came across this link which is on almost similar kind of discussion.

Thought someone might find it handy.

http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/03149783-FB4A-4B51-8D0C-D6FEC66986A8