HI.. RRS feed

  • Question

  • Hi,

    I want to create a database connection in project server, so how can i fetch the values from database and want to show on frontend.

    Monday, January 23, 2012 11:34 AM

All replies

  • If you want to display in Project Server , you can query reporting database(ProjectServer_Reporting) using usercontrol or custom web part like normal application. Same you can do for external applications. 
    Thanks, Arun
    Monday, January 23, 2012 12:07 PM
  • Use SQL Server Reporting services to connect to database and to create a report.


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011
    Monday, January 23, 2012 1:45 PM
  • Vivaan,

    It will depend on where you want to create the connection from, and where you want to display the output.

    In addition to answers below, you can also use Excel, Access etc., tools that can connect to external sources.


    Prasanna Adavi, PMP, MCTS
    Monday, January 23, 2012 3:04 PM
  • Hi prasanna,

    Thanks for reply..

    Actually i want to display the output on my pwa (EPT).Its not a report it is basically my project that i create by the help of EPT from project center(in ept i have associate the pdp and in pdp i have use some custom fields).So when i create a new project by EPT, it automatically  generate a ID(Auto increment ID) and this ID saved in database(SQL).Now simply i want to fetch this id from database and want to show this in Frontend..

    Tuesday, January 24, 2012 6:17 AM
  • Hi Vivaan,

    If you have ID field which is project level custom field, You can follow the steps:
    1. PWA> Server settings> Click on Manage Views
    2. GO to project center views & clikc on it
    3. Add the ID field in view.

    If the ID which is generated is not the Custom field & stored in some other database ,You will need to have SSRS report similar to the view which you see in project center, You can pull the ID but in this case, You wont see the Gantt Chart.

    IF you can create a project level number field (ID) & get it populated by your logic, first three steps will be easy for you.

    Hope that helps.

    Thanks, Amit Khare |EPM Consultant| Blog:
    Tuesday, January 24, 2012 8:59 AM