ReportProcessingException: query execution failed for dataset

Epicor ERP 10
, ,
1

I created a report and when I try to preview it the following message is displayed :

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset XXXXX.

I run the query I’m using in the dataset and it works . I used the Query Designer in Dataset Properties and the SQL Server Management Studio. Tested the connections to DataSource and it is created successfully.

It isn’t a permissions problem because I created other reports that run without problems.

Any ideas?

2

Is this using standard Epicor reporting or are you connecting directly to the Database?

3

@Jason_Woods I’m connecting to the database

4

Since you are doing non-standard reporting, we would need a LOT more details to try to help here.

1 Like