External Content Types with SSRS RRS feed

  • Question

  • Hi,

    Can I use External Content Types (via External Lists) in an SSRS report? I was thinking of using a SharePoint List Connection Type (ref: http://technet.microsoft.com/en-us/library/ee633650.aspx).

    My primary goal is to limit access to data in an application database - a user should only see data for their own office. I was planning to use web service in my external content type to check whether the user has access to the data, based on membership to a SharePoint group such as "Office 1 Employees".

    Should I be looking at: XML data source, Web service connection types instead?

    Thank you


    Thursday, November 14, 2013 10:02 PM