FluentPro Help Center

What do you need help with?

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

    Back To Top