Wednesday, February 15, 2012

Emps working Hrs. <CrossTab> ..

hello all

i'm really confused .. i use VS 2005, VB.NET, Crystal Reports and SQL Server Studio Managment as my DB..

My problem is i dont know where do i have to implement this report i want to produce .. its working hours for all employees showing by month ...

ex:

Jan-07 Feb-07 March-07 ......HrsSUM

joe 54 50 88 sum(hrs)

Sam 20 20 50 sum(hrs)

note : it doesnt always starts at jan-07 ... we have a "cut off date" which is the calculations start date till the end of the project (2010)

so its a crosstab query ... should i do that using crystal report , writing a function there to generate the months and create a crosstable ?(no idea how to do that).... or writing a VB code and pass it to the report ?

or just create a stored procedure in the DB to do that ?

i think the last one is wt should do it ... but i still dont know how

any help plz ,,,,,,,,

I would create a query to sum all the hours for each employee by month.

Then use crystal reports to generate the crosstab report and summation.

No comments:

Post a Comment