One of our software vendor has told us that they will not be using Crystal Reports in the future and that they are going with SSRS (which I believe stands for SQL Server Reporting Support). Is anyone familiar with this? Anyone using it? I was interested in any feedback or opinions. Thanks.
Has anyone worked with the report writer SSRS?
Answers
Richard,
In laymen's term, SSRS is the reporting tool that Microsoft includes in their SQL Server software. So, if you have an ERP system based on a MS SQL Server database, the software vendor will use SSRS to query the data and generate reports, from trial balances to AR aging reports, invoices etc. You would then also be able to use SSRS to develop your own reports.
See http://msdn.microsoft.com/en-us/library/ms159106.aspx
Allied to this is SSAS, which is Sequel Server Analysys Services, a similar tool which performs OLAP (online analytical processing)-i.e. business intelligence, data mining.
See http://msdn.microsoft.com/en-us/library/bb522607.aspx
Check with your IT colleagues if your version of MS SQL Server includes SSRS and SSAS capabilities.
Len
1
Thank you
I have used it and it works fine for creating reports. It has a lot of flexibility in how the reports are generated (html,
We use SSRS extensively as it allows us to also create customer specific reports (impresses and pleases customers with little effort), as well as company reports quickly and accurately. Personally I have not used it, our IT department creates these reports-I use ODBC for financial analysis myself. However, IT is quickly able to "translate" ODBC to SSRS (since ODBC by definition is an open database, the queries cannot be shared across departments, SSRS is more secure).
Filed Under:
Technology