Anyname Donotcare Anyname Donotcare - 9 days ago 6
C# Question

How to group report vertically and horizontally at the same time?

I use

in my
report to group Vertically And horizontally at the same time .But i get a result differs a little from my target .

My Report is like this :

enter image description here

The Current result is something like that:

enter image description here

My target should be like that :

enter image description here

My query dataset is like this :

Company year Tot1 tot2
3001 2016 60.7332300 58.093040
3001 2015 66.1421300 64.754000
3002 2016 211.3360000 94.113000
3002 2015 169.8230000 168.082000

alejandro zuleta
Request :

![enter image description here

How to change the report to achieve my target ?


If you can't change your query and you are comparing two different years, you can hardcode the Total 1 and Total 2.

enter image description here

I created four columns and used these expressions:

=MAX(Fields!Year.Value) Will return 2016
=MIN(Fields!Year.Value) will return 2015

To get the values use:

Total 1 for 2016:


Total 1 For 2015:


Total 2 for 2016:


Total 2 For 2015:


You will get:

enter image description here

Note no columns groups were created. Category was added as Row Group.

Let me know if this helps.