Matrix Page Breaks within a list / Visibility is conditional

Think I have found a bug.

I have a report that has a Parameter called "LevelOfDetail" This has 2 possible values "Summary, Detail, or Combined".

The report has a Summary Section and a subreport that holds the details.
WIthin the summary section is a Matrix (a list of all properties and some values)

If they choose to see the details, the matrix in the details section will show a break out of all this information summarized in the summary section.

The Details Matrix is set to have a page break at the beginning and end of the top level group.

I have a list control on the summary page that contains the details subreport and passes the appropriate parameter.

Everything works the way I want until I try to set visibility on sub report.

Once I set the conditional visibility of the report objects (based on the Level of Detail parameter) the page breaks are not recognized.

This is important as the user will never print the report, but will be downloading to Excel.

If the page breaks work correctly, each page is assigned a different worksheet in their downloaded workbook.

Any help, please let me know.

Page break and visibility condition can not be used for same componenet. I mean to say they are not supported by SSRS 2005. u need to go for a work around.

Priyank

Matrix drill through problem

So here goes the explnation. The problem is specifying an all parameter in a drill through on the value cell of a matrix for the columns in the matrix that are not expanded.

Here goes the example

Matrix for sales.

Region | Shop | Number of sales. And then financial period would be at the top. Everything is collapsed on load so it looks something like this.

Region1 | | 50

Region2 | | 75

Then you expand Region.

Region1 | Shop1 | 30

Region1 | Shop2 | 20

Region2| | 75

At this point if you click on the 30 for shop 1 is drills through into another report passing parameter Region1, shop1 and financial period. This is perfect. The problem comes in that if you haven't expanded region1 and you click on the 50 it drills into the other report but passes through Shop1 as the shop parameter. How can I get this to pass though an all option for the unexpanded columns in the matrix. This is ofcourse just an example and my matrix has quite a few more column and stuff.

Please guys, any help would be appreciated.

This is Reporting services 2005 linking to SSAS2005 cube.

Thanks in advance

Hello,

Try this: http://msdn2.microsoft.com/en-us/library/ms156490.aspx

|||

Yeah.

iif(InScope("MatrixColumnGroup"), ParamaterIfTrue, ParameterIfFalse)

On interesting thing about this. Is that in BIDS the drillthrough doesn't work on the totals but it works on the report viewer control. I think this is a bug. If you drill through on a total it will take the first row grouping as the parameter but if you drill through from a front end using the report viewer control it works perfectly.

Good luck, thanks for the help.