This solution worked - Thanks!

Summed up as follows:

I have a multi-value parameter listing a list of products, named "products"

I created a second parameter named "all_products_count" that is set as multi-value...

I *believe* when you choose to have the Available Values loaded from a query, then that parameter becomes required.

hmm... let me get this straight. You want to use the same color for all rows of a customer. For example: Green for everything belonging to customer A,...

It looks like there isn't something exactly like I was hoping, but I think this solution would work best if I was using a temp table. Thanks

Not exactly. That would provide a complete copy of an existing table. I would like to make a new table using parts of other existing tables.

So...

Ahhh... I was wondering if this would be the case.

When you say I would need a custom front-end, are you talking to the report itself or the entire "Report Services"...