RS wishlist

Hi,
I would like to add one more item to RS wishlist:
- ability to dynamically switching parameter prompts
Example:
when userid = Person1 then Parameter1 prompt is ON
when userid = Person2 then Parameter1 prompt is OFF
TIA,
KamelThanks, this is on our wishlist as well.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <kwiciak@.gmail.com> wrote in message
news:1114775390.305089.6510@.l41g2000cwc.googlegroups.com...
> Hi,
> I would like to add one more item to RS wishlist:
> - ability to dynamically switching parameter prompts
> Example:
> when userid = Person1 then Parameter1 prompt is ON
> when userid = Person2 then Parameter1 prompt is OFF
> TIA,
> Kamel
>

RS Integration with SharePoint 3.0 - Query with userid parameter

When integrating SQL Reporting Services 2005 with Sharepoint Services 3.0, and you have a SRS report that runs over a view with the UserID as a parameter (to filter the records the user has access to), will the SharePoint ReportViewer passover the UserID to RS and RS to SQL?

Sharepoint security with Reporting Services stops at Item level or does it impersontate down to SQL? Should authenticating be Integrated or SQL ? Should the userid in SQL be exact match with Sharepoint? Or are they mapped somewhere?

Thank You!!

Hi,

actually these are two different questions:

it depends how you implemented the authentication. If reports are called by Sharepoint, it is possible to use the information of the Windows Identity to authenticate against the SQL Server. As you are using a UserId approach and not the actual identity at the SQL Server level you could also use SQL Server authentication to run the query of the report. So the following options could be available:

[Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (SQL Server Authentication with static credentials)

[Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (Windows Authentication)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de