开发者

How to calculate subtotal and show heading in sql server reporting 2008 R2

开发者 https://www.devze.com 2023-04-07 02:44 出处:网络
I have data like picture below I want to display my data like this So I want to know how can i show group 01 02 03 and then calculate their respective to开发者_运维知识库tals in sql server report

I have data like picture below

How to calculate subtotal and show heading in sql server reporting 2008 R2

I want to display my data like this

How to calculate subtotal and show heading in sql server reporting 2008 R2

So I want to know how can i show group 01 02 03 and then calculate their respective to开发者_运维知识库tals in sql server reporting 2008 R2.

Is there any built-in technique to do this ?


Create a group with the expression below

=Mid(Fields!Code.Value,1,2)

Mid is similar to sql Substring function

0

精彩评论

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