Reporting Services Data For Several Records with Different Reference Points

Question

Reporting Services Data For Several Records with Different Reference Points

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

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.

lwood 45767 Newbie Points: 3 More actions · Answer 2

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.

lwood 45767 Newbie Points: 3 More actions · Answer 3

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?