sql server reporting services:
You can used linked reports. You would need to set the parameter for
each office (to limit the data), then grant permission on the report
only to that bunch of office users. Then when they run the report,
they will see only their data.
The only problem is that if you update the original report, you have to
remember to go and update the linked reports (unless this has changed
since I last used that functionality)
regards
Weelin
[quoted text, click to view] On Oct 19, 4:18 pm, "Tim Kelley" <tkel...@company.com> wrote:
> I have a report that can be run by different offices in our company. The
> report should only report on data belonging to that office. Currently I
> have a parameter setup and when the report is run, the user picks the
> office. I would like to limit the report to only show info for the office
> that is running the report without the user picking the office location (I
> don't want users running the report for any other office's). I can do this
> if I create a url and include the office parameter, but there are other
> reports the office's run and I would like to be consistant in the way the
> reports are accessed (I would like to continue using the Report Manager).
> Is this possible?
>
> Tim
If all you had was the user's login name, via database queries, would
you be able to determine what office they were in?
If so, you can create another dataset where it retrieves what office
they are in based off of "User!UserID". You can then make the office
parameter hidden with the default value based off this new dataset.
This way you still only have one report, and the users can only see
their office (since they have no way of changing it).
Devin
I have a report that can be run by different offices in our company. The
report should only report on data belonging to that office. Currently I
have a parameter setup and when the report is run, the user picks the
office. I would like to limit the report to only show info for the office
that is running the report without the user picking the office location (I
don't want users running the report for any other office's). I can do this
if I create a url and include the office parameter, but there are other
reports the office's run and I would like to be consistant in the way the
reports are accessed (I would like to continue using the Report Manager).
Is this possible?
Tim
