Interactive Sorting/Execution of query

Does clicking interactive sort button in a column reporting services 2005 result re-execution of the query.

Or will it just re-print the rendered data in the layout and so perform better in comparison to the implementation which can be done using drill down to same report with the help of some extra parameters

Priyank

If the user session hasn't expired, interactive sorting doesn't result in re-executing of the query. The server simply re-uses the cached report.

|||I'd definately prefer the cache over generating another report. But if you feel so inclined, try both and time them to see which one is faster.

|||

Thanks, I tried this, rendered data got re-printed without execution of query.

Integration with Windows Rights Management

Does RS natively allow the application of Rights Management to reports as or
once they are rendered, e.g. to a web site or into a pdf file? If not do you
have any insight into how this can be done? Are there plans to integrate with
RM?This feature definitely on the future list but will not be in the SQL 2005
version of the product.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael J. O'Connell" <MichaelJOConnell@.discussions.microsoft.com> wrote in
message news:CA80EB14-8D0F-42CA-8940-D07214E7D2B1@.microsoft.com...
> Does RS natively allow the application of Rights Management to reports as
> or
> once they are rendered, e.g. to a web site or into a pdf file? If not do
> you
> have any insight into how this can be done? Are there plans to integrate
> with
> RM?|||Thanks Brian.
"Brian Welcker [MS]" wrote:
> This feature definitely on the future list but will not be in the SQL 2005
> version of the product.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Michael J. O'Connell" <MichaelJOConnell@.discussions.microsoft.com> wrote in
> message news:CA80EB14-8D0F-42CA-8940-D07214E7D2B1@.microsoft.com...
> > Does RS natively allow the application of Rights Management to reports as
> > or
> > once they are rendered, e.g. to a web site or into a pdf file? If not do
> > you
> > have any insight into how this can be done? Are there plans to integrate
> > with
> > RM?
>
>