Primavera SDK with Crystal Reports 8.5
In the Open Standard
Forum GuestMember for 17 years 8 months
- Created
- 2
- 3
0
Hi everybody,
I am writing reports with Crystal and querrying my information via PrimaveraSDK form an Oracle 8.1.7 DB. I am trying to list the names of all WBSs. When I list all data in PROJWBS.wbs_name, I get the list of all the Project names instead of the WBS names. Am I searching the correct table/field? If I use Teamplay PMs Report Wizard, I get the list that I am looking for.
Thank you in advance for your help.
-Nick the Intern
I am writing reports with Crystal and querrying my information via PrimaveraSDK form an Oracle 8.1.7 DB. I am trying to list the names of all WBSs. When I list all data in PROJWBS.wbs_name, I get the list of all the Project names instead of the WBS names. Am I searching the correct table/field? If I use Teamplay PMs Report Wizard, I get the list that I am looking for.
Thank you in advance for your help.
-Nick the Intern
2 replies
Oldest first- 0Kevin Button ·Nick
To see more than Project level information you need to do 2 update queries. First, set the access_level in the PROJECT table to 1, then set the scope_level in the PROJECT table to 7. You should now be able to see everything. You can also set these access and scope levels for individual projects by adding the correct condition in the above queries.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?