Standard Reporting Question

[RandyK]

Quick question about MSPS reporting... Can reports be created (either
internally with the OLAP cube or externally using SQLReporting, Crystal
reports, etc...) against summary tasks? If not, what are the options?

 

[JimB]

Hi Randy,
If I understand your question correctly, yes, you can create reports using
Crystal Reports and report on summary tasks. I use Crystal for this task. I
have created a high level report showing project name, status, PM, etc and
the section beneath it reports on the summary tasks.

The table that I use is '{MSP_VIEW_PROJ_TASKS_STD.TaskOutlineLevel}' and you
can choose what level you want to drill down to. You can make it equal to
2.00 or 3.00 depending on the detail that you need. Hope that helps.

 

[RandyK]

Thanks Jim - I'll give it a try! Have a good weekend! RK

 

[RandyK]

Jim - A quick follow-up question. Do (or can) you use the same method for
reporting against custom created enterprise task codes? I know these task
codes do not make it into the OLPA cube - but can they be mined and reported
on using Crystal (or SQL Reports)?

I am trying to set up a system that allows an outside chargeback application
to process chargebacks based on task type (each task type has a different
hourly rate applied). My thoughts are if I can apply a task type code, then
the Chargeback application can "dip" in and mine the data.

Feel free to email me at "(e-mail address removed)". I appreciate the assist!

Thanks,
Randy

 

[JimB]

Hi Randy,
Sorry for the late response. I can't see why you couldn't pull the data
from a custom table. To mine the data from your table, just know where it is
through Crystal Reports and then drag and drop the fields to your report.

The only thing you will probably need to setup is a hook or link on the
tables. Such as by project name, project id or task name so it can reference
it. Beyond that I would need to understand your report a little closer.