July 23, 2010 at 8:53 am
I have a matrix report with one column called matrix1_month_name and one row called matrix1_owner. I added a navigation to the data cell. The parameters passed are as following...
name -> value
month_name -> =fields!month_name.value
year -> =fields!.year.value
owner -> =fields!owner.value
During runtime, clicking on any of the data rows return the correct numbers since it passing a single Owner, however, when I click on any of the total cell, it always passes the first Owner and not ALL Owners. I found a link to a similiar issue but when i click on any of the hyperlink (in data or total), it passes blank for Owner and returns no data. Here is the expression i am using for Owner parameter value based on the example from the link. I tried both examples below with same results....
=iif(InScope("matrix1_month_name"),
iif(InScope("matrix1_dept"),
Fields!count.Value,
NOTHING,
iif(InScope("matrix1_dept"),
Fields!count.Value,
NOTHING))
=iif(InScope("matrix1_month_name"),
iif(InScope("matrix1_dept"),
Fields!count.Value,
Fields!count.Value),
iif(InScope("matrix1_dept"),
Fields!count.Value,
NOTHING))
August 13, 2010 at 1:21 pm
anyone?????
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply