Generating reports from SQL data

[Miha]

Hi



Since I don't have much programming experiences, I'm wondering if there is a
program or tool that could give me html or any other report that will be
generated dynamically, based on the data in SQL.

We need to generate some kind of report (html) that will be viewed on our
company's intranet. After selecting desired object (like computer name in
our intranet report), report will collect proper data from SQL and show them
in a desired format, together with other 'statical' data like:

Computer name: 'value from SQL'

IP: 'value from SQL'

Software 'value from SQL'

etc etc

Browsing on the internet, we have found Crystal Reports, but I'm not sure if
this is the right tool to do this? Any ideas what could we use to be the
easiest way to generate this kind of reports?

Thank you all in advance!

Regards

Miha

 

[Guest]

Hi Miha

What you need is SQL Server Reporting Services.
Take a look at
http://www.microsoft.com/sql/technologies/reporting/default.mspx
You might find what you're looking for.
There is also a Reporting Services forum at
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

 

[Miha]

Thanks. We'll try with ReportingServices
Regards
Miha