How good is sql server report server [closed]

As it currently stand开发者_高级运维s, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

we are in the middle of implementing a bi solution for a big retail company. They have reports which run on excel as per the moment. Do you think SSRS (Sql server report services) will be a good consideration to replace the excel reports? Also will there be any licencing issues that we/our client may have to face? (At the moment our client has SQL Server 2008 R2 standard edition licence)

---

We use SSRS exclusively for our reporting needs and have found it to be a good solution. The report builder interface leaves a lot to be desired but once you are used to it you can create reports quickly and efficiently.

With regards to licensing each server you install SSRS on requires a SQL Server license, so if you install SSRS on the same machine you are running SQL Server then you have no problems, to install on to a separate server requires an additional SQL license.