SQL Reporting Services

[Bakedgoods]

Has anyone got any experience with this?

I need something which will calculate totals and create reports for a system which will log man hours on various projects. So it has to be able to calculate weekly/monthly/yearly totals for individual users on various projects and total time spent by all users on a paticular project.

Is SQL Reporting services the best option for this?

Cheers for any advice

The application itself is coded using ASP.net.

 

[sparkymark75]

It has it's limitations but if you have the infrastructure, namely IIS and SQL server, then it's probably your best option. If you install it on the same box as SQL server it's free.

As the reports are generated as web pages, you can link to them from your web application.

 

[~J~]

As mparter has said, it has limitations, but I use it nearly all the time for my customers reports and they have zero issues with it.

Personally I find setting up the server side of it a little finicky, but once it's up and running, it's a dream to use.

 

[davetherave2]

I have had limited exposure too it but have developed a few reports for the company I work for, so far they are happy with the results. We are currently in the process of updating our reporting structure and this is the perfect way for us to not only do internal reports but also client reports.

There's loads of useful websites out there to help and also a lot of really useful books which have helped me in understanding how reporting services work and how they can be best used.