Reporting Services

Good day!

What need install for begin work whis sql 2000 Reporting Services
on server and on workstation?

Thank's.SQL Reporting Services is available free of charge as long as you have a valid instance of SQL Server. It's a great tool and we use it extensively throughout our intranet to generate dynamic reporting for executives.|||Hi Jstersd,

I'm using SQL Server Reporting Services on my project and it is working fine; however, I don't know how to create dynamic reports! I need to create the query on the fly with different where clause and then use the finished query for report. Do you know how to create this type of ad-hoc report? Thanks.|||Mike:

Check out this link:
http://www.databasejournal.com/features/mssql/article.php/3317461

Very good article w/illustrations...

Also - there are some very good WebCasts...go to
http://www.microsoft.com/seminar/events/webcasts/library/200408.mspx
and search on services...

JerryK|||Hi,

I found the answer I was looking for -- SQL Server Reporting Services does NOT support ad-hoc reporting!!!! Isn't that bad or what?

http://www.microsoft.com/technet/community/chats/trans/sql/sql0625.mspx|||Explain what you mean by ad-hoc reporting in this context. What's your scenario...|||By ad-hoc I mean user goes through a series of filtering criteria and at the end we end up with a query. I want my report to be based on that finished query. In other words, I like to create my query dynamically and make my report based on that. Parameters are kind of handicapped and not useful in this scenario!|||Thank's for all

now
on workstation i have -> Dot net , sql server client.
on server -> sql server 2000

sql report service need instal on server or on workstations ?

Thank you.