Posted on: 10/26/2014 4:32:13 PM | Views : 532

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 ...