report designer and databases (reportman) - FREE !!!

[John Messingham]

I have used reportman with Access, SQLite, SQL Server, MySQL, Firebird and Cheetah and found it to be very good.

The only thing I found to be an issue when using it with SQLite is on the data security front, but that is an SQLite issue and not reportman.

With regards to SQLitening:
I think I am right in saying you will need to use the SQLite odbc driver with reportman which means you have to bypass SQLitening.

[Dan English]

I don't suppose anyone has any tips to help me connect this to a CSV file (or any other delimited text file)?  I tried for a couple hours yesterday to do this to no avail.

[John Messingham]

Have you tried creating an odbc datasource for the csv file and then use the DAO option in reportman?

[Dan English]

Thanks for the idea.  Just did some searching for it in the ODBC data sources, and found nothing.

I just Googled the topic, and unfortunately it appears that ODBC drivers for text files may have been removed in Windows 7:

http://stackoverflow.com/questions/1953416/microsoft-access-text-odbc-driver-on-windows-7