please check below link will help you fill up color

http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD#13

check this link will help you

http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD#13

Can you please provide more information

If you have three separate report then first finish report 1 then go for report 2 .

PLEASE ADD AS BELOW

SELECT DISTINCT

convert (varchar(12), MonthEnding) as MonthEnding

FROM Sales

I know why its happen because if we put fields in row group in table then its show exactly you had problem , So remove group in report design and...

Hi Jenny

SSRS is showing report based on query , Its look like you don't have to...

please make at bottom expression as below

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

Thanks

Raj