使用 Quickbooks 2008+ 构建报告的方法 数据
我希望为 Quickbooks 数据构建一些报告，而不使用 Quickbooks 内置报告或通过第三方库（如 QODBC）。
Quickbooks 2008 及更新版本是基于 SQL 后端构建的。环顾四周，似乎有多种产品和角度可以做到这一点。
理想情况下，我希望能够自己对数据库进行直接 SQL 命中，或者使用 Crystal Reports 之类的东西。
我想在这里请求收集一些可以仔细观察的事情，以及可以避免哪些事情来避免悲伤。
提前致谢！
更新：Quickbooks 似乎对其 SQL 数据库进行了加密，因此您无法使用报告工具直接读取它。市场上有一些产品可以提供帮助。未来还会有更多产品。
I am looking to build some reports for Quickbooks data, without using Quickbooks built-in reporting, or through a third party library (like QODBC).
Quickbooks 2008 and newer are built on a SQL backend.. In looking around there seems to be several products and angles to do this from.
Ideally I would like to be able to do direct SQL hits on the database myself, or use something like Crystal Reports.
I wanted to ask here to gather any things to look at closer, and what to potentially avoid to save myself grief.
Thanks in Advance!
Update: It seems Quickbooks encrypts it's sql database so you can't read it directly with a reporting tool.. There are a few products on the market that can help.. more to come.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
最好的选择是 QuickBooks SDK，它提供了获取数据的工具，还可以直接从 QuickBooks 获取报告数据，格式为 XML，以便轻松解析和显示，无论您想要如何显示它。
您可以使用 qbXML/QBFC 屏幕上的 QuickBooks 查看可用的数据参考（您可以发送到 QuickBooks 的请求可在屏幕顶部的“选择消息”下拉框中找到）。
QuickBooks SDK 可以从 Intuit 开发者网络免费下载（需要注册
）如果您正在编写桌面应用程序，则可以考虑使用 QBFC，它是一个使用 COM/DCOM 与 QuickBooks 通信的 API。
如果您使用 PHP，可以使用流行的 QuickBooks PHP 框架 在 IDN 论坛上。
如果您使用的是 ASP.NET，这里有一个 QuickBooks ASP .NET 框架也是如此。
如果您想要直接 SQL 访问，您应该查看 QODBC（这是一个 SQL 包装器，它将 SQL 查询转换为 qbXML SDK 请求）或 AccessBooks（它使用 SDK 将 QuickBooks 数据镜像到 SQL 数据库）。
Your best bet is the QuickBooks SDK, it provides facilities to fetch data and also fetch reporting data directly from QuickBooks, formatted as XML for easy parsing and display however you want to display it.
You can see the data that's available using the qbXML/QBFC QuickBooks On-Screen reference (the requests you can send to QuickBooks are found in the 'Select Message' drop-down box at the top of the screen).
The QuickBooks SDK is a free download (registration required) from the Intuit Developer Network
If you're writing a desktop application, you can look into using QBFC, which is an API that talks to QuickBooks using COM/DCOM.
If you're using PHP, there's a popular QuickBooks PHP framework on the IDN forums.
If you're using ASP.NET, here's a QuickBooks ASP .NET framework too.
If you want direct SQL access, you should look at QODBC (which is an SQL wrapper which translates SQL queries to qbXML SDK requests) or AccessBooks (which uses the SDK to mirror QuickBooks data to an SQL database).
如果它托管在 SQL 2005 或 2008 上，您可以使用 Reporting Services（免费）以及与其捆绑的报表生成器。 如果您使用 2008，那么我建议下载 Report Builder 2.0
http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6
以下是一些学习 RS 的链接
： google.com/search?q=reporting+services+tutorial+video&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a" rel="nofollow noreferrer">http://www.google.com/search?q=reporting+services+tutorial+video&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla :en-US:official&client=firefox-a
If its hosted on SQL 2005 or 2008 you can make use of Reporting Services (free) and the Report Builder that is bundled with it. If you use 2008 then I recommend downloading Report Builder 2.0
http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6
Here's some links to learn RS:
http://www.google.com/search?q=reporting+services+tutorial+video&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
那么您使用的是 2008 版 (SQL Server) 吗？
如果是这样，您可以使用 SQLChicken 发布的 SSRS，或者您可以使用几乎任何其他报告工具，并通过 SQL Native Client（随 SQL Server 附带）进行连接：
- 水晶报告
- Excel
- 在此处插入您最喜欢的报告工具
So are you on the 2008 edition (SQL Server)?
If so, you can use SSRS as SQLChicken posted, or you can use just about any other reporting tool, and connect via SQL Native Client (shipped with SQL Server):
- Crystal Reports
- Excel
- insert your favorite reporting tool here