SQL server report service - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL server report service

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-13 : 07:51:52

robert writes "Is their a forum for developers.

I want users to enter parameters on the web and get a report with data focues on the parameters. The SQL server report service featear appears to need II6, Window 2000+, .NET, and Visual studio.

Is there no no reprot service for a simple NT server with SQL2000?"

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2005-01-13 : 13:33:15

Yea you can dump the results into Excel and manipulate the excel object using VBA code

Sitka
Aged Yak Warrior

571 Posts

Posted - 2005-01-13 : 13:55:08

Is there no no reprot service for a simple NT server with SQL2000?

well you still need a web server.
Three parts needed 1.)SQL, 2.)web server available in option pack 4 for NT, 3.)code.
The code is the simplist report service.
And can be written in a variety of languages (that IIS (any version)) supports) in notepad.
In order for the web page to interact with the user it has to use some form of request and response
mechanism. Many simple inexpensive tools can help you on your way but most involve a
wed page construction background. Drag and Drop web reporting functionality is found in
products such as Crystal Reports and Access 2003, their are probably a few thousand others.

I wish someone would start an Official XML Rant Thread.

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2005-01-13 : 14:02:11

quote:

I want users to enter parameters on the web and get a report with data focues on the parameters. The SQL server report service featear appears to need II6, Window 2000+, .NET, and Visual studio.

Their are instructions for installing the sql server reporting service without installing Visual Studio... but you start from a box with IIS.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources