Crosstab Reports in SSRS

I can say that the Matrix (crosstab in SSRS) capabilities in SSRS 2005 are quite good, and are pretty flexible.  It does take some playing around with to get used to configuring the table properly, but it’s much less rigid than previous report writers (cough).

You can add filters at any group level, including detail, and even add drill down if you like.  A quick google search on matrix and SSRS should yield some good articles, FAQs, and blog posts on the tool.

I think you’ll find that you can recreate quite a bit of the pivottable in SSRS.  The only thing that you wont find in SSRS is the ability for the user to dynamically manipulate the matrix without some parameters to manipulate the matrix or dataset properties.

Best of luck!

-Ryan

We don't have SSRS installed yet (it's on the upcoming projects list) and I have a capabilities question.

We currently have a report we are using for show settlement that is an Excel 2007 Pivot Table with the data coming from a custom report (the report exists just to extract the data for this report).  We take advantage of some of the pivot table filtering capabilities because different partners have slightly different requirements (some want to see fees, some don't, etc.)  How much of this report can be implemented in SSRS?  Does the SSRS crosstab format work similar to Excel or.....?

If SSRS won't work, what other options do I have?  I need to reduce the number of steps needed to produce this report.

Thanks in advance.

 -steve

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.11.33/2031 - Release Date: 04/03/09 06:19:00

I can say that the Matrix (crosstab in SSRS) capabilities in SSRS 2005 are quite good, and are pretty flexible.  It does take some playing around with to get used to configuring the table properly, but it’s much less rigid than previous report writers (cough).

You can add filters at any group level, including detail, and even add drill down if you like.  A quick google search on matrix and SSRS should yield some good articles, FAQs, and blog posts on the tool.

I think you’ll find that you can recreate quite a bit of the pivottable in SSRS.  The only thing that you wont find in SSRS is the ability for the user to dynamically manipulate the matrix without some parameters to manipulate the matrix or dataset properties.

Best of luck!

-Ryan

We don't have SSRS installed yet (it's on the upcoming projects list) and I have a capabilities question.

We currently have a report we are using for show settlement that is an Excel 2007 Pivot Table with the data coming from a custom report (the report exists just to extract the data for this report).  We take advantage of some of the pivot table filtering capabilities because different partners have slightly different requirements (some want to see fees, some don't, etc.)  How much of this report can be implemented in SSRS?  Does the SSRS crosstab format work similar to Excel or.....?

If SSRS won't work, what other options do I have?  I need to reduce the number of steps needed to produce this report.

Thanks in advance.

 -steve

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.11.33/2031 - Release Date: 04/03/09 06:19:00