Good books on SQL Server Reporting Services

Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
SimonReporting services is so new that I don't think there are any books
published on it yet.
This is your starting point:
http://www.microsoft.com/sql/reporting/default.asp
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Simon Lenn" <simonlenn@.yahoo.com> wrote in message
news:3641e2c2.0312191558.270cef9b@.posting.google.com...
Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
Simon

Good books on SQL Server Reporting Services

Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
SimonReporting services is so new that I don't think there are any books
published on it yet.
This is your starting point:
http://www.microsoft.com/sql/reporting/default.asp
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Simon Lenn" <simonlenn@.yahoo.com> wrote in message
news:3641e2c2.0312191558.270cef9b@.posting.google.com...
Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
Simon

global dataset for n number of forms

hi friends ,

Is there anyway to share a single dataset for different forms.. coz i am repeatedly using the same query for different forms...

No, you cannot share a dataset among reports. Anyway, it doesnt make a big difference because the same query is going to run against the database even it is same for different reports.

If you are using SQL query text in your reports, consider creating a stored procedure for the query and use the stored procedure in all your reports.

Shyam

|||thank you shyam.......|||

Can you please mark the post as answer?

Giving Active Queries Priority

Is there a way to give a particular query greater system resources,
such as share of the processor?

I have two queries that were started from Query Analyzer. One is very
long, the other rather short. However the long one is taking almost
all the processor resources and not allowing the short one to complete.
I'd like to allocate more of the processor to the short one until it
is done.

I am the admin on this system and have access to Enterprise Mgr.

Thanks.Hi

If you had multiple processors then you may want to look at the maxdop query
hint, or you may want to break your longer running query up so that other
activity can occur. You may also want to look at the query plan to see if
you can optimise the long running query or possibly re-architect the
database/system to remove the need for such intensive processing.

John

<sfarkas@.visa.com> wrote in message
news:1117592953.657773.238730@.o13g2000cwo.googlegr oups.com...
> Is there a way to give a particular query greater system resources,
> such as share of the processor?
> I have two queries that were started from Query Analyzer. One is very
> long, the other rather short. However the long one is taking almost
> all the processor resources and not allowing the short one to complete.
> I'd like to allocate more of the processor to the short one until it
> is done.
> I am the admin on this system and have access to Enterprise Mgr.
> Thanks.