I built something like that for SQL reporting services. It required several tables to pull it off though.
AdHock_SQL_Reports, which included the name, path, and display name for the report.
AdHock_Sql_Reports_Parameters, which included the parameter name, and value, along with a flag that tells the code, the the value could be a SQL commnd to generate values on the fly.
Then you would need to build code to deal with these tables, and to generate a list of drop down lists on a web page.
What I built is pretty "fist pass" and is kind of rough around the edges.
You can also expose SQL reporting services reports to users, and have reporting services provide input fields for those reports. We have started to lean that way and away from my code. ( Its better than what I have anyway )
我们完全使用托管 .NET 代码构建它，并包含 ASP.NET 控件，以便轻松集成到您自己的 ASP.NET 站点中。 当然，还有适用于其他语言/平台的 Web 服务，并且它负责基于 Web 的报告的许多其他重要细节，例如可扩展性/负载平衡、调度报告、输出到 excel/pdf/word 等、基于角色的安全性、多租户部署支持、移动设备支持，并且与 ActiveReports Developer Component XML 报表文件兼容。
是的，我是产品经理。
Probably not on the "simple" side, but for more sophisticated ad-hoc reporting that allows business users to build a report in the browser without knowing SQL and without installing anything, check out our ActiveReports Server product.
We built it entirely in managed .NET code and we include ASP.NET controls to make it easy to integrate into your own ASP.NET sites. Of course there are webservices for other languages/platforms, and it takes care of many other important details for web-based reporting like scalability/load balancing, scheduling reports, output to excel/pdf/word, etc., role-based security, multi-tenant deployment support, mobile device support, and it is compatible with ActiveReports Developer Component XML report files.
除了 HTML 输出的 Web 嵌入性之外，您还可以提供独立组件和/或 Java 小程序（i-net Clear Reports 完全是 Java，但我们正在努力将服务器端移植到 .NET）。 即将推出的版本甚至支持网页皮肤，因此您的用户/客户不会识别它是“第三方”。 ；）
披露：是的。 我在建造这个的公司工作。
Though not .NET (yet) - but embeddable using an iframe - I'd recommend i-net Clear Reports (used to be i-net Crystal-Clear) sporting an ad-hoc reporting component that is made to be an easy-to-use thing for non-technical users. Your users won't have to know anything about reporting at all. They simply select the kind of report, the data et voila there is a report suiting the needs.
Besides the web embeddability of the HTML output you could offer a standalone component and/or Java applet (i-net Clear Reports is entirely Java, but we're working hard to port the server side over to .NET). The upcoming version even supports web-skins so your users / customers won't recognise it's "third party". ;)
Disclosure: Yep. I work for the company who built this.
我强烈推荐 http://www.izenda.com 上的 Izenda 报告。 它是一个完全集成的 ASP.Net AJAX 解决方案，可连接到数据库，允许最终用户构建自己的报告以及运行现有报告。
I would highly recommend Izenda Reports at http://www.izenda.com. It's a fully integration ready ASP.Net AJAX solution to connect to to your database that allows end-users to build their own reports as well as running of existing reports.
To be honest, you probably need to gather requirements and find out what kinds of reports they will be interested in running and build the reports for them. However, have you considered Crystal Reports?
发布评论
评论（6）
我为 SQL 报告服务构建了类似的东西。 不过，它需要几张桌子才能完成。
然后，您需要构建代码来处理这些表，并在网页上生成下拉列表的列表。
我构建的东西相当“拳头通行证”，并且边缘有点粗糙。
您还可以向用户公开 SQL 报告服务报告，并让报告服务为这些报告提供输入字段。 我们已经开始朝着这个方向倾斜，远离我的代码。 （无论如何，它比我拥有的要好）
I built something like that for SQL reporting services. It required several tables to pull it off though.
Then you would need to build code to deal with these tables, and to generate a list of drop down lists on a web page.
What I built is pretty "fist pass" and is kind of rough around the edges.
You can also expose SQL reporting services reports to users, and have reporting services provide input fields for those reports. We have started to lean that way and away from my code. ( Its better than what I have anyway )
可能不是“简单”方面，但对于更复杂的临时报告（允许业务用户在不了解 SQL 且无需安装任何内容的情况下在浏览器中构建报告），请查看我们的 ActiveReports 服务器产品。
我们完全使用托管 .NET 代码构建它，并包含 ASP.NET 控件，以便轻松集成到您自己的 ASP.NET 站点中。 当然，还有适用于其他语言/平台的 Web 服务，并且它负责基于 Web 的报告的许多其他重要细节，例如可扩展性/负载平衡、调度报告、输出到 excel/pdf/word 等、基于角色的安全性、多租户部署支持、移动设备支持，并且与 ActiveReports Developer Component XML 报表文件兼容。
是的，我是产品经理。
Probably not on the "simple" side, but for more sophisticated ad-hoc reporting that allows business users to build a report in the browser without knowing SQL and without installing anything, check out our ActiveReports Server product.
We built it entirely in managed .NET code and we include ASP.NET controls to make it easy to integrate into your own ASP.NET sites. Of course there are webservices for other languages/platforms, and it takes care of many other important details for web-based reporting like scalability/load balancing, scheduling reports, output to excel/pdf/word, etc., role-based security, multi-tenant deployment support, mobile device support, and it is compatible with ActiveReports Developer Component XML report files.
And yes, I'm the Product Manager.
EasyQuery.NET 可能会满足您的需求。
它是专有的，但他们也有免费版本。
EasyQuery.NET may suit your needs.
It is proprietary but they have free version as well.
虽然还不是 .NET - 但可以使用 iframe 嵌入 - 我建议 i -net Clear Reports（以前是 i-net Crystal-Clear），带有一个特别的报告组件，对于非技术用户来说是一个易于使用的东西。 您的用户根本不需要了解有关报告的任何信息。 他们只需选择报告类型、数据即可找到适合需求的报告。
除了 HTML 输出的 Web 嵌入性之外，您还可以提供独立组件和/或 Java 小程序（i-net Clear Reports 完全是 Java，但我们正在努力将服务器端移植到 .NET）。 即将推出的版本甚至支持网页皮肤，因此您的用户/客户不会识别它是“第三方”。 ；）
披露：是的。 我在建造这个的公司工作。
Though not .NET (yet) - but embeddable using an iframe - I'd recommend i-net Clear Reports (used to be i-net Crystal-Clear) sporting an ad-hoc reporting component that is made to be an easy-to-use thing for non-technical users. Your users won't have to know anything about reporting at all. They simply select the kind of report, the data et voila there is a report suiting the needs.
Besides the web embeddability of the HTML output you could offer a standalone component and/or Java applet (i-net Clear Reports is entirely Java, but we're working hard to port the server side over to .NET). The upcoming version even supports web-skins so your users / customers won't recognise it's "third party". ;)
Disclosure: Yep. I work for the company who built this.
我强烈推荐 http://www.izenda.com 上的 Izenda 报告。 它是一个完全集成的 ASP.Net AJAX 解决方案，可连接到数据库，允许最终用户构建自己的报告以及运行现有报告。
I would highly recommend Izenda Reports at http://www.izenda.com. It's a fully integration ready ASP.Net AJAX solution to connect to to your database that allows end-users to build their own reports as well as running of existing reports.
老实说，您可能需要收集需求并找出他们有兴趣运行哪些类型的报告并为他们构建报告。 但是，您考虑过水晶报表吗？
To be honest, you probably need to gather requirements and find out what kinds of reports they will be interested in running and build the reports for them. However, have you considered Crystal Reports?