I know why because that @PayrollConfirmTable is a temporary one and thus i can't get result when I execute the table outside of the function. How can I make it...

Thank you. How could I format nicely, especially for block of sql code for better readability?  I've edited select datediff(day,wr.StartDate,wr.EndDate) from WorkingRecord wr inner join EmpTbl e ON...

Thank you. I feel like I am connecting the dots. By the way, mind explaining me why you Select TOP 20 when using cross apply, rather than just select? Purely...

Thank you for your reply and correcting my code. That parameter @EmpID I am trying to pass can't really passed into the function. I am having a gap I guess....

Hi Thom, In SSRS,  for calculating the Date Math, how could we express in a single field?

Hi Thanks for the reply. Are you referring that I should use above query mentioned by you in one data set? Or combined with the original data (select * from...

Table Definition:

Create Table ByDeptByMonth(ForMonthOf date,Department nvarchar(50),TheMonth date,NoOfCases int,Sub1 decimal(6,2),Sub2 decimal(6,2),Sub3 decimal(6,2),Sub4 decimal(6,2),Sub5 decimal(6,2),Sub6 decimal(6,2))
And Insert Statements:

Insert into ByDeptByMonth Values(GETDATE(),'IT','2016-01-01',1,100,0.44,0.71,1.15,0,0)
Insert into ByDeptByMonth Values(GETDATE(),'IT','2016-02-01',1,100,0.44,0.71,1.15,0,0)
Insert into ByDeptByMonth Values(GETDATE(),'IT','2016-03-01',1,100,0.44,0.71,1.15,0,0)
Insert into ByDeptByMonth Values(GETDATE(),'IT','2016-04-01',1,100,0.44,0.71,1.15,0,0)
Insert into ByDeptByMonth...

Thanks I get it.
Declare @filter date = GETDATE()select TheMonth from DataRangewhere TheMonth<=dateadd(year,-1,GETDATE()) and TheMonth>dateadd(year,-2,GETDATE())

I see... I didn't it was sorted alphabetically in my query.

I am trying to get like following: 

I have solved it out. I just copy the tablix the underneath the 1st one and gave each tablix name(page name) in the properties , and then with the use...

In my report, I don't want Report Header mainly because, it is repeating for the consecutive pages, even if I try to hide, the reserved white space still exist in...