I know this is repeat question, but I have searched almost all the threads about this and have not found any solution to my problem. Some of threads show a solution like:
&dsu:DataSourceName=username&dsp:DataSourceName=password
But this doesn't work for me. What value should I give for DataSourceName?FolderName/SharedDataSourceName or only SharedDataSourceName? For username and password do I need to provide Windows username and password for where the report server is installed? I tried all possible combinations, but nothing has worked.
I am showing this report using Kendo Window & iFrame controls in an Angular SPA application. iFrame is being passing SSRS URL and showing report.
Firstly why does the dsu: & dsp: method not work for me? And if it's working but not secured as passing username and password then what other approaches are available for URL based reporting service?
解决方案
In the RDL of the report and on your SSRS reports manager you should be able to set a DataSource and authentication type. If you have the RDL looking at a shared DataSource then put the DataSource in the same folder as the RDL and you can click 'Manage' on it and enter the credentials/authentication type you want