开发者

How to display some data in SSRS 2005

开发者 https://www.devze.com 2023-02-10 20:50 出处:网络
I want to display some data in Reporting Services (SSRS 2005) like this: Month 1Month 2 Month 3... Employee

I want to display some data in Reporting Services (SSRS 2005) like this:

       Month 1    Month 2 Month 3  ...

Employee

Smith

GrossSales  20 $              15 $          20 $

Green

GrossSales  50 $               25 $          20 $

 ...

I want to use table and/or matrix, but how? I get the data from an MDX-query which returns Name, Month and GrossSales.

Also,开发者_开发知识库 the row and column names should not be visible.


The Matrix is definitely the way forward for this one. It shouldn't matter that it's an MDX resultset.

If you set the column group as the month column and Employee on the row group you'll get exactly the result you're after. You can then put Gross Sales into the cell and it will sum it up.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号