I'm having trouble with setting the security context for an SSRS report. I have created the SetSecurityContext dataset with the UserGroup parameter. In Report Setup when I try to add the UserGroup as a parameter it says that functionality is deprecated and to just include that as a parameter of the report and it will automatically get passed. When I log into Tessitura with a usergroup other than admin, it lets me select any season even though that group does not have access to all seasons. I have checked "use single transaction" and "multiple result sets." Any ideas?
One other thing that may be affecting this is the connection properties of the datasource. When I use Integrated Security the report cannot make a connection. If I enter sa it connects. From the Custom Reports doc I see that the first dataset's credentials are called for all subsequent datasets. So maybe it is because I am using sa to connect?
Just posting this again because of the forum outage.