Are you authoring your report or just consuming it? Maybe you don't have rights to add columns?

In SSRS, you can right-click on your dataset, and then choose "Add Calculated Field" and then do something like
=LEFT(Fields!Protocol.Value,3)

Then you can group by that...

CAST(AVG(((CASE WHEN vWorkOrders.StatusCode = 'CMPLT' THEN 1.0 ELSE 0.0 END)/1.0)*100) AS DECIMAL(10,2) as [Completed], 
?

Is this an SSIS question?
Why not just use a DELETE/TRUNCATE statement on the source table after the insert, maybe inside a transaction?

"Each possible combination" = cartesian product. Simple as that.

Union and then query? What did you try?

It would be infinitely clearer if you posted a proper CREATE TABLE script, with INSERTS to populate the table for your sample data. It's really easy to misinterpret the data...

Can you post the definition of the stored procedure? I'm just wondering if you really need to do this with a cursor. Most of the time, "cursor" is a dirty...

So you want an aggregate by month first and then month over month change?
If you're using 2008, I think you have to use a CTE to point to the...

No need to apologize for asking questions here! That's what it's here for. As long as you read the Best Practices article and follow it, you'll stand a...

" the idea is to create a single report from data fetched in multiple tables"

I'd write the SP in SQL Server first, and make sure it returns the data...

Sounds like an extra credit assignment for a take home test. Pass.

Here's what I used... modified from user's OP:
USE TEMPDB;
GO

Create table client_info
(client_number int,
Claim_date date,
Product_id int
);
GO
Insert into client_info

Which part are you stuck on? This place isn't an answer machine... If you post what you tried, people will be much more willing to help. So what have you...