Showing posts with label SSRS 2005. Show all posts
Showing posts with label SSRS 2005. Show all posts

Error Message: [rsInvalidDataSetName] The table ‘table1’ refers to an invalid DataSetName...

In SQL Server Reporting Services 2005, when you changed a dataset name or try to point to another dataset name, this error message is often generated as a result. That is right, you have referred to wrong dataset. The problem is it is hard to find where you can change this reference.

First, you need to remember your report may consist of several tables. Each of them usually refers to a different dataset. So, you need to click the table which does cause the trouble, then in Properties panel located at bottom right corner of your screen, to select that table, which is located right below caption “Properties”. In Data section, there is DataSetName. Select what you want.

Newline and Tab in Text Fields in SSRS 2005

Both Newline (by press Enter in keyboard) and Tab does not work in either textbox or text fields in SQL Server Reporting Services 2005, despite it looks you can set this in Tools->Options->Text Editor->Basic->Tabs. There is no such problem in SSRS 2008.

Ctri+Shit+Enter will enable to insert Newline. It appears no fix for Tab. Someone suggested using multiple textboxes or table to arrange the indenting.

Error Message: The report definition is not valid. Details: The report definition has an invalid target namespace

Full error message is: 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.

According to Microsoft, one "cannot publish a report defined in the SSRS 2008 RDL schema to a SSRS 2005 report server." It is true. In one case, it happened when report was defined in Microsoft Visual Studio 2008 (SQL Server Business Intelligence Development Studio) and the SSRS is 2005.

The easiest possible solution is to install Microsoft Visual Studio 2005, because both 2005 and 2008 can co-exist in one machine.


http://connect.microsoft.com/VisualStudio/feedback/details/361103/reporting-services-report-cant-deploy-to-sql-2005

Labels