Not wishing to appear biased, but... I use both Borland's Delphi and C++ Builder. Both use a common DB access known as DBExpress. I have the option of using any number of third party report writers, including the biggie Seagate Crystal Reports, plus the two "internal" report writers supplied with the Borland products.
For you Linux junkies there is Borland's Klix, (Delphi on a real OS.) Perhaps you could choke down enough Pascal to use it. At least it ain't Visual Basic et. all :-) Actually I have not done it but I think it (Klix) supports both C++ and Object Pascal. Fred -----Original Message----- From: Griggs, Donald [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 8:43 AM To: 'Ron Aaron'; [EMAIL PROTECTED] Subject: RE: [sqlite] Report writer Ron Aaron [mailto:[EMAIL PROTECTED] wrote: Does anyone have a generic report writer which could be used with SQLite? ============================ Hi Ron, Are you developing for Windows? If so, I don't know if one of these might be of help: 1) I see there's a commercial, but not expensive product (US$40), SqliteManager, that has a basic report capability based on (plain text) template files. I copied an example template at the end of this email. Templates and SQL are stored in the sqlite database itself. See http://sqlabs.net (and this has no apparent connection with an open-source, French-based PHP project of the same name at http://sqlitemanager.org). And *I* have no connection with either. ;-) 2) There's a nifty open ODBC driver for SQLITE from Germany at: http://www.ch-werner.de/sqliteodbc/ If perhaps your clients already have M$ Excel or Access and familiarity with them, they can use this to link directly to your sqlite database. 3) Using the ODBC driver above, I think you can use OpenOffice.org's great open-source software to link the data instead of using a commercial package, using either the spreadsheet application or using a form from within the word processor. Regards, Donald Griggs [Not writing on behalf of my company] ============================================================================ Example of template which will dump entire table into an html file. Other types of output accommodated. (Taken from sqlabs.net's "Reports ReadMe.txt" contained in demo download. I've changed the brackets on the two HTML tags to possibly prevent some mail systems from over-interpreting this template) [[html]]<body> <table> <tr> [LOOPCOLUMNS]<td><b>[FIELD.LABEL]</b></td>[/LOOPCOLUMNS] </tr> [LOOPROWS] <tr> [LOOPCOLUMNS] <td>[FIELD.VALUE]</td> [/LOOPCOLUMNS] </tr> [/LOOPROWS] </table> </body> [[/html]] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
