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.
Loading
Saikat MalakarPosted Oct 11, 2012, 8:47 AM
Thank you very very much for your reply. I highly appreciated your answer.
I have already done this job. I have learned how to make the report with this wizard. But my query is how to make the data source dynamic that after filling the credential one time, the user can see every report with out giving the credential again.
i created the dynamic data source but in every report its asking for the credential.
Please guide me to solve the issue.
Thanks again.
Akshay PatelPosted Oct 11, 2012, 8:39 AM
http://www.c-sharpcorner.com/UploadFile/db2972/create-ssrs-report-using-report-wizard/