I'm having (what I think is) the same issue-- how to suppress an entire matrix row when there is a particular value. Visibility is not a property when you...

Figured it out:

=Iif(me.Value < 0,"Red","Black")

I've never used "me.Value" before-- neat trick!

AWESOME!!! Thanks!!!!

AWESOME!!! I have a feeling I'll come back to this thread in about 6 months when the issue pops up again and I forgot what works. Thanks for...

Yes, one thought that had crossed my mind was (using my previous table result example) to include rows with precalculated (through SQL) results and hand pick what gets averaged vs...

As Neils said, I'm working off existing data which is a culmination of some hefty stored procedures.

But most importantly the format required is more like this:

...

Right click your row, insert / make sure you have a table footer.

The Membercity column footer should be:

=Sum(Fields!MEMBERCITY.Value)

Right click your second column (CITY), insert a column to the right, call...

Niels, I'm thrilled to hear RS 2008 features can do this; we'll be rolling that out in a few months. Your links will help me hit the ground running.

Since...

"WHY WASN'T I USING THIS FORUM A YEAR AGO?!" 🙂

[and one more variation --cheating off your case syntax]:

SELECT *

FROM tblData

WHERE (

(@Quarter = 1 and MonthID IN (1,2,3))

OR (@Quarter = 2 and MonthID IN (4,5,6))

OR (@Quarter = 3 and...

Wow, I totally bow to you.

I love 'CASE' statements-- this particular format of WHERE CASE is new to me.

(I could never find good examples of it)

I will...

Oh my gosh, that's embarassing. I didn't even think about just pre-processing the columns before hitting the report. I really appreciate your response--it will help tremendously.