Re-use filter

I have a chunk of SQL that is use if a particular report needs to have
a point in time parameter. Is there any way to store this code so any
report in the solution has access to it? I don't want any business
users that develop reports to have to type all the SQL in every time.
Any thoughts?You could create a custom assembly that returned this chunk of SQL and then
construct your commands through an expression that calls your custom
assembly.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Austin S" <austinswope@.gmail.com> wrote in message
news:b68c96f7.0409281425.27324a81@.posting.google.com...
>I have a chunk of SQL that is use if a particular report needs to have
> a point in time parameter. Is there any way to store this code so any
> report in the solution has access to it? I don't want any business
> users that develop reports to have to type all the SQL in every time.
> Any thoughts?