ReportViewer - 远程模式问题
我们正在考虑在远程模式下使用 VS 2010 Microsoft Report Viewer。我的问题与数据检索发生的位置有关。让我举个例子。假设我们有一个包含两个参数的报告。然后,在检索数据时,这些参数将作为存储过程参数传递。那么,我的问题是,什么时候调用存储过程?是从 SSRS 2008 服务器调用,然后将数据和报告发送到报表查看器客户端,还是从报表查看器客户端调用存储过程?其次,假设报表正在报表查看器客户端中显示,并且用户更改参数值并刷新报表。存储过程是从客户端调用还是以某种方式从服务器调用存储过程?
We're considering using the VS 2010 Microsoft Report Viewer in Remote mode. My question has to do with is where data retrieval takes place. Let me give an example. Say we have a report with two parameters. These parameters are then passed as stored procedure parameters when data is retrieved. So, my question is, when is the stored procedure called? Is it called from the SSRS 2008 server and then the data and report sent to the report viewer client or, is the stored procedure called from the report viewer client? Secondly, let's say the report is being displayed in the report viewer client, and the user changes the parameter values and refreshes the report. Is the stored proc called from the client or is the stored proc somehow called from the server?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
在远程模式下,所有报告处理均由远程 SSRS 服务器执行 - 在您的示例中,存储过程将在服务器上执行,并将报告/数据返回给客户端。
如果在这种情况下更改参数并重新运行报表,则会从客户端向服务器提交新的报表执行请求,在服务器处进行处理,然后以相同的方式将报表/数据返回给客户端。
In remote mode, all the report processing is carried out by the remote SSRS server - in your example, the stored procedure would be executed on the server and the report/data returned to the client.
If the parameters are changed and the report re-run in this scenario, a new report execution request is submitted from the client to the server, processed at the server and report/data returned to the client in the same way.