英文:
Using SSRS to Show Reports in a Web Page
问题
I have an upcoming project at work to develop reports displayed in a web page. I've been pointed to SSRS (or possibly Power BI) to build them but I don't really see the point of using it instead of just using web services to send data out to a Javascript front end.
The requirements include:
- Sort the data
- Filter the data
- Group the data
- Hide/Show columns
- Save user preferences
- Output to other formats (.pdf, .xslx)
I haven't worked with SSRS much so maybe I'm missing something, but it seems that we'd have more flexibility in the look/feel of the page, the functionality, and how the data is loaded if we ignored SSRS and rolled our own with little extra effort.
What exactly would be the advantage of using SSRS in this case? Am I right to want to architect my own solution from scratch?
英文:
I have an upcoming project at work to develop reports displayed in a web page. I've been pointed to SSRS (or possibly Power BI) to build them but I don't really see the point of using it instead of just using web services to send data out to a Javascript front end.
The requirements include:
- Sort the data
- Filter the data
- Group the data
- Hide/Show columns
- Save user preferences
- Output to other formats (.pdf, .xslx)
I haven't worked with SSRS much so maybe I'm missing something, but it seems that we'd have more flexibility in the look/feel of the page, the functionality, and how the data is loaded if we ignored SSRS and rolled our own with little extra effort.
What exactly would be the advantage of using SSRS in this case? Am I right to want to architect my own solution from scratch?
答案1
得分: 4
在这种情况下使用SSRS的优点是什么？
主要是您无需构建和维护自定义HTML和JavaScript内容。这是一种典型的构建/购买权衡，通常受到希望快速变更和使单个人，甚至可能是非开发人员创建或维护报告的愿望驱动。
另外，.pdf 和 .xlsx 渲染并不简单，通常需要单独的设计和布局。
英文:
>What exactly would be the advantage of using SSRS in this case?
It's mostly that you wouldn't have to build and maintain the content in custom HTML and JavaScript. It's a typical build/buy tradeoff, and one that's often driven by the desire to have a high velocity of change, and to enable single person, and perhaps even a non-developer, create or maintain the reports.
Also .pdf and .xslx rendering are non-trivial, and typically require separate design and layout.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论