Malik Kattubadi
Malik Kattubadi

Reputation: 11

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.

Upvotes: 1

Views: 168

Answers (1)

scratt
scratt

Reputation: 190

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.

Upvotes: 0

Related Questions