April 25, 2008 at 8:01 am
[font="Courier New"]
Help.....
I have a matrix that looks like:
| Year1 Year2 Year3 Year4
(Cat) |(Subcat)|--------------------------------
-A | aa | 100 200 300 22
| a2 | 487 54 98 145
______|___a3___| 0 28 277 85
+B | 150 400 457 134
+C | 200 500 100 864
Category shows the subtotals of all years for each category and opens up to show the subtotals for each subcategory.
I want to be able to jump to a specific report based on the category and pass the category, subcategory and year to the report.
If I click the value for C/cc/Year1 I need to pass that information to report 3. If I click 22, I need to pass A/aa/Year4 to report 1, etc...
..and only if the subcategory is displayed, not if it is rolled up into the category totals.
thanks in advance.
Johnny
[/font]
April 25, 2008 at 2:02 pm
you need to display the 22 rows, on your Report1, right?
your Report1 must have the following parameters:
Category
Subcategory
Year1, Year2, Year3, Year4
then, you pass these values to Report1 from your Matrix Report:
Category = fields!Category.value
Subcategory = fields!SubCategoryCategory.value
Year4 = fields!Year4.value
April 28, 2008 at 6:08 am
Not quite. If in this example I were to click on 22, which is the intersection of Category A, Subcategory aa and Year4, then I would want to be able to pass A, aa, Year4 to a report that gives me the details for those parameters. If I were to click on a figure in a row for category B, that would be a different detail report for that category. This is a dynamic matrix and there could be a variable number of years, categories and/or subcategories available when this matrix is displayed.
The matrix properties under "Groups" has groups by rows Category and Subcategory, and column groupings by FiscalYear. So in my "Jump to" report navigation, I cannot know which report to jump to until the matrix has been filled and it is determined which categories it contains.
What I would like to be able to do is something like:
=IIf(Fields!Category.Value = "A", "CategoryA_Details, IIf(Fields!Category.Value = "B", "CategoryB_Details,..etc))
up to the 12 possible categories that I have. I know this isn't right, but
[rsNonAggregateInMatrixCell] The DrillthroughReportName expression for the textbox ‘textbox2’ references a field outside an aggregate function. Value expressions in matrix cells should be aggregates, to allow for subtotaling.
Build complete -- 0 errors, 1 warnings
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply