SSRS Item not linked to dataset, and “table1”

If we have more then one dataset in our report, or add more dataset in a report, we get this type of error message. To solve it :

If its a table, List, or Matrix  : Right click the object (make sure the whole object is selected and click properties. if  properties slides out Scroll down to “Dataset Name”, there should be a drop down which all the datasets in your report. Select the one you are grabbing you attributes from.

IF the properties box opens up for the table/matrix/list , then you should see (3 textboxes down) “Dataset Name”. if its empty or has something in it…i would click the dropdown anyways, and make sure the right dataset it selected.

 

Suggested solution from: http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/50ac2c34-b059-4f03-8962-9e423ba10260

Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s