Monday, March 12, 2012

Matrix Dynamic Column problem HELP!

Ill start off by saying that I am an ASP.NET developer and I am self-taught in using SSRS2005. (quite poorly I might add) That being said I am having a problem with a report im building. This report has 10-12 different metrics I am reporting on and I have each of them displayed in their own matrix. The first matrix was created by the report wizard that launches when you add a new report.

To give you an overview of how I am setting up these reports I will describe the structure I am using on nearly all of the matrices. I am reporting on classes that are managed by my company and held at 3rd party locations. My matrix has the 3rd party location in the rows and the quarter the class was held is the column. Matrix setup looks like this:

__|_Quarter
|MetricA|MetricB|MetricC|etc...
LocationA|
LocationB|
LocationC|

The problem Im having is this. All matrices that weren't created by the wizard don't grow dynamically. Say I have 2 quarters of data I am reporting on, Instead of having a column for quarter1 and quarter 2, the report generates separate matrices for each quarter. This is true for each matrix that I created using a matrix control from the toolbox. The matrix that was created by the wizard however, has dynamic columns that grow to the right as expected.

I am populating my datasets using Stored Procedures and the matrix that behaves normally uses a different dataset than the 4 others I have completed thus far which share a dataset.

I have looked everywhere I can think of for a checkbox or a property I need to adjust and I cant find one. Anyone have any ideas?
Well it appears that I had each Matrix in its own List and I assume that there was some configuration of the list that I missed because when I took it out of the list the matrix rendered as I had intended it to. So I guess I better go read up on lists! Smile

No comments:

Post a Comment