This article is step by step guide how to populate PDF forms with data form External list. For the purpose of this guide, we have prepared the following External Content Type: (Click on the image to view it in full size) Assuming “ADDRESS” field is unique, we can identify an External list item through that field. Step 1. Prepare template with custom server “Form Load” action. Add the following script to a “Form...

To summarize we successfully implemented a row-level security in SQL database and integrated all pieces together. The point is that while SharePoint 2010 Business Connectivity Service has limitations, it does not mean your implementation should be limited. By understanding surrounding technologies like SQL Server, PDF SharePoint you can achieve item level security and display external data in the PDF document.