In which table is the EnterpriseProjectText2 field stored?

D

David Martin

Hi all - I have been trying to use Crystal Reports against the SQL database
and have been having some challenges reporting on enterprise fields. Looking
at the tables for the the EntepriseProjectText2 field, I found it in
MSP_View__Proj_Projects_Ent but when I pulled the field into a report, it
does not always contain accurate data. For some records, the contents of the
field are correct but for other records, the data is not correct. When I
create a view in Project Centre, all the correct data is in the Text2 field.
I think I'm pulling the data from the wrong field...one that does not contain
current data...but I'm at a loss.

I also don't have a lot of SQL or database reporting experience.

Thanks in advance for any assistance.

David Martin.
 

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 have two tables on same line? 1
Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Some mail merge fields not pulling into document 2
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Page numbering with Merged Document and IF statements 1
Which DRAFT DB data structure to pull forecast start,forecast finish,and percentcomplete? 1

Top