Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reporting tool for postgres on linux
- Thread starter ahi
- Start date
- Thread starter
- #3
hi ahi,
I have written a VFP7 client to a postgres back-end server. It allow VFP7 to connect to a postgres back-end server and send SQL command. The SQL command fetches records that are placed in a VFP7 cursor. Once this is done, you can create report in the normal VFP7 way like using the native VFP7 report writer, or you could use other reporting tools that are designed to work with VFP7 like FoxFire or Crystal.
If your interested you could take a look at the VFP7 client. It is freeware complete with source code.
You must enter the site and click on option # 18.
One possible problem is you will need VFP7 to run the example app. Anyway, the concepts I've used are pretty generic and could easily be applied to other front-end client written in VB, Delphi, perl, php, C++, etc. Also, the front-ends could be modified to work with about any database like MSSQL, MySQL, Oracle, DB2, Informax, Sybase, and of course Postgres.
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
I have written a VFP7 client to a postgres back-end server. It allow VFP7 to connect to a postgres back-end server and send SQL command. The SQL command fetches records that are placed in a VFP7 cursor. Once this is done, you can create report in the normal VFP7 way like using the native VFP7 report writer, or you could use other reporting tools that are designed to work with VFP7 like FoxFire or Crystal.
If your interested you could take a look at the VFP7 client. It is freeware complete with source code.
You must enter the site and click on option # 18.
One possible problem is you will need VFP7 to run the example app. Anyway, the concepts I've used are pretty generic and could easily be applied to other front-end client written in VB, Delphi, perl, php, C++, etc. Also, the front-ends could be modified to work with about any database like MSSQL, MySQL, Oracle, DB2, Informax, Sybase, and of course Postgres.
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
Just like any other ODBC connection...you just need the drivers:
-- Paul
-- Paul
Also, if you use the PostgreSQL JDBC driver, there are quite a few Java-based reporting apps that will work fine.
There is one free tool I know of at (Lots of good links at -------------------------------------------
"Now, this might cause some discomfort..."
(
There is one free tool I know of at (Lots of good links at -------------------------------------------
"Now, this might cause some discomfort..."
(
Oh, and if you use KDE on Linux, there is one at -------------------------------------------
"Now, this might cause some discomfort..."
(
"Now, this might cause some discomfort..."
(
- Status
Similar threads
- Locked
- Question