Posts Tagged ‘SSRS’
SQL Reporting Services, SharePoint, FBA = No Subscription Joy?
Get the following error “ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘fba:user@domain.com’ are insufficient for performing this operation.” with a Reporting Services Subscription in Sharepoint / FBA mode?
Read on for the fix.
Puzzling Situations: Using MultiValue Parameters with Stored Procedures in SSRS
Why developers go WTF? with SSRS MultiValue Parameters + SQL Stored Procedures, and how to fix that. A T-SQL Tuesday joint. This months theme: Puzzling Situations.
HOW TO: Force Users To Select a Perspective From a Report Model in Report Builder
In SQL Server 2005 Reporting Services you can Increase your Model reusability and development productivity by creating Perspectives. You then limit the usage of a Model only to those Perspectives, rather than the huge monster views.
FIX: Strange Refresh of Parameters in SQL Reporting Services
Do you get odd parameter and page refreshes in SSRS, even when no dependencies exist? If so, read this article for a quick workaround.
T-SQL Tuesday (Date/Time Tricks) – Project Time Reporting Hack in SSRS
A HOW TO illustrating a method to display project time data in SQL Reporting Services. While there is no native GANTT chart control in SSRS 2005/2008, you can still do this with a little creativity and determination.
HOW TO: Enable SSRS Report Builder to Launch from a SharePoint Site when Using Forms Authentication
When your Reporting Services instance is integrated with a SharePoint product or technology and you use Forms authentication, you might encounter the following error when you launch Report Builder:
“Cannot Start Application. Cannot continue. The application is improperly formatted. Contact the vendor for assistance.”
To workaround this issue, you must exclude the Report Builder files from requiring authentication by updating the Web.config file and enabling anonymous access.
FIX: An unexpected error has occurred, Web Parts Maintenance Page
Fix for the following error:
An unexpected error has occurred.
Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
HOW TO: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode)
Reporting Services provides predefined content types that are used to manage shared data source (.rsds) files, report models (.smdl), and Report Builder report definition (.rdl) files. Adding a Report Builder Report, Report Model, and Report Data Source content type to a library enables the New command so that you can create new documents of that type.
Monitor and Analyze Multiple SSRS Instances with SQLScrubs
The following article details how to analyze and monitor multiple SQL Reporting Services instances with SQLScrubs. SQLScrubs Community Edition is available for free and can be found on CodePlex. All extraction for instance related data is managed by the SSIS package and stored in the datawarehouse provided. You can analyze in your own reports, enhance some of the free reports to do this for you, or simply upgrade to the Premium Edition of SCRUBS for SQL Server 2008 which provides over 15 additional reports with built-in analysis by instance.
Enable SQL Report Builder Anonymous Access for SSRS
Enabling Anonymous Access to Report Builder Application Files
Report Builder uses ClickOnce technology to download and install application files on the client computer. When it starts on the client computer, the ClickOnce application launcher will make a request for additional application files on the report server computer. If the report server is configured for Basic authentication, the ClickOnce application launcher will fail the authentication check because it does not support Basic authentication.
