If you want to use Some data from other server or same server after some ETL work then use SSIS package as DataSource for SSRS report. But the question is how?
Create datasource in SSRS and give the path of Package in Connection string as like
-f Path of package
SQL Server Tips · · · ·
Please share the document/blog/tip link for more details.
Yes, please share the document or blog link for more detailed information