Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2008-07-15 : 01:29:25
|
| 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. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-15 : 19:26:31
|
| Maybe you need to setup a dummy user eg SystemProcessUser, and default this parameter to this dummy user SystemProcessUser |
 |
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-07-16 : 01:07:38
|
| Hi dexter.I solved it for now by removing the userID from the parameters and leave it only in a table filter. Now it wotks fine.BUT - your idea of creating a dummy user also sound like a good solution for some situation.Thanks! |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-16 : 01:12:14
|
| Hi Roy, Thanks for the feedback.Cheers, Dexter |
|
|
|
|
|
|
snapShot with userID