Maximum Columns in a Matrix?

Hi,

Does anyone know what is the maximum number of columns allowed in a matrix?

Thanks.

The whole point of using a Matrix is to have dynamic column grouping. Hence the number of columns will grow depending on the values for the field used in the column grouping expression.

-Aayush

|||That doesn't answer the question.

If I have a single column grouping with 800 different types, each displaying as a column, will it fall in a heap? If its > 256 then excel will die anyway.|||Well..what I meant is that I don't think there is any way through the report, to limit the number of columns. I suppose this solely depends upon the grouping. Hopefully I'm right.|||

For this particular report, the grouping is coming back with 400+ groups, hence 400+ columns and it is giving a rendering error when just trying to view the report. Is 256 actually the limit in Excel? Maybe it is the same in a matrix report. These reports will mostly be exported to Excel anyway (after initially being viewed on screen) so if 256 is the maximum there that will kill us anyway.

Thanks.

|||from a UI point of view, 400 anything is going to be a killer to the user.

I think you're going to have to do something will drill through.

The alternative is to build a cube and slap a pivot table on the top, at least this should be able to handle the data.

What am I saying? you'd still need to use OWC or excel to view the pivot table....|||

I remeber that I had the same problem before, and also there were an issue for printing it.

SO What I did is that in the query I did a count on the the groups so lets say I wanted to print only 10 columns on a page, I added a counter in the querry (each 10 columns will have the same number) so it gave the possibility to add a list in the report where the group is the counter that I added and then I embeded a matrix in the list. This way You will end up having multiple matrix in the report with a max of 10 columns each.

Hope this will help.

Paul.G

|||I think I might have to find a way for them to restrict the number of groups, and therefore the columns. Otherwise I might have to try out that list idea. Thanks for the help guys !