Security and SSRS

Naomi,

Make sure “Use single transaction” is checked in the general tab of the Data Source properties window under the Data tab.  (It always takes me a minute to find this one).

 -steve

Information Technology Manager

The Granada

(805) 899-3000 x 111 (phone)

(805) 899-3081 (fax)

Howdy Gurus,

I have an SSRS report that has 3 data sets, 1. AP_SET_CONTEXT, 2. dsParameterValues, 3. dsDevelopmentIncome.

The dsDevelopmentIncome is a stored procedure that pulls data from security views where applicable. I have ran the stored procedure executing AP_SET_CONTEXT first and it does pull the correct data for the control group, however when I run the SSRS report it shows data that is outside the security views.

I added a text box field to the report to show me which user group is being applied to ensure my first data set AP_SET_CONTEXT is indeed running and it returns the correct user group.

Any ideas on where else I need to check to find out why SSRS is pulling data outside where it should be?

Many thanks!

Naomi

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Two things to make sure:

1.       For the Datasource (hopefully Shared!), in the Advanced properties window, make sure MultipleActiveResultSets=True.

2.       Make sure Use Single Transaction is checked for each dataset/datasource mapping.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams
Sent: Tuesday, September 28, 2010 1:58 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Security and SSRS

Howdy Gurus,

I have an SSRS report that has 3 data sets, 1. AP_SET_CONTEXT, 2. dsParameterValues, 3. dsDevelopmentIncome.

The dsDevelopmentIncome is a stored procedure that pulls data from security views where applicable. I have ran the stored procedure executing AP_SET_CONTEXT first and it does pull the correct data for the control group, however when I run the SSRS report it shows data that is outside the security views.

I added a text box field to the report to show me which user group is being applied to ensure my first data set AP_SET_CONTEXT is indeed running and it returns the correct user group.

Any ideas on where else I need to check to find out why SSRS is pulling data outside where it should be?

Many thanks!

Naomi

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!