Actuate vs Reporting Services

We are currently using Actuate as our Web-based reporting solution, but have
been evaluating RS as an alternative. There are at least 2 issues
(currently!) that I can't duplicate with RS.
1. Page-level security. Actuate provides what they call 'Page-level'
security. Basically, I produce a 1000 page report, and PLS allows many users
to view only the pages that they have privileges for. It looks like the only
workaround in RS is to produce multiple reports and then hyperlink them. I
believe the roles in RS allow security at only a report item level. Is this
correct or am I missing something? Any other ideas for a workaround?
2. Search function. Actuate provides a search function within the report.
You can click on a field, and search for those that meet your criteria. It
provides a list of values that you can then hyperlink to. You can also
output the selected values to CSV or RTF. Anything similar in RS?
Thanks for your time.As far as #1 you can use the global variable user!userid to either filter or
have it as a parameter into your query (note that you will need to most
likely strip off the domain, this is in the format of domain\userid).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:CB33B446-7E2F-45C6-8A2F-6C6CD7671E02@.microsoft.com...
> We are currently using Actuate as our Web-based reporting solution, but
have
> been evaluating RS as an alternative. There are at least 2 issues
> (currently!) that I can't duplicate with RS.
> 1. Page-level security. Actuate provides what they call 'Page-level'
> security. Basically, I produce a 1000 page report, and PLS allows many
users
> to view only the pages that they have privileges for. It looks like the
only
> workaround in RS is to produce multiple reports and then hyperlink them.
I
> believe the roles in RS allow security at only a report item level. Is
this
> correct or am I missing something? Any other ideas for a workaround?
> 2. Search function. Actuate provides a search function within the
report.
> You can click on a field, and search for those that meet your criteria.
It
> provides a list of values that you can then hyperlink to. You can also
> output the selected values to CSV or RTF. Anything similar in RS?
> Thanks for your time.
>