Custom reports from SQL 2000

What would I need to create custom reports from SQL 2000 reporting services?
I was told I would need Visual Studio to create the reports. It would be
nice to do some ad hoc reporting without having to go to our developer each
time we want to create a new report.RS 2005 has an end user reporting solution as well as the report designer
which exists in RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rockn" <Rockn@.newsgroups.nospam> wrote in message
news:ebCEtnANHHA.4244@.TK2MSFTNGP04.phx.gbl...
> What would I need to create custom reports from SQL 2000 reporting
> services? I was told I would need Visual Studio to create the reports. It
> would be nice to do some ad hoc reporting without having to go to our
> developer each time we want to create a new report.
>|||I believe this would only let you set the parameters for the report not the
content or type of report.
I would like to create completely custom reports. If VS2003 is the only way
to do it without upgrading to SQL 2005 we may have to go that route.
We have the media for SQL 2005 and isn't there some client side report
writer you could use in conjunction with the SQL 2000 data base we are
currently using for production?
"Paul.G." <PaulG@.discussions.microsoft.com> wrote in message
news:3E8832DC-C2F9-402B-B64D-3AD4B0EF748F@.microsoft.com...
> reports in Reporting services 2000 are created only in visual studio
> 2003.
> But as the reports are plain XML document, then your developper team can
> create a module for you that interacts with your database and let you
> create
> reports on the FLY. That means an application created by your team that
> let
> you create reports that you need.
> BUT this approche takes a gr8 deal of developpemnt, time, and resources.
> What I suggess is to define your needs and go to your developper team.
> "Rockn" wrote:
>> What would I need to create custom reports from SQL 2000 reporting
>> services?
>> I was told I would need Visual Studio to create the reports. It would be
>> nice to do some ad hoc reporting without having to go to our developer
>> each
>> time we want to create a new report.
>>|||Hello Rockn,
My understanding is that: You want konw is it possible that SQL 2005
Reporting service use the SQL 2000 database as the datasource.
My answer is yes. You could use the SQL 2000 database as the datasource of
the SQL 2005 reporting services.
Sincerely,
Wei Lu
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.|||Hi,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================