SSRS

Error during local report processing with SSRS

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 to build a dynamic query in a SSRS report that use an input parameter in a where clause for example? 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