Wednesday, March 21, 2012

Matrix Subtotal Action Hyperlink

I've created a matrix report that uses the "Jump to URL" option of the action property to allow my report to drill down to a website using query strings.

For example, the action property looks something like this:
="www.mywebsite.com/page.htm?company=" + Fields!Company.Value + "&status=" + Fields!Status.Value

This works nicely for all the cells in the matrix, but it doesn't work for the subtotals. For example if I click on the subtotal for company "ABC" for all statuses, I would like my query string to link as follows:
="www.mywebsite.com/page.htm?company=" + Fields!Company.Value + "&status="
where no status is specified.

Any ideas or suggestions?
ThanksI did a little more searching and found my question has already been answered here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=24371&SiteID=1

No comments:

Post a Comment