One of the things that comes up again and again is having the ability to run reports against SharePoint Lists. You create the report like you would any other using Visual Studio and deploy it to your sever.
You set the report to run against a list and as a specific user.
Click on the down arrow and selecting the “Manage option”
In the DataSource Tab ensure you are using a custom data source selected with the details set such as URL and Username and Password.
Click “Test Connection” and it will confirm that everything is working correctly
