Report Writers

[Martin Francom]

    I have been looking for report generators that might be of use with
my SQLite db.    Here's one that looks promising. 
Does anyone here have experience with this product?
Is it compatible with SQLite databases?

http://www.ajaxvideotutorials.com/videos/library/reports_tutorial/


Here's some additional videos.

http://www.alphasoftware.com/video/v10/

[Bob Houle]

Marty,

I've used Alpha Five since 1987!!!!

Yes, it is the best all round database product on the market. It is in the same league as Access.... but much, much better.
Most of my company runs on Alpha.... very stable.

Negatives:
You create a program and distribute it with a "run-time" which can be quite large.
It is expensive (about $900 with the ability to distrubute to unlimited users)
While I think it is easy to use, there is a steep learning curve (manual at least 1500 pages)
'----------------

I've used it with Postgres, but have no experience with SQLite and Alpha, but....

Alpha Five can use ODBC easily and there is an ODBC dll for SQLite available:
http://www.ch-werner.de/sqliteodbc/

Here is the Alpha Five Help File on the web: http://support.alphasoftware.com/alphafivehelpv10/

Do a search for SQL or ODBC and you should find what you are looking for.

HTH,
--Bob

[Marco Ruiz]

I use SQLite ODBC reportman. Reportman is free. Search google with "reportman"

[Martin Francom]

Bob and Maria,  Thank you for your suggestions.

Bob, do you know if Alpha-5 can utilize SQLitening Client/Server?   if it can only use SQLite's ODBC then wouldn't it only be able to run as a single user?    Or, SQLite's ODBC give it multiuser ability.   Also, are you using version 10 and what database do you usually use?

[Martin Francom]

Maria,
    I was able to find a lot of links to "Reportman" but none to their home page.  Would you perhaps have the link and could you post it?

[Bob Houle]

Code Select Expand

Bob, do you know if Alpha-5 can utilize SQLitening Client/Server?   if it can only use SQLite's ODBC then wouldn't it only be able to run as a single user?    Or, SQLite's ODBC give it multiuser ability.   Also, are you using version 10 and what database do you usually use?

I don't see a problem with the SQLite/SQLitening connection.

I use version 10.5 (latest version) with Alpha's native FoxPro DBF files. I've used PostgreSQL as well.

I've used a few dBase programs (Cheetah and Apollo) to open/close Alpha tables with PowerBASIC EXE's while my Alpha programs were running with no problem.

Alpha Five is quite robust and does multi-user quite well. If you intend to have "many" users... implement a SQL server backend (Postgres) and create all your form and reports with A5. Why re-invent the wheel. I've got one app with 40 tables and it is very fast with 10 users. Speed is no issue.

--Bob

[Marco Ruiz]

I was able to find a lot of links to "Reportman" but none to their home page.  Would you perhaps have the link and could you post it?


Yes. You can download it from this link:

http://reportman.sourceforge.net/downloades.html

[Martin Francom]

Again thanks Maria,
    I can't seem to be able to connect to my SQLite/SQLitening database.  Under Database connection I don't see SQLite .
    How do I connect to my SQLite database?

[Marco Ruiz]

Hello Marti.

I have developed a small project to be able to guide you through the use of "reportman".
See the attachment.
The ODBC driver you can download it from this link:
http://www.ch-werner.de/sqliteodbc/

Regards,

Marco Ruiz.

PD.: Maria Beytia is my Boss.

[Paul Squires]

Thanks Marco - I updated your profile so that your display name will now how as Marco. Your username has to stay as Maria.

[Rolf Brandt]

No woman, no cry...