The Tablix is invalid Dataset property is missing or Table without Dataset in SSRS Report

The Tablix is invalid Dataset property is missing or Table without Dataset in SSRS Report

Today while creating a report i have requirement where i have to show some hardcoded values below the reports instead of writing separetely in each textboxes, i prefered table i dropped a table below my report data and copied all hardcoded data in the rows and columns as specified, when i preiview the report.

Report was throwing error.

The tablix 'Tablix2' is invalid. The value for the DataSetName property is missing

The reason was a table or tablix is always associated with a dataset but i was not using any dataset values i was directly hardcoding the values in the table rows and column.

So,Below is the Fix

Select  your newely created table 

Properties window-
General-Datasetname -which is blank change it to your report dataset Name.

or
Right click table-Tablix Properties-Select your Report datasetName.

Preview the Report the report will work without any issue.

Note:You can achieve the same thing by dropping textboxes in your report and copy hardcoded values in the textboxes but i believe it's quite time consuming as you have to drop multiple textboxes in the report then you have to aligned them properly.