How to Use an External List

How to Use an External List

You can create a chart, in Chart Plus 3.5 for SharePoint 2010, using data stored in an External List. In order to create an External List, you must first create an External Content Type.

Refer to Microsoft article How to: Create an External Content Type Based on a SQL Server Table for instructions on how to create an External Content Type.

Note: In the Filter Parameters Configuration screen, enter a Filter Limit of 1000 in Default Value. If the Default Value is not set to 1000, the external system may fail to return any data.

hw27-externallist.jpg

After you have created an External Content Type, you can create an External List. Refer to Microsoft article How to: Create External Lists in SharePoint for instructions on how to create an External List.

To create a chart using data stored in an External List, select SharePoint List or Library as your data source and select the external list that you created.

hw27-externallist2.jpg