SSRS Dynamic Data Source

Saikat Malakar

Oct 11 2012 2:22 AM

2.7k

Dear Sir/Madam,
I would like to inform you that i am a very new user to SSRS. I learn the basic things and able to make the reports. I am using VS 2008 and BIDS. But i can't move further. I want to use the dynamic data source. Let me clear my issue one by one.

1. First of all user should input four credential a)Server name b) database name c) user id 4) password. It will help to make the connection with database and make the data source. The credential should be store in session or cookie.

2. Now the user will be able to see all the reports without giving the credential because he/she already given.

I made a dynamic data source but the credential is asked for every time when i open a report.

It will be highly obliged if you kindly solve my issue and give me the solution as soon as possible. It will be highly appreciated if you guide me through a demo project or an article.