SQL Azure Reporting Services

Windows Azure SQL Reporting is a cloud-based reporting service for the Windows Azure Platform built on SQL Server Reporting Services technologies.

SQL Reporting service is available to current subscribers, but should not be used for new software development projects. The service will be discontinued on October 31, 2014.

An alternative to SQL Reporting is to use one or more instances of SQL Server Reporting Services (SSRS) running on Windows Azure Virtual Machines (VM).

A known issue of SQL Reporting is that report execution is slower than SSRS running on premises. In contrast, performance of SSRS on a VM is similar to the performance you might expect from an on-premises SSRS instance.

Transition from SQL Reporting to SQL VM provides the following advantages:

• Extensible report server for customized reporting
• Scheduled report execution and delivery
• Integration with hybrid solutions
• Faster Performance

The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.

You may get the above error when trying to view a RDLC report using with the VS 2005 or VS 2008 viewer controls with 2008 schema.

When using local mode, you are using the same report processing engine that was shipped with SQL Server 2005. This engine does not understand the new report definition schema and attempting to load a report created with one of the new SQL Server 2008 authoring tools will result in this error.

Open the RDLC in VS2010 and use the v10 of the report viewer control to run the report.

RDL and RDLC

RDL - RDL stands for Report Definition Language

RDLC - Report Definition Language Client-side processing

RDL files are created by the SQL Server 2008 version of Report Designer. RDLC files are created by the Visual Studio 2008 version of Report Designer.

RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2008 version of Report Designer. (You have to rename .rdlc to .rdl first.)

SQL Server Reporting Services Error

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help
Bad Data. (Exception from HRESULT: 0x80090005)

Solution

Possible reasons would be either the account for running the SSRS 2008 has been changed or port number has been changed. To fix the above error,

a) Logon to the Reporting Services Configuration Manager.
b) Make a note of the settings in all the sections.
c) Click the Encryption Keys section.
d) Click the "Delete" button to delete encrypted content.
e) Check whether all the settings in all the sections are intact and also make necessary changes.
f) Click the "Change" button to replace the encrypted content with the updated changes.

How to create a hyperlink in Reporting Services that opens in a new window

When designing the report:

• Open up a text box properties window
• Go to Navigation
• Enable Jump to URL

In the URL enter javascript:void(window.open( 'http://www.microsoft.com', '_blank')
Please note that you should replace the http://www.microsoft.com/ with the URL you would like to launch. Also note, that the second parameter of '_blank' is the standard window.open target meaning a new window.

Note: To make this to work in SQL Reporting services 2000 (especially opening in a new window) you need to install Hotfix for SQL Server 2000 Reporting Services SP2 and make sure you already have installed Reporting Services SP2, The hot fix setup will not run on computer unless you have SP2 Installed on your computer.

http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en