我想在 PHP 中使用带有 ODBC (Sybase) 数据连接的 Crystal 报表来显示我的数据库报表。
我选择Crystal Reports是因为它的先进功能、专业能力以及对Sybase数据库的支持。我还找到了 PHP Reports,但它不支持 Sybase。
我的配置是 PHP v5、Sybase ASA 11、Crystal Reports 9、IIS 6。
我在网上搜索了实际示例和应用程序,并尝试了它们,但它们不起作用。
以前有人尝试过这样做吗?请您给我提供一个这样的例子好吗?
I would like to use Crystal reports with an ODBC (Sybase) data connection in PHP to display my database reports.
I selected Crystal Reports because of its advanced features, professional abilities, and its support for Sybase databases. I also found PHP Reports but it doesn't support Sybase.
My configuration is PHP v5, Sybase ASA 11, Crystal Reports 9, IIS 6.
I searched the web for practical examples and Applications and I tried them but they do not work.
Has anyone tried to do that before? Would you please provide me with such an example.
发布评论
评论(2)
应该没问题。我自己并没有完成这个确切的顺序,但我已经做了很多类似的事情。
确保首先让 ODBC 正常工作(与 Crystal 和 PHP 分开)。例如。 Excel⇢ODBC⇢OpenClient⇢SybaseASE。 OpenClient 包含在 CD 中。 ODBC 设置起来很简单:数据源名称、默认数据库等。
Should be no problem. I have not done that exact sequence myself, but I have done many similar.
Ensure that you get ODBC working first (separate to Crystal & PHP). Eg. Excel⇢ODBC⇢OpenClient⇢SybaseASE. OpenClient comes on the CD. ODBC is simple to set up: Datasource names, default db, etc.
我不知道这是否是标准的工作方式,但在我工作的地方,我们有一个呈现水晶报告的 JSP。为了调用它,我们使用 javascript 创建一个链接到报表呈现器 URL 的弹出窗口,并在 URL 字符串中传递报表位置/参数。
如果您不想使用 Tomcat,那么您可以尝试一下 i-Net Crystal Reports,它使用 Java 小程序。
I don't know if this is the standard way it works but where I work we have a JSP that renders crystal reports. To call it we use javascript to create a popup linked to the report renderer URL with the report location/parameters passed in the URL string.
If you don't want to use Tomcat then you could give i-Net Crystal Reports a go, that uses a java applet.