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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 snapshot and parameter

Author  Topic 

roy mm
Yak Posting Veteran

62 Posts

Posted - 2008-07-08 : 07:00:53
Hello.
I have a report with lots of parameters and all of them have default value.
One of the parameters use a defualt value of "User!UserID".

I want to save history of the report but When I try to create a snapshot I get the error
"The defaultValue expression for the report parameter 'parm1' has a user profile dependency".

Is there a way to handle this?
maybe to catch the user that run the snapshot (I guess its the sql service) and handle this?

Thanks.
   

- Advertisement -