SSRS Drill down report not using same credentials as parent report

155 Views Asked by At

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.

1

There are 1 best solutions below

1
On

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.