This discussion is archived
3 Replies Latest reply: Mar 4, 2009 3:08 PM by 690399 RSS

Using Crystal Reports & P6

690399 Newbie
Currently Being Moderated
Anyone had much luck utilizing Crystal Reports with data
exported from P6? When using Crystal what is the best
format for exporting purposes?
<br
/>
thanks,
  • 1. Using Crystal Reports & P6
    690399 Newbie
    Currently Being Moderated
    My information is that the native P6 database is
    difficult to mine because there are fields in the user
    interface that are not available in the database. For
    example, a date field may be displayed in the user
    interface in date format. In the database, it may be a
    calculation of something such as start date and
    duration.

    We are installing the
    P6 data warehouse as I write. The specs for the
    warehouse are available in POINT. We want to make it
    as easy as possible to use products like Crystal to
    mine the P6 data.
  • 2. Using Crystal Reports & P6
    690399 Newbie
    Currently Being Moderated
    I've had good luck using SQL Reporting Services to
    "mine" data and build custom reports based on P6 data.
    Building the query may take some time, but all the
    information is there... The database schema is readily
    available on POINT - this is a good place to start
    learning where / how the program structures data.


  • 3. Using Crystal Reports & P6
    690399 Newbie
    Currently Being Moderated
    Please see 2002118122316 in our knowledgebase for
    further information on "Using Crystal Reports with
    Primavera SDK"

    If you have
    any additional questions on need further clarification
    please contact support at
    http://primavera.com/customer/support.asp <br
    />
    Saryn