###### Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

Deciding to stick with EE.

Mohamed Asif

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
###### Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

# Help with Grouping's group expression?

SSRS
Hi,

Can someone explain or point to a webpage where it explains how to use the Grouping's group on expression section in more depth?
You know in the Group On expression, you can have multiple expressions.
1) Can I think of those multiple expressions as multiple filer queries to group?
2) In the Group on Experssion, is this kind of expression allowed?
Say I have this table with the following fields(Color,Shape,Points)
Color can be yellow,red,blue
Shape can be circle, square,rectangle
Points can be 1,2,3, 4

I want to group them by Shape and group on retangle in more detail.
So in my experssio I put
=Fields!Color.Value
=Fields!Shape.Value ="rectangle" and Fields!Color.Value <> "Yellow"
=Fields!Shape.Value ="rectangle" and Fields!Color.Value ="Yellow" and Fields!Points.Value = 3