对我来说，执行查询并将其转换为可刷新的结果集图表的最快方法是什么？
我经常发现自己编写一次性查询来回答某人的问题或解决某些问题，并且我希望能够以图形方式快速显示查询的按需可刷新结果，以便我可以将这些结果分享给其他人，而无需通过创建 SSRS 报告并将其发布到报告服务服务器的过程。
我曾考虑过使用 excel 来执行此操作，或者运行本地 SSRS 服务器，但这两个选项仍然是劳动密集型的，而且我无法证明执行这些操作所需的时间是合理的，因为没有人正式要求我将这些数据转换为报告。
在我看来，我工作的企业投入了资金让我创建这些查询，这些查询通常会返回组织中其他人可能想要的潜在有用数据，但由于它没有以任何方式暴露，而且我不知道这数据是他们想要的东西，但他们可能甚至没有意识到他们想要这些数据，查询的潜在价值没有实现。我希望通过以图形方式公开其结果来提高公司对我和其他开发人员编写的所有一次性查询的投资回报，以便其他人可以浏览它们，然后如果它们提供足够的价值来证明其合理性，则可能会转化为更正式的 SSRS 报告报告的发展。
对我来说，执行查询并将其转换为可刷新的结果集图表的最快方法是什么？
I often find myself writing one off queries to either answer someone's question or trouble shoot something and I would like to be able to quickly expose the on demand refreshable results of the query graphically so that I can share these results to others without having to go through the process of creating an SSRS report and publishing it to a reporting services server.
I have thought about using excel to do this or maybe running a local SSRS server but both of these options are still labor intensive and I cannot justify the time it would take to do these since no one has officially requested that I turn this data into a report.
The way I see it the business I work for has invested money in me creating these queries that often return potentially useful data that other people in the organization might want but since it isn't exposed in any way and I don't know that this data is something they want and they may not even realize they want this data, the potential value of the query is not realized. I want to increase the company's return on investment on all these one off queries that I and other developers write by exposing their results graphically so that they can be browsed by others and then potentially turned into more formalized SSRS reports if they provide enough value to justify the development of the report.
What is the fastest way for me to take a query and turn it into a refreshable graph of the results set?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
为什么不简单地使用你可能已经拥有的东西呢？ Excel...您可以通过 ODBC / Oracle / SQL 连接导入数据。获取数据..然后您可以运行查询并在电子表格中对其进行格式化并提供排序等。您需要提供的只是数据库名称以及连接到数据库的用户名和密码。
Why dont you simply use what you may already have. Excel...you can import data via an ODBC / Oracle / SQL Connection. Get Data..and bam you can run the query and format it right in the spreadsheet and provide sorting etc. All you need to supply is the database name and user name and password to connect to the db.
JonH 关于 Excel 内置 ODBC 支持的说法是正确的，但我在这方面遇到了很多麻烦。就我而言，ODBC 连接需要安装客户端软件，以便它可以使用加密方法等。此外，即使不是这种情况，用户（我相信）仍然需要手动安装和设置ODBC 连接。
现在，如果您只想在计算机上进行某些操作来执行查询并刷新它们，那么 JohH 的解决方案非常棒，而我的警告可能无关紧要。但是，如果您希望其他用户能够访问，您应该考虑使用一个中间人应用程序（基本上是一个 PHP 脚本，假设您可以选择 Web 服务器），它执行查询，将结果转换为 XML，然后输出作为“报告-xyz.xml”。然后，您可以将运行较新版本 Excel 的任何人指向该地址，他们就可以轻松地将数据导入到 Excel 中，而无需任何开销。 （基本上是一种网络服务）。
请记住，我不认为您应该有一个允许用户向您的数据库服务器进行查询的 Web 脚本！您将有一些管理页面，您可以在其中传递查询，并生成一个包含结果的新 xml 文件。所以我的想法也是基于这样的想法：您希望一遍又一遍地运行相同的查询，而不传入任何具体信息。（如果是这样的话，我会考虑为您的数据库找到一个预先构建的 Web 服务桥已经内置了安全功能。然后您可以让用户进行允许的有限更改。）
JonH is right regarding Excel's built in ODBC support, but I have had tons of trouble with this. In my case, the ODBC connection required the client software to be installed so that it could use the encryption methods, etc. Also, even if that were not the case, the user (I believe) would still have to manually install and set up an ODBC connection.
Now if you just want something on your machine to do the queries and refresh them, JohH's solution is great and my caveats are probably irrelavent. But if you want other users to have access, you should consider having a middle-man app (basically a PHP script, assuming a web server is an option for you), that does a query, transforms the results into XML, and outputs it as "report-xyz.xml". You can then point anybody running a newer version of Excel to that address and they can very easily import the data into Excel with no overhead. (basically a kind of web service).
Keep in mind, I don't think you should have a web script that will allow users to make queries to your Database server! You would have some admin page where you make pass the query in and a new xml file with the results gets made. So my idea is also based on the idea that you want to run the same queries over and over without any specifics passed in. (if that were the case, I'd look into just finding a pre-built web services bridge for your database that already has security features built in. Then you could have users make the limited changes allowed.)