Data driven subscription failing - There is no data for the field at position 2

Hi SivaganeshK,

According to your description, you configured subscription for the report and it worked fine before. After you removed a parameter from the report, the report works fine in report manager, but the error message occurs consistently after the subscription executed successfully.

The error message is usually caused by a missing field in the dataset. It is defined in the dataset, but the query does not return it. It is OK if you don't use the field in your report. But if you do, then you'd get the error or the report fails if it's used in a group/sort/filter expression.

To address this issue, we can click Refresh Fields button or run the query in the dataset properties dialog box, then check whether the field is returned by the query in the fields list.

If the issue still persist in report designer, you can try to recreate the dataset to fix it.

Here is a relevant thread you can reference:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1ae8a0f8-74ac-48de-94a2-64e06b9c46f8/the-data-extension-returned-an-error-during-reading-the-field-there-is-no-data-for-the-field-at?forum=sqlreportingservices

If you have any more questions, please feel free to ask.

Thanks,

Wendy Fu