Home Forums Reporting Services Reporting Services Linked Report per country in own folder for security works but subscription capability bypasses that RE: Linked Report per country in own folder for security works but subscription capability bypasses that

  • February 9, 2016 at 11:01 am

    #1857461

    Bit of a tricky one. An idea might be to use the ReportFolder global as the parameter value to determine the country it is running for from the folder path. You can then set your parameter to Internal and then it cannot be accessed from the subscription or via URL access.

    This way the location of the linked report will determine to parameter value and you wont need a security list.

    N.b. Tried this after I wrote it. The gotcha is that Globals!ReportFolder is empty when running the report in BIDS. You can hardcode a default or set the parameter to allow nulls while working on it.