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

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

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

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

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

Troubleshooting
Research
Professional Opinions
Ask a Question
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?

Avatar of dkim18
dkim18 asked on
SSRS
8 Comments1 Solution409 ViewsLast Modified:
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


Are these OK experssions?

ASKER CERTIFIED SOLUTION
Avatar of Emes
EmesFlag of United States of America imageData archithect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answers