Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
'Tis a bit late of a response, but worth saying. Reports of Delphi's demise have been bandied about for well over a decade. Although it has dropped in market share during that time, it still is a viable and used language. Our firm uses it in one of our key projects because (quite frankly) nothing else will give us the productivity coupled with the performance we need. John Elrick Fenestra Technologies Timothy A. Sawyer wrote: > If you want something that is Windows based like you describe, why not use > Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if > you need to revise you may have a problem finding a resource. Also consider > the platform independence if that is a concern > Timothy A. Sawyer, CISSP > Managing Director > MBD Solutions > Phone: (603) 546-7132 > Web: http://www.mybowlingdiary.com > Email: tsaw...@mybowlingdiary.com > > > -Original Message- > From: "Rajesh Nair" <rajesh.avit...@gmail.com> > > Date: Sat, 15 Nov 2008 09:23:46 > To: General Discussion of SQLite Database<sqlite-users@sqlite.org> > 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" <m...@singular.gr> > 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: sqlite-users-boun...@sqlite.org >>> [mailto:sqlite-users-boun...@sqlite.org] 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 >> > > ___ &g
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
*Dear Cariotoglou Mike* I was actually waiting for your reply. Ok, No problem. I can understand the work loads. But keep in mind that your utility will be useful to many of the sqlite-users. If you get time ( after two-three months ) please develop it in such a way that I have discribed in previous mail. Myself and someone watching our conversation will be waiting for that. Thanks and Good Luck. Rajesh Nair On Fri, Dec 12, 2008 at 2:21 PM, Cariotoglou Mike <m...@singular.gr> wrote: > No I am not in vaccation, I wish! I am rather busy this period, so no, I > will not be able to do wthat you wanted, for the next couple of months or > so... > > > > From: sqlite-users-boun...@sqlite.org on behalf of Rajesh Nair > Sent: Thu 11/12/2008 8:55 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > > Dear Cariotoglou Mike, > Are you in vaccation? I am attaching the previous emails that I have send. > If you are trying or planning to work on the same please inform, so that I > can hope that some thing is going to happen > > -- Forwarded message -- > From: Rajesh Nair <rajesh.avit...@gmail.com> > Date: Thu, Dec 4, 2008 at 8:13 PM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > > > 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. > PLEASE INFORM > > 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,
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
No I am not in vaccation, I wish! I am rather busy this period, so no, I will not be able to do wthat you wanted, for the next couple of months or so... From: sqlite-users-boun...@sqlite.org on behalf of Rajesh Nair Sent: Thu 11/12/2008 8:55 AM To: General Discussion of SQLite Database Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer Dear Cariotoglou Mike, Are you in vaccation? I am attaching the previous emails that I have send. If you are trying or planning to work on the same please inform, so that I can hope that some thing is going to happen -- Forwarded message -- From: Rajesh Nair <rajesh.avit...@gmail.com> Date: Thu, Dec 4, 2008 at 8:13 PM Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer To: General Discussion of SQLite Database <sqlite-users@sqlite.org> 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. PLEASE INFORM 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
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
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. PLEASE INFORM 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: "Car
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
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 Mi
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
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 >> > ___ > sql
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
You can download the program here http://www.realpointscorp.com/MGFAQUERY1.rar I use this program myself in my applications. I have some ideas of how to increase it's functions but I do not want to waste my time if no-one else is interested as I use my application software to provide the extra functions. I am willing to work with anyone who is willing to try this software and give me feedback. Have a super one! Merv Rajesh Nair wrote: > Hi Merv > > Thanks for your sharing If you can share it through this dissussion > forum then that will be counted as a great work from you. Because those who > are using Sqlite with windows and visualstudio 6 will face the problem of > reporting. They have to depend up on Crystall Reports or some other tools > which will require ODBC/ ADO. > > I have tested OOFile but was not worth enough. So please share what you have > with all of us. I am tired of searching such a thing. > > Rajesh Nair > > - Original Message - > From: "Merv" <[EMAIL PROTECTED]> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Saturday, November 15, 2008 9:03 PM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > >> I have a program for Windows that may help you. It is not open-source >> but it is free to use and distribute. >> It has a simple report function that I am willing to modify based on >> input from users. >> We can continue to communicate this way or you can contact me directly >> at the above address or call 705-646-1076. >> Have a super one! >> Merv >> >> Rajesh Nair wrote: >> >>> Thank You.. >>> >>> Java report builders are available on sourceforge.net and i have gone >>> through it long before. What I am looking is the one which any one can >>> use >>> with VisualStudio 6 or ealier products. It should be handy. Not a >>> complecated one. Simple like "just design and port the report file and >>> then >>> just view and print". Do you have any link which could help all of us. >>> >>> >>> >>> - Original Message - >>> From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> >>> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> >>> Sent: Saturday, November 15, 2008 10:24 AM >>> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >>> >>> >>> >>> >>>> If you want something that is Windows based like you describe, why not >>>> use >>>> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so >>>> if >>>> you need to revise you may have a problem finding a resource. Also >>>> consider the platform independence if that is a concern >>>> Timothy A. Sawyer, CISSP >>>> Managing Director >>>> MBD Solutions >>>> Phone: (603) 546-7132 >>>> Web: http://www.mybowlingdiary.com >>>> Email: [EMAIL PROTECTED] >>>> >>>> >>>> -Original Message- >>>> From: "Rajesh Nair" <[EMAIL PROTECTED]> >>>> >>>> Date: Sat, 15 Nov 2008 09:23:46 >>>> To: General Discussion of SQLite Database<sqlite-users@sqlite.org> >>>> 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 WINDO
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
Hi Merv Thanks for your sharing If you can share it through this dissussion forum then that will be counted as a great work from you. Because those who are using Sqlite with windows and visualstudio 6 will face the problem of reporting. They have to depend up on Crystall Reports or some other tools which will require ODBC/ ADO. I have tested OOFile but was not worth enough. So please share what you have with all of us. I am tired of searching such a thing. Rajesh Nair - Original Message - From: "Merv" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Saturday, November 15, 2008 9:03 PM Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >I have a program for Windows that may help you. It is not open-source > but it is free to use and distribute. > It has a simple report function that I am willing to modify based on > input from users. > We can continue to communicate this way or you can contact me directly > at the above address or call 705-646-1076. > Have a super one! > Merv > > Rajesh Nair wrote: >> Thank You.. >> >> Java report builders are available on sourceforge.net and i have gone >> through it long before. What I am looking is the one which any one can >> use >> with VisualStudio 6 or ealier products. It should be handy. Not a >> complecated one. Simple like "just design and port the report file and >> then >> just view and print". Do you have any link which could help all of us. >> >> >> >> - Original Message - >> From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> >> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> >> Sent: Saturday, November 15, 2008 10:24 AM >> Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer >> >> >> >>> If you want something that is Windows based like you describe, why not >>> use >>> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so >>> if >>> you need to revise you may have a problem finding a resource. Also >>> consider the platform independence if that is a concern >>> Timothy A. Sawyer, CISSP >>> Managing Director >>> MBD Solutions >>> Phone: (603) 546-7132 >>> Web: http://www.mybowlingdiary.com >>> Email: [EMAIL PROTECTED] >>> >>> >>> -Original Message- >>> From: "Rajesh Nair" <[EMAIL PROTECTED]> >>> >>> Date: Sat, 15 Nov 2008 09:23:46 >>> To: General Discussion of SQLite Database<sqlite-users@sqlite.org> >>> 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
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
I have a program for Windows that may help you. It is not open-source but it is free to use and distribute. It has a simple report function that I am willing to modify based on input from users. We can continue to communicate this way or you can contact me directly at the above address or call 705-646-1076. Have a super one! Merv Rajesh Nair wrote: > Thank You.. > > Java report builders are available on sourceforge.net and i have gone > through it long before. What I am looking is the one which any one can use > with VisualStudio 6 or ealier products. It should be handy. Not a > complecated one. Simple like "just design and port the report file and then > just view and print". Do you have any link which could help all of us. > > > > - Original Message - > From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Saturday, November 15, 2008 10:24 AM > Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > > > >> If you want something that is Windows based like you describe, why not use >> Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if >> you need to revise you may have a problem finding a resource. Also >> consider the platform independence if that is a concern >> Timothy A. Sawyer, CISSP >> Managing Director >> MBD Solutions >> Phone: (603) 546-7132 >> Web: http://www.mybowlingdiary.com >> Email: [EMAIL PROTECTED] >> >> >> -Original Message- >> From: "Rajesh Nair" <[EMAIL PROTECTED]> >> >> Date: Sat, 15 Nov 2008 09:23:46 >> To: General Discussion of SQLite Database<sqlite-users@sqlite.org> >> 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 wi
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
Thank You.. Java report builders are available on sourceforge.net and i have gone through it long before. What I am looking is the one which any one can use with VisualStudio 6 or ealier products. It should be handy. Not a complecated one. Simple like "just design and port the report file and then just view and print". Do you have any link which could help all of us. - Original Message - From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Saturday, November 15, 2008 10:24 AM Subject: Re: [sqlite] Sqlite3Explorer Sqlite Report Designer > If you want something that is Windows based like you describe, why not use > Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if > you need to revise you may have a problem finding a resource. Also > consider the platform independence if that is a concern > Timothy A. Sawyer, CISSP > Managing Director > MBD Solutions > Phone: (603) 546-7132 > Web: http://www.mybowlingdiary.com > Email: [EMAIL PROTECTED] > > > -Original Message- > From: "Rajesh Nair" <[EMAIL PROTECTED]> > > Date: Sat, 15 Nov 2008 09:23:46 > To: General Discussion of SQLite Database<sqlite-users@sqlite.org> > 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3Explorer Sqlite Report Designer
If you want something that is Windows based like you describe, why not use Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if you need to revise you may have a problem finding a resource. Also consider the platform independence if that is a concern Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] -Original Message- From: "Rajesh Nair" <[EMAIL PROTECTED]> Date: Sat, 15 Nov 2008 09:23:46 To: General Discussion of SQLite Database<sqlite-users@sqlite.org> 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
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
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