Custom SSRS Invalid Object Name

Typically this means that either:

  • the OrderHed{GUID} table isn’t in the SSRS reporting database for whatever reason (there are a number of reasons for this)
    or
    -the datasource for this report isn’t pointing to the same SSRS reporting database as the Epicor base reports.

Regarding the first one. Do you see a table in the SSRS reporting database with that name? You can determine the name of the SSRS reporting database from the Application Server Configuration for the appserver in question within the Epicor Administration Console

Regarding the second one. Confirm that the data source for this custom report is pointed to the SharedReportDataSource under the SSRS root folder(from the above screenshot)/Reports

4 Likes