MS Access数据库中的MS Reporting Services报告查看器

时间:2021-12-07 08:20:54

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功能更强大但它仍然是免费的快递版。