I have written many SSRS reports, but am not that familar with deploying them or report models.
Basically, I am maintaining some reports that use report models. The server and database changed. I went into the project with the datasource and model and updated the server/database in the data source and deployed the datasource and the model. The reports still don't work. The error (in Report Manager) is:
"Cannot create a connection to data source 'dataSource1'". I get the same error when opening the report project and trying to refresh the report.
What confuses me is in the report itself, the datasource has "Report Server Model" selected, but has a long semantic query that doesn't point to the model (that I can tell).
The report has the report model selected in report manager as the data source.
i am new for ssrs reports.i need some clarifications on ssrs.
we have one client he want's to display sales report by customer wise using different databases.for example he is maintaining every year databases seperatly in single server.so he need to display in single report.how can i display in single report.could you please any one explain clearly how to do that.