使用SSRS在网页中显示报表

huangapple go评论74阅读模式
英文:

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:

  1. Sort the data
  2. Filter the data
  3. Group the data
  4. Hide/Show columns
  5. Save user preferences
  6. 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:

  1. Sort the data
  2. Filter the data
  3. Group the data
  4. Hide/Show columns
  5. Save user preferences
  6. 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.

huangapple
  • 本文由 发表于 2020年1月3日 23:33:11
  • 转载请务必保留本文链接:https://go.coder-hub.com/59581259.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定