Okay, I'm not a DBA, so take this with a grain of salt.
What if you had a table that held the size of the log over the course of...

Yeah, I figured that out after taking a break for a while... (That's my crummy code he was posting about.)
Took me a minute to figure out I could use...

Why not just use a the 3-part naming convention when creating your view?

USE Tempdb;
GO
CREATE VIEW MyView
AS
SELECT CustomerID
FROM Galactic.dbo.Customer;

I'm creating...

Thanks for the data, and expected results - it helped a lot.  I fixed it up and created the scripts to populate your table - (since you're new, you get...

This would be infinitely easier if you normalized your table structure first. Repeating groups is the first thing you remove when normalizing a table.

Can't you take my union query (or similar) as the source, and then use COUNT() as the aggregate at the intersection? Something like A would be on Columns, C would...

General rule of thumb when you're not sure of a design - create the tables you think are correct. Then write queries to answer the questions you have about the...

What does the raw data look like? The results of a Matrix are useless if you're trying to create a chart - you need the unpivoted data.

That looks more like the underlying table is set up wrong. Either that or your example is misleading.
If your table is set up wrong, a query like this might...

Jeff,
I would model it like this:
Person--(1,M)--FoodAllergy--(M,1)--FoodItem--(1,M)--Ingredient_In--(M,1)--Recipe
Person has FoodAllergy to FoodItem which can be an Ingredient in one or more Recipes.

The structure of a junction table,...

Probably the easiest way is to stack the tablixes on top of one another and set the visibility property based on the parameter value.

Jack,
Luis' answer fixed it. This is the query I ended up using that worked for me:
SELECT   candidate_id, first_name, last_name
FROM    Candidate AS c
WHERE   (NOT...

Super cool, Luis! Many graces!
This worked:
SELECT   candidate_id, first_name, last_name
FROM    Candidate AS c
WHERE   (NOT EXISTS
          (SELECT   1 AS Expr1
           FROM    Candidate...