In your last response your mentioned, 'in your SSRS report, you could create a report variable'. Can you tell me how to create this report variable? Is this a report parameter...

Can you tell me what you mean by, "Basically, FILTER in the stored procedure, then do the Counts and % in the report?
You are saying to concatenate the results...

You are correct that the report is using a matrix.
Your diagram is correct on the hierarchy of the data.
If I use the value obtained from the calendarname...

I need grand totals of the rows that appear on the report. I like the sql that you provided since it would work. However the problem is how will I...

In answer to your last questions:
1. The ssrs report is using ssrs 2008 but it is running on a sql server 2012 database.
2. You are correct that the...

Thanks for your assistance so far!
I want to mention the following in regards to your responses:
1. No I am not adding total lines to outside groups. Can you...

I did something like you suggested using the images property. The problem is that this is a 2 page letter sent to students. The first page is the letter and...

Are you saying that after my disable syntax is located after the item that is being looked at, there should be no white space and no literals to look at?...