I added custom enterprise fields to a timesheet view. Where is the data in
these fields stored in the reporting database?
We have done a custom report (EPM 2007) that shows timesheet data and
custom fields values entered at project, resource and task level.
We created a SQL stored procedure, that creates a CSV file, with
joints between timesheets lines and projects, task and resource
tables, through the assignments table (on reporting DB).
Just a warning on an issue we are currently fixing; in some cases, the
sync with publish and reporting can fail; perhaps it's better to
gather data from publish DB...
Regards
Jeff