FluentPro Help Center

What do you need help with?

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.


    SQL Datasource

    Autocomplete Manager can pick data from SQL Server datasource (you can write any query).
    To configure this mode:
    1. Enable Autocomplete for this field.
    2. Select “SQL Query” as data source. 

    In Project Server 2010 In Project Server 2013

    3. Write connection string as follows:
    Server=w2008r2ps;Database=ProjectServer_demo_reporting;Trusted_Connection=True 
    Instead of trusted connection, you can embed credentials, but it is not very secure.
    You can use Test button to verify connection.

    4. Write SQL Query statement:
    Select projectname from MSP_EpmProject_UserView where (EnterpriseProjectTypeUID is not null)
    You can write any query as long it is returning single value.
    You can use Test button to verify your query.

    In Project Server 2010 In Project Server 2013

    5. Click Save - field configuration is completed.
    6. Save edits to PDP.

    Was this article helpful?

    Table of contents

      Still can't find what you're looking for?

      Contact Support
      Back To Top