Create a sales report

I am using SQL 2000 reporting service. I need to create a sales report
described below.
1. Return the top 10 clients in terms of the sales in Month/Year such as
Sep. 2006.
2. Return the sales to these 10 clients in the past 11 months of the above
entered date such as from Aug. 2005 to Aug. 2006.
3. Line them up to compare the sales in 12 months.
It's very easy to return the top 10 clients. However, I really don't know
how to complete the second retrun. Since the result should be based on the
return of the first query and the result of the first query is dynamic. Is it
possible to have this done in SQL reporting service? I can't find any related
document. Please advice.
Thanks.the Employee Sales Report sample report for Adventureworks does something
very similar to this...The drill down, I think, is either a link or subreport.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Jun" wrote:
> I am using SQL 2000 reporting service. I need to create a sales report
> described below.
> 1. Return the top 10 clients in terms of the sales in Month/Year such as
> Sep. 2006.
> 2. Return the sales to these 10 clients in the past 11 months of the above
> entered date such as from Aug. 2005 to Aug. 2006.
> 3. Line them up to compare the sales in 12 months.
> It's very easy to return the top 10 clients. However, I really don't know
> how to complete the second retrun. Since the result should be based on the
> return of the first query and the result of the first query is dynamic. Is it
> possible to have this done in SQL reporting service? I can't find any related
> document. Please advice.
> Thanks.

CPU or Client Version

We will use are SQL server as a search engine for are clients docs and online
jobtracking for are websites.
If you are asking what licensing model to use, you will probably have to use
per processor. I base that recommendation on the fact that you mention that
youe clients are accessing SQL Server through your websites.
Keith Kratochvil
"George" <George@.discussions.microsoft.com> wrote in message
news:B37091AA-C4D4-48A9-8270-6FBDCCA815F2@.microsoft.com...
> We will use are SQL server as a search engine for are clients docs and
> online
> jobtracking for are websites.

CPU or Client Version

We will use are SQL server as a search engine for are clients docs and onlin
e
jobtracking for are websites.If you are asking what licensing model to use, you will probably have to use
per processor. I base that recommendation on the fact that you mention that
youe clients are accessing SQL Server through your websites.
Keith Kratochvil
"George" <George@.discussions.microsoft.com> wrote in message
news:B37091AA-C4D4-48A9-8270-6FBDCCA815F2@.microsoft.com...
> We will use are SQL server as a search engine for are clients docs and
> online
> jobtracking for are websites.

CPU or Client Version

We will use are SQL server as a search engine for are clients docs and online
jobtracking for are websites.If you are asking what licensing model to use, you will probably have to use
per processor. I base that recommendation on the fact that you mention that
youe clients are accessing SQL Server through your websites.
--
Keith Kratochvil
"George" <George@.discussions.microsoft.com> wrote in message
news:B37091AA-C4D4-48A9-8270-6FBDCCA815F2@.microsoft.com...
> We will use are SQL server as a search engine for are clients docs and
> online
> jobtracking for are websites.