ReportServer Forum

japettyjohn

Member

Registered: 2014-02-11

Dynamic reports by user

I want to have a few hundred users who see the same reports, but the data which is pulled by the user is constrained by their login/role.

Ideally I don't make a new report for every login/role, is there an easy way to do this?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Dynamic reports by user

Hi John,

for this use case ReportServer has the concept of user variables, which are assigned to users (or organisational units) in within the user management tree and which
can then be used as a parameter in reports.

Cheers
Arno