Reporting Error : The expected parameter has not been supplied for the report When running report from the record

Reporting Error

The expected parameter has not been supplied for the report

When running report form the record

OR

If you want to run your report only on active records or only for the specific condition

If you defined parameters in SSRS reports and using it into the report then you may come across with this error because the dataset doesn’t return any data

Define a parameter which contains the attribute value like statecode for Active inactive records or any other attribute based on your requirement.

Go To Table properties -> Hidden

Check for the condition you want to hide your table.

Go to Record -> Run Report