December 30, 2008 at 4:40 pm
I have an SSRS report that groups report dates by week. The default view collapses the report dates and only shows the week value. I am trying to set up navigation to pass the report date to another report when a data cell is clicked.
Currently, the report successfully passes a single report date fine, if the week is expanded. But if the week is collapsed, it only passes the first value. The destination report is set up to receive a multi-value parameter for the report date.
I have successfully passed multi-value parameters to the report such as Region (=Parameters!rgn_val.Value()), but in this case I'm not dealing with a parameter, I'm dealing with a Field value. I assumed (apparently incorrectly) that since the cell is derived from multiple report dates that it would pass multiple report dates through the parameter. I have tried both (=Fields!report_dt.Value()) and (=Fields!report_dt.Value) as the Parameter Value to pass. Neither generates an error (syntactically correct), but neither give me what I want, either.
Has anyone gotten this to work? Thanks in advance.
January 30, 2009 at 10:19 am
I too share this same condition - I want to drill through from a matrix that has "totals" columns into a "details report" that would show all the detail groups.
June 7, 2012 at 11:21 am
From what I can find the forums state that Field.Value can only pass a single item, regardless. For example:
Type Blue Red Total
------- ---- --- -----
Widgits 15 5 20
If I click on 15, it will pass "Blue"
If I click on 5, it will pass "Red"
If I click on 20, it will pass "Blue" NOT (Blue and Red)
This seems odd (but seemingly par for the course with SSRS) that this would not be possible since it is so common to want to display data detail that makes up a sub total!!
Is there a workaround where you can make this possible, at all? Can Parameter.Value be used somehow to dynamically pass whatever makes up the subtotal fields? Or are we just SOL on this one?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply