you cant do it within reporting services. There are some tricks out there to simulate it with sub reports but it best handled on the sql side. This...

this is a pretty easy one, create a data source that filters based on the System_User function in sql. This will require you to use windows authentication.

then all...

=DateAdd(”D”, -1, Today())

does this need to be within the datasource or as a parameter for the report?

I dont have RS 2008 but in 2005 the URL field can be an expression, just parse out the URL with string functions.

you need to have a builtin/administrator login and give you access.

SELECT ...

im not sure about the error your getting but it sounds like it might be a permissions issue.

have you tried typing out the direct link to your report?

here is an...

control panel should work. Did it ask you to reboot...

Select newid()