J
John Cello
OK code monkeys, here's one for you. I have written an
application that produces reports for a client on all
their enterprise projects by front ending the SQL
database with Access. One report that this app produces
finds all the enterprise project tasks that a resource is
assigned to. However, as there is no standard in place
regarding a uniform WBS, the report can only grab the
tasks and list them grouped by project.
What the client wants to see is a text report that
emulates the view project returns when you filter by a
resource. In other words, they want to see all the levels
above the particular task.
Currently they get:
Whatever Project Name
17 Develop Training Materials
19 Process Change Training
What they want:
Whatever Project Name
Phase I - Align (Summary)
Common Sales Order Packet (Summary)
Ancillary Forms I: Phone/Calling Card (Summary)
17 Develop Training Materials (Task)
My question is, where can you find the logic that the
filter uses to produce this view?
I've been pounding my head on the desk for days over
this, and may not have explained it well enough. If so,
let me know what I'm missing in the explanation.
Any help would be greatly appreciated.
John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com
application that produces reports for a client on all
their enterprise projects by front ending the SQL
database with Access. One report that this app produces
finds all the enterprise project tasks that a resource is
assigned to. However, as there is no standard in place
regarding a uniform WBS, the report can only grab the
tasks and list them grouped by project.
What the client wants to see is a text report that
emulates the view project returns when you filter by a
resource. In other words, they want to see all the levels
above the particular task.
Currently they get:
Whatever Project Name
17 Develop Training Materials
19 Process Change Training
What they want:
Whatever Project Name
Phase I - Align (Summary)
Common Sales Order Packet (Summary)
Ancillary Forms I: Phone/Calling Card (Summary)
17 Develop Training Materials (Task)
My question is, where can you find the logic that the
filter uses to produce this view?
I've been pounding my head on the desk for days over
this, and may not have explained it well enough. If so,
let me know what I'm missing in the explanation.
Any help would be greatly appreciated.
John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com