Status Reports in Project Web Access 2007

E

EPMLearner

Hi,

Where is the data for Status Reports stored? Also, how many characters are
permitted in the Status Reports fields (over 255 characters - without
truncating?)
 
G

Gary Chefetz

Instead of answering your question, I'm going to suggest that you seize the
opportunity of moving to 2007 as a time to drop the usage of Status Reports
in Project Server.
 
R

Ray McCoppin

The Status reports are stored in the Published Database in the following
tables:
MSP_SR_DEFAULT_SECTIONS
MSP_SR_DISTRIBUTION
MSP_SR_FREQUENCIES
MSP_SR_REPORTS
MSP_SR_REQUESTS
MSP_SR_RESPONSES
MSP_SR_SECTIONS

Each section of the report is store as a SQL NText field Variable-length
Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.

I think something else would be the limiting factor (web page code) not the
SQL database.


Hope this helps.
--
Ray McCoppin

http://www.randsmanagement.com
Custom SSRS reports for Project Server 2007
SRS gantt charts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Reports 0
Transfer ownership of Status Reports 1
How to configure home page to show upcoming status reports? 0
Get Project Indicators by Status Date 1
status reports customization? 1
Project Server 2007 Status Reports 0
overdue status reports problems 0

Top