I have a report deployed on a MS Reporting Services server, working fine. I can access it from a ASPX page with no problems, set the report parameters, etc, using the Report Viewer component from Microsoft. Works great.
我在MS Reporting Services服务器上部署了一个报告,工作正常。我可以使用Microsoft的Report Viewer组件从ASPX页面无问题地访问它,设置报告参数等。效果很好。
The question is: is there any way to view this report WITHIN a form in an Access database? Is there a version of the report viewer that can be used with MS Access?
问题是:有没有办法在Access数据库中的表单中查看此报告?是否有可以与MS Access一起使用的报告查看器版本?
I have searched online, but I can't find a solution.
我在线搜索,但找不到解决方案。
I know an Access report can be imported into SSRS, but I need to be able to view an SSRS report from within Access.
我知道可以将Access报告导入SSRS,但我需要能够从Access中查看SSRS报告。
Thanks!!
2 个解决方案
#1
Not in a form directly.
不是直接表格。
The best you'll get is some kind of "Web" Control that can be used to give an IE session to the report. Or have a link label with URL Access to create a separate IE Window.
您将获得的最佳功能是某种“Web”控件,可用于为报表提供IE会话。或者使用URL Access的链接标签来创建单独的IE窗口。
#2
insert, activeX control, Microsoft Web Browser would allow you to setup a web browser control inside of an Access form.
插入,activeX控件,Microsoft Web浏览器将允许您在Access窗体内设置Web浏览器控件。
I think that SSRS is a completely superior product, I'd just get rid of Access and use a current reporting tool. Microsoft has implemented ReportViewer controls that allow you to embed SSRS reports anywhere you want (in .NET land).
我认为SSRS是一个完全优秀的产品,我只是摆脱Access并使用当前的报告工具。 Microsoft已实现了ReportViewer控件,允许您在任何地方嵌入SSRS报告(在.NET中)。
Perhaps you could build an Access add-in that uses this control.
也许您可以构建一个使用此控件的Access加载项。
But the bottom line is that SSRS is the future-- SSRS is embedded in the middle of dozens of Microsoft software products - Team Foundation Server for example.. and I think that it's obvious that SSRS is more powerful and yet it's still FREE in the express edition.
但最重要的是SSRS是未来 - SSRS嵌入在数十种Microsoft软件产品中间 - 例如Team Foundation Server ..而且我认为很明显SSRS功能更强大但它仍然是免费的快递版。
#1
Not in a form directly.
不是直接表格。
The best you'll get is some kind of "Web" Control that can be used to give an IE session to the report. Or have a link label with URL Access to create a separate IE Window.
您将获得的最佳功能是某种“Web”控件,可用于为报表提供IE会话。或者使用URL Access的链接标签来创建单独的IE窗口。
#2
insert, activeX control, Microsoft Web Browser would allow you to setup a web browser control inside of an Access form.
插入,activeX控件,Microsoft Web浏览器将允许您在Access窗体内设置Web浏览器控件。
I think that SSRS is a completely superior product, I'd just get rid of Access and use a current reporting tool. Microsoft has implemented ReportViewer controls that allow you to embed SSRS reports anywhere you want (in .NET land).
我认为SSRS是一个完全优秀的产品,我只是摆脱Access并使用当前的报告工具。 Microsoft已实现了ReportViewer控件,允许您在任何地方嵌入SSRS报告(在.NET中)。
Perhaps you could build an Access add-in that uses this control.
也许您可以构建一个使用此控件的Access加载项。
But the bottom line is that SSRS is the future-- SSRS is embedded in the middle of dozens of Microsoft software products - Team Foundation Server for example.. and I think that it's obvious that SSRS is more powerful and yet it's still FREE in the express edition.
但最重要的是SSRS是未来 - SSRS嵌入在数十种Microsoft软件产品中间 - 例如Team Foundation Server ..而且我认为很明显SSRS功能更强大但它仍然是免费的快递版。