good matrix tutorial

Does anyone know of a good matrix tutorial which shows a finished report and how the choices for Page, Columns, Rows, and Details map to a finished report? Having a tough time wrapping my head around the direct impact, and for whatever reason, my sample data keeps triggering an "Out of memory" during preview mode.

Hello,

I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:

http://msdn2.microsoft.com/en-us/library/ms157334.aspx

Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.

With regard to your Out of Memory error... how many rows are being returned from your DataSet?

If you have any specific questions, feel free to post them here.

-Chris

|||

I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.

I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).

Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.