external access

Hi evebody,

I′m making some reports on VS 2003, using RS 2000 and deploying it to a RS 2005 server

my problem is: is there any way to make a default user for accessing these reports, cause my reports can be seen by those who I grant permission (user from my domain)

I found the "execution account", but I couldn′t understand how I would use it, if this helps on my problem at all..and if I can use it with RS 2000 reports. (I know that some features of RS 2005 cannot be used on RS 2000 reports...)

Best Regards.

Pedro

Hi everybody!!

I′ve been reading some stuff, and I believe I can explain much better my problem.

I have a system that will be accessed on extranet. Users from extranet will be authenticated by an AD.

These users all have authorization to access my systems reports.

I′ve been reading the reporting services extension, and I discovered that I can use the IAuthorization Interface.

In this case I would implement the checkAccess method, checking if the users ID is in my AD and grant permission to requested report.

is my idea right?

Best regards,

Pedro

sql

Expression as a default value problem..

I want to automatically run a report every day of the week. This isn't a problem. However I want the users to be able to run the
report whenever they feel like too. Can I put expressions in the default value entry? They don't seem to generate anything...
Here is the value I want to put in..
=CDate(IIF(datepart("w", Today) = 2, dateadd("d", -2, Today), dateadd("d", -1, Today)).ToString)
Can anyone see anything wrong with this?
Thanks
ScottWhere are you settting this expression? This should work if you pull up
Report Parameters dialog in report designer, enter this expression in
Default -> Non-queried textbox, and preview it (I just tried it to confirm.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:u1j3alvWEHA.1888@.TK2MSFTNGP11.phx.gbl...
> I want to automatically run a report every day of the week. This isn't a
problem. However I want the users to be able to run the
> report whenever they feel like too. Can I put expressions in the default
value entry? They don't seem to generate anything...
> Here is the value I want to put in..
> =CDate(IIF(datepart("w", Today) = 2, dateadd("d", -2, Today),
dateadd("d", -1, Today)).ToString)
> Can anyone see anything wrong with this?
> Thanks
> Scott
>