Search code examples
phpcrystal-reportsodbcsybase-asa

How to use Crystal Reports with parameters in PHP?

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.

Solution

  • 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.