more-arw search

Q&A Forum

Has anyone worked with the report writer SSRS?

Richard Baikie's Profile

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.

Answers

Topic Expert
Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

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

Richard Baikie
Title: Director of Finance
Company: Super King Markets
(Director of Finance, Super King Markets) |

Thank you

Topic Expert
Donald Koscheka
Title: Principal
Company: Bluecloud Communications
(Principal, Bluecloud Communications) |

I have used it and it works fine for creating reports. It has a lot of flexibility in how the reports are generated (html, excel, etc) and provides drill-down capability out of the box. If you are using SQL Server, SSRS is a freebie so you have little to use to move in that direction. You can use SSRS to create reports from ANY ERP system, it does NOT have to be a SQL Server based system. You just need to be able to ETL your data into SSRS

Linda StClaire
Title: VP Finance
Company: Extron Inc.
(VP Finance, Extron Inc.) |

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

990 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.