September 24, 2018 at 9:49 am
Hi,
Would it be possible for users to access the SSRS reports web portal by entering in credentials that are stored in a database table? and if so how would I go about doing that?
Thanks 🙂
September 24, 2018 at 10:11 am
Yes,
you can use function in report with parameter @user (its default in ssrs). In database where you have data add mapping data to user and at report visibility set hidden where count = 0.
uUser with count 0 see nothing or eg: "no data found" user with count > 0 see all. But at datasource you must specify user and pass to database.
September 25, 2018 at 5:04 am
krzysztof.ostrowski - Monday, September 24, 2018 10:11 AMYes,
you can use function in report with parameter @user (its default in ssrs). In database where you have data add mapping data to user and at report visibility set hidden where count = 0.
uUser with count 0 see nothing or eg: "no data found" user with count > 0 see all. But at datasource you must specify user and pass to database.
Hi,
Thanks for the reply, is this for specifically viewing a report or just navigating to the SSRS web link? What I am wanting to achieve is when users click on the link for SSRS (which in my case will be something like http://svr023/reports) they will instantly be asked to enter credentials, these credentials are for our case management system and are stored in a table in the database. From there I would like to manage permissions and change what information the reports show depending on who views it (but that is a different problem for another day).
Will this be possible?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply