locked
Reporting Services vs 3rd party tools RRS feed

  • Question

  • Hi,

    Have been developing reports for sometime now, but need to get an understanding of this.

    We are building a portal with ASP.NET, and part of the portal is the customer will be able to login and view some tabular reports, and charts etc. So my question is what would be better to use:

    1. SSRS via report viewer control or 

    2. 3rd party charting tools

    I am not even sure whether SSRS can be used outside of the firewall (internet) and if there is a licensing fee etc associated it for internet usage.

    Thanks,

    Recai

    Thursday, October 25, 2012 7:17 PM

Answers

  • SSRS would be able to be used in your web application through a report viewer, you just need to pass it credentials when accessing reports to display.  You web site needs to be internet facing.

    you might want to read

    http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

    SSRS can be licensed in various ways but it all comes down to how you want to have it licensed for your server.

    • Marked as answer by recai Friday, October 26, 2012 4:37 AM
    Thursday, October 25, 2012 11:08 PM

All replies

  • SSRS would be able to be used in your web application through a report viewer, you just need to pass it credentials when accessing reports to display.  You web site needs to be internet facing.

    you might want to read

    http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

    SSRS can be licensed in various ways but it all comes down to how you want to have it licensed for your server.

    • Marked as answer by recai Friday, October 26, 2012 4:37 AM
    Thursday, October 25, 2012 11:08 PM
  • Thanks for the answer.

    Just curious if has anyone implemented something like this or compared 3rd party tools vs SSRS. I am concerned about the performance because the tables are increasing 1M+ records weekly.  

    Friday, October 26, 2012 4:41 AM