Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Matrix issue redux

Author  Topic  asuds Starting Member 4 Posts Posted - 2004-12-31 : 10:52:50 So my original description was unclear. Here is a new attempt to go with the New Year (Gregorian). The real problem is that I need to be able to evaluate the value in the cell of a matrix that I specify by *relative location* to the current cell. Because: I have a matrix with two row groups and a column group. All groups have subtotals. I want to have links from the cells in this matrix to another report. I put navigation on the single data cell in the matrix layout, with parameters passed based on the groups and values. I.e. parameter 1 = row group 1 value, parameters 2 = row group 2 value, etc. The problem is that I want the subtotal cell to go to subtotal report. To get this to work I need to be able to get the link to be able to detect if it is coming from a subtotal row or not. When I look at the resulting matrix there is a link of the data cell for the subtotal row, but the parameter passed is the *first* value in the group. I have tried: * Passing rowgroup2.value and then checking for Total in my linked report, but when this link came from a subtotal cell it passed the first value that would be found in the row group. * Detecting before passing parameters via: IIF( rowgroup2cell.value = "Total", pass ALL, pass rowgroup2cell.value) but that doesn't work. It is a little funny, as there is kind of an overlap between the "data" cell and the “subtotal data” cell (for which due to the matrix layout I can't independently address). Any thoughts would be greatly appreciated, as getting these links to work properly would really make this report shine and make everybody’s day. Happy new years --- Andrew