SSRS: regional settings

When you have a website which display’s a SQL Server Reporting (SSRS) Report, you might run into  the problem that your date fields are in the format of: MM-DD-YYYY, but you want it to be DD-MM-YYYY (for me that is the dutch setting).

You can change this by changing the locale setting of APS in IIS7. Here is how:

ASP Feature setting

 

View Permissions for Reporting Services in SharePoint Integrated Mode

Setting up security for SSRS in SharePoint integrated mode can be a bit tricky, particularly if you want to set up some of your users to only be able to run reports, but not to be able to modify or change them. I found a great post explaining how to create a Reporting group in SharePoint:

http://agilebi.com/cs/blogs/jwelch/archive/2009/07/10/view-permissions-for-reporting-services-in-sharepoint-integrated-mode.aspx