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