Generating reports from SQL data

View Full Version : Generating reports from SQL data

Miha

02-05-2006, 10:46 AM

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

mop

02-05-2006, 05:41 PM

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" wrote:

> 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
>
>
>
>
>

Miha

02-09-2006, 05:33 PM

Thanks. We'll try with ReportingServices
Regards
Miha
"mop" <mop@discussions.microsoft.com> je napisal v sporoèilo
news:D2DB9BA0-3B1B-4B7F-9FC6-02D585B39C98@microsoft.com ...
> 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" wrote:
>
>> 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
>>
>>
>>
>>
>>