SSRS Drill down report not using same credentials as parent report

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP



SSRS Drill down report not using same credentials as parent report



I have created a drill down SSRS report where I have put text boxes and 5 sub reports and one as main report.For main report datasource I have selected "Display the following text to prompt user for a user name and password:" and have checked "Use as Windows credentials when connecting to the data source" box. But the problem is I have to login every time I click on each tab and go to next sub report. Please let me know if anyone has a solution.





Can you try to add more detail to your question, such as pictures of the subreports, so we can see what your setup looks like? Screenshots of the datasources of each report may help.
– scratt
Sep 13 at 2:46




1 Answer
1



According to MSDN, you need to make sure the datasource name is exactly the same for all subreports. Then it will only prompt for the main report.





I tried yet it is not working.
– Malik Kattubadi
Sep 5 at 19:22





I have set all the subreports with same datasets and security settings as parent report. Yet it is not working.
– Malik Kattubadi
Sep 10 at 15:46






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Firebase Auth - with Email and Password - Check user already registered

Dynamically update html content plain JS

How to determine optimal route across keyboard