I'm using this sql statement to produce the desired result. And would like to display those result query in my report in C# using rdlc via Dataset(.xsd).
Select pay.Cutoff, emp.Id, emp.LastName, emp.FirstName, emp.MiddleName, emp.TinNumber,
job.Rate * 25 AS FixBIR,
(SELECT COUNT(*) AS MonthsWorked
from payroll AS pay3
WHERE YEAR(pay3.DateGenerated) = 2014 and pay3.EmployeeId = 1 AND pay3.Cutoff = 1
ORDER BY MONTH(pay3.DateGenerated) ASC) * (job.Rate * 25) AS MonthsWorked_FixBIR_TODATE,
pay.TaxWithheld,
(SELECT SUM(payroll2.TaxWithheld) AS TaxTotal
FROM employee AS employee2 INNER JOIN
payroll AS payroll2 ON employee2.Id = payroll2.EmployeeId
WHERE (payroll2.Cutoff = 1) AND (employee2.Id = emp.Id) AND YEAR(payroll2.DateGenerated) = 2014) AS Tax_TODATE,
YEAR(pay.DateGenerated) AS YEAR
FROM employee AS emp INNER JOIN
payroll AS pay ON e ...
Go to the complete details ...