How good is sql server report server [closed]
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.
精彩评论