开发者

SQL Server Reporting

开发者 https://www.devze.com 2023-03-04 19:03 出处:网络
I have a Matrix style report that I have created and it is currently displaying a total count of items for a series of companies throughout a 12 month period.

I have a Matrix style report that I have created and it is currently displaying a total count of items for a series of companies throughout a 12 month period.

           [Company1]      [Company2]        [Etc....] [Total]
[May]    (Count)(Percent)
[June]
[Etc]
[Totals]-----------------------------------------------------

The last column total is a subtotal function and automatically adds column counts based on what is in the Column group which in my case gives me a total for both (Count)(Percent)

I only want to show <Count> but I don't find any method of modifying the parameters for the subtotal function.

The only way I found was to add an additional matrix to the right hand side of the main but only display 开发者_如何转开发total counts. Kind of hokey and I will refrain from implementing it at this time.

Any suggestions?

0

精彩评论

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