When try to export the report from the server i get this error
:'An error has occurred while processing Table 'table1
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not
found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote
The problem when i set the connection string from code its working but the data source can not read the connection string from app.config with the same connection, There any permission or setting to set on the server to access app.confg by report dll???
Note: in my local it working without any problem, also i using asp.net core and the report access the connection from app.config
So if the answer check the connection string its working all not the connection same the application and the application working with the same connection.
I think the problem the report dll can not reach to app.config.