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.