Queries in mulitiple places

I have many reports in one project and I am using the same query in a few of
the reports. How can I set the query in one place and have my report call
that query? Is that possible? If so, does anyone have an example?Yes, make the query a stored procedure.
Rodney
"David" <dilworth@.newsgroups.nospam> wrote in message
news:AB449D8E-A300-48A8-A3F7-4F8E275BD1DF@.microsoft.com...
>I have many reports in one project and I am using the same query in a few
>of
> the reports. How can I set the query in one place and have my report call
> that query? Is that possible? If so, does anyone have an example?
>|||Unfortunately the answer is no. I too have queries I use multiple places,
especially for parameter lists. The best you can do is create a stored
procedure and use that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:AB449D8E-A300-48A8-A3F7-4F8E275BD1DF@.microsoft.com...
>I have many reports in one project and I am using the same query in a few
>of
> the reports. How can I set the query in one place and have my report call
> that query? Is that possible? If so, does anyone have an example?
>|||Hi David,
As other members have suggested, we may consider encapsulate the query in a
store procedure to reuse it. As RS report layer, we can only reuse a
certain DataSource/DataSet rather than an individual query.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)