Click here to Skip to main content
15,746,420 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
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.

What I have tried:

I tried all authentication types SSPI,True and False. Yet no use. I tried storing run time login userid and password in parameters yet no use.
Gerry Schmitz 8-Aug-18 22:57pm    
You're asking to "prompt user for a name and password"; why is it a surprise that you must now "login"?

Isn't the "Report Server" intended for sharing / distributing reports?
malikkattubadi 5-Sep-18 16:42pm    
it is asking for login credentials for each report.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900