Reporting tool for MS SQL SERVER

[roche786]

Which is the best enterprise reporting tool to be used for SQL SERVER

 

[SQLSister]

Perhaps you need to be a bit more specific here about what you need?

 

[roche786]

I was looking for a reporting tool which will have MS SQL SERVER as the backend . This tool should also be able to help me deploy reports on the web wich is very important. I am new to using MS SQL SERVER and I dont have a idea which tools works best under these conditions.


Thank You

 

[ecobb]

If you're looking for a program that's not part of SQL Server, Crystal Reports is pretty good. It has a pretty easy interface where you just select the table and fields in the database you want to view and it does the querying and output for you. I haven't delt with it extensively, but I do believe there is feature that will display the reports in HTML for a web site.

Hope this helps.

 

[SQLSister]

Or if you need data input as well as reports, suggest the VisualStudio.net environment (which incidentally has Crystal Reports within it). Then you can program in vb.net or C#.net to create reports and searches, etc. I only mention this because rarely do people only want to see pre-programmed reports. Usually you will need a more complete user interface than that.

 

[roche786]

How is data access projects for reporting with SQL server as the backend.