I am new to Visual Studio 2010 C#. I'm creating an web application with crystal report. I want to create individual production report and consolidated report from sql table.
I have have a two tables i.e.
Employee Master (EmpID, EmpName)
I want a result like
EmpId, EmpName, #JobsDone, #JobsQcDone
#JobsDone - Need to count # of jobs done in column
#JobsQcDone - Need to count # of qcjobs done in column
Please help me to get solution for my situation.
Thanks in advance.