"Wayne Snyder" wrote:

> Each matrix, table, etc in a report can have its own data set....and you can
> include mutlitple tables, matrixes ,etc on a single report...Take a look at
> some of the adventure works RS examples which have order detail, and order
> header , or employee sales...
>
> Hope this helps...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Chris Stewart" <ChrisStewart@discussions.microsoft.com> wrote in message
> news:CC08BF45-5B95-483D-BA8D-8F3B1C408DCE@microsoft.com...
> > I'm trying to build a somewhat complex report and to do it requires a
> > number
> > of queries. Can anyone help me figure out how to run multiple queries in
> > a
> > single report? Do I need to break it out into sub reports to do it? If
> > so,
> > how can I pass a parameter to a sub report during "runtime". Thanks for
> > any
> > replies.
>
>