snapShot with userID

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nicknack - 15 Jul 2008 06:25 GMT

Hello.

I have a report with parameter that depend on another parameter that
take the value of the current user (=User!UserId).

The report run fine until I'm trying to make a snapshot of the report.
I then get the error:
"The defaultValue expression for the report parameter 'user_alias' has
a user profile dependency. (rsRuntimeUserProfileDependency)".

I didn't find any help onLine. Can anybody help with this issue?

Thanks in advance,
Roy.

Reply to this Message

Bruce L-C [MVP] - 15 Jul 2008 14:44 GMT

This is by design. The is issue is who is the user when the snapshot is
created? Here is a paragraph from books on-line:
"Snapshots can be created manually or at scheduled intervals for any report
that can run unattended. To run unattended, the report must use stored
credentials or no credentials at all. Furthermore, if the report uses
parameters, you must specify default values to use when the report runs. You
can specify stored credentials and parameter values in the property pages
for the report."

Note how it says stored credentials or no credentials at all. This is for
the same reason your report is failing. The snapshot is not based on a user.

Now, if you want you could make it optional and then use User!UserID to
filter the report.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hello.
>
[quoted text clipped - 10 lines]
> Thanks in advance,
> Roy.

Reply to this Message

nicknack - 16 Jul 2008 05:52 GMT

Hi Bruce,
Thanks for the replay.
I did moved the userId to the table filter and its look to work fine.

Thanks.

On 15 יולי, 15:44, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com>
wrote:

> This is by design. The is issue is who is the user when the snapshot is
> created? Here is a paragraph from books on-line:
[quoted text clipped - 29 lines]
> > Thanks in advance,
> > Roy.

Reply to this Message