Link Primavera & Crystal Report

Hai All

To  link Primavera SdK & Crystal Report  i did the below option

1.File -New - Report Expert -OK

2.Standand-Ok-Database-ODBC-Primavera P6 SDK-Admin-Admin (database Connected)

3.I want to create Tabular & Graphical Report for manpower histogram & S curve (We can create it in Primavera also)

 In Primavera SDK Documentation i saw that we need to Change the access Level to 1 & Scope Level to 7 to extract all data.

I believe that we cannot change the Scope & Access level in Crystal Report .

To change the scope & Access level i connect  Excel & Primavera SDK Through Data-From other Source-Microsoft Query-Select Table - Project-

and i write a query to update the access level to 1  & Scope level to 7 . Query was exceuted successfully.

Then Once again i connect the excel & Primavera SDK & Extract the data,but the scope level & access level is not changed

Anyone say me how to change the access Level , Scope level & extract data in crystal report

Thanks a lot

Regards

Mani