SSRS

SSRS error occurred during local report processing

When running an SSRS report, the following SSRS error may be encountered: An error occurred during local report processing. Error in the application. Could not find the file”. Followed by the path to the SSRS file. In fact, the missing file is a file with an RSD extension and not an RDS (Report Data Source) file. RDL reports use Report Data Source (RDS) files.

SSRS

Dynamic SQL query with SSRS

How do I create a dynamic SQL query with SSRS, in datasets ? With Reporting Services, the fields used in a table object for example are linked to the database. This is done through a dataset which is itself the result of an SQL query. This dataset is linked to a data source. In fact, this data source contains a connection. For example to