• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 32 views
  • Users 0 members are here
Related

Finding Tess User running report in SQL

Brian Ramos
$organization

We are trying to filter an SSRS report in the same way My Portfolio filters Plans. We only want to see the information for those constituents where the person logged in to Tess is the worker with the portfolio checkbox checked. The problem is we can't figure out how to get the report to know who is logged into Tess. Any suggestions as to how we can get this information? Thanks!

  • $organization
    As part of the SSRS report, there are security parameters and a security subreport that is used. This way, control groups will be honored through the report selection. Examples of the use of this can be extracted directly from the standard reports folders in the SSRS report server. One of the security parameters is the passing of the userid for Tessitura


    [edited by: Troy Nelson at 1:55 PM (GMT -6) on 25 Jul 2014]