Dear Cariotoglou Mike, I am using VC++ for last 6 years to develop utilities and some small projects. Formerly I was using MS-ACCESS and/or some database classes in my projects. Once I felt the power of sqlite I started using it from 2003 / 2004. After that I have not used any ADO / ODBC for my databases. I have felt the easyness of the moto "NO CONFIGURATION" of sqlite. I have developed some very use full VC++ classes to handle the sqlite database file. I was producing reports with my-own list-view control. Now some simple formated reports are developed but if any changes in the report will result a total EXE replace. That's why I am trying some external utility that could support my EXE to produce simple formated reports. I noticed that your DLL can open some FR3 or some FRF extention files.
THE NEED IS THAT REPORT FORMAT WILL BE SAVED AS AN EXTERNAL FILE OF THE FORMAT THAT YOUR DLL CAN READ AND ALLIGN THE REPORT-VIEWER WINDOW FOR PRINTING. The dataset that you specified can be XML or sqlite database itself. If you are planning to find some time to support sqlite ( as you found some time to develop the Sqlite3Explorer ) then please keep some points in mind while rebuilding the DLL. 1) The dll can be used for both DESIGNING and PRE-VIEWING. 2) The dll can be used to either DESIGNING or PRE-VIEWING according to some parameters passed in to it. ( ie. If the HOST EXE needs only pre-viewing the report then the DESIGNER window must not appear. The designer mode will be shown on demand specified by a param passed to the DLL) If I get such a DLL then I will be using the same for my further projects and will also gradualy replace the method that I was using to show-report. If some others those who are using sqlite with VC++ / VB or some other WIN32 platform programs may try to use it. Thanks Rajesh Nair On Mon, Nov 17, 2008 at 5:18 AM, Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > here is an idea : I might be able to modify the dll to accept datasets in a > different, "standard" format, like XML. > this would imply that your product would need to retrieve data in whatever > format it needs, transform it to my format, > pass it to the dll which will do the design and reporting. it will not as > fast as it is now, but it is definately a solution. you would not have the > source of the dll, but you could use it freely, no IR issues. > > for this to work , the following assumptions must prove correct: > > 1. I originally designed the DLL with portability in mind, so it *coul* be > transformed as I described. since that time, otuehr developers have improved > it. I need to check that they have not introduced dependencies and design > decisions that would nullify its portability. > > 2. that you (or somebody else) actually would benefit from this approach. > f.e do you *like* the report designer (as seen and used from > sqlite3Explorer), or is it just something you came across and thought to > give a try? > > I only point this out, because it will take me at least 10-20 hours to do > this conversion, and it would be a big waste of time (mine) to do this just > as an intellectual exercise. I am not asking for financial compensation > here, just to know that I am actually doing something useful... > > > PS another format that would work, besides XML, and that I already have a > lot of code to support would be the ADO recordset. is this an option for you > ? what language are you planning to use in order to host the DLL, and what > database ? > > > ________________________________ > > From: [EMAIL PROTECTED] on behalf of Rajesh Nair > Sent: Sat 15/11/2008 5:53 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > > Thanks > > So I can't use it... Ok ... But I got some source code of FastReport ( > some > ealier version ) from the internet and it is in Dephi/Pascal. I don't know > both of the tools. Can you use the same code to build a dll which can be > used with other windows programing languages? ( So that no one can raise > their finger aganist me or YOU ). > > I don't want a very efficient-high-end report designer like FastReport. My > clients require very simple reports, which does not contain much > caculations > etc.... If you can help me please. It won't be just for me. Those who are > using SqLite with windows will be happy with a simple report deisgner and > viewer. Also my company is not willing to puchase any product for just > reporting, since our programs are supplied freely along with some of our > products. So an extra cost is not feasible. > > A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS > > > ----- Original Message ----- > From: "Cariotoglou Mike" <[EMAIL PROTECTED]> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Friday, November 14, 2008 7:14 PM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > >I am the author of sqlite3Explorer. Sorry I did not answer you previous > > post, reason is I did not motice it... :( > > > > I don't think what you want is feasible. the reason is this: the Dll > > expects a "dataset" which sqlite3Explorer builds internally, and the > > report engine takes it from there (Design, run, export etc). the dll > > itself does not contain data retrieval code, and relies on the host for > > this. > > > > this is ok, but the catch is here: the dataset format that the dll > > understands is a proprietary format developed by and only used by the > > company I work for. the dll engine is one the prime design/execute > > engines for our commercial projects. > > thus I cannot open-source it. and, since the dataset format in question > > cannot be produced without having access to the proprietary libraries > > we use here, what you want cannot be done. > > > > sorry... > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Nair > >> Sent: Friday, November 14, 2008 2:12 PM > >> To: General Discussion of SQLite Database > >> Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer > >> > >> Hi all > >> > >> How can I use the mkFrxEngine.DLL supplied along with the > >> Sqlite3Explorer. > >> The dll is a report designer and viewer. Please help me to > >> use that dll if any one knows. I asked the same before 10-14 > >> days ago, but didn't get any reply. If even the author of the > >> same is reading this please help me. I want to use it as a > >> report viewer for my sqlite3 database. > >> > >> > >> -- > >> Regards > >> Rajesh Nair > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- Regards Rajesh Nair _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users