I recently learned how to build reports in SSRS, and it's been great. I am however having problems figuring out how to let people connect to the report manager without prompting them for credentials (and also not setting the security to anonymous).
I created a report that takes in an employee id as a parameter, and I'd like to make a page in our web app where employees can view their own report. I'm not sure if it's possible to give permissions that will just hyperlilnk to the report manager or if I'll have to use some report viewer control inside of our web app to display the report. Any help would be much appreciated!
SQL Server 2005 Standard + Windows 2003 Server