January 27, 2011 at 3:06 pm
Ok, here's the basic idea: I have a table that we post all time for work performed. eac row in the db is a seperate entry against the same order. I can show how many total hours were posted to the order and the number of hours a particular individual posted as a subset of that. What I need to do is be able to run this for several hundred employees at once and do this so that each amnager can see what his employee charged, so the same order will come up on this report time and again and I have to show the toal hours each time as well as the time that particular emplyee posted. Any ideas?
January 28, 2011 at 7:18 am
I would probably create a cte or temp table or table variable that summed the work order total hours in a column next to each employee's hours for that work order.
Then take that table and group it by manager in the report with a sum of the employee hours for a particular work order and an average of the total work order hours.
Hope this makes sense.
January 28, 2011 at 8:58 am
I have never created a temp table. That would solve the problem. I could create a temp table with the total hours for the ordes and tie that table to the "live" table and grab the fields I need that way. I'll see what I can find on creating a temp table.
January 28, 2011 at 12:29 pm
Ok, I figured out how to build the temp table and get the results I want. The problem I see now is that when I go to layout the report, the fields from the temp table aren't visible. Any ideas why?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply