This is an example of reportman with FireFly. Reportman is free, has a designer of reports and allows to connect to a database. I attach the project that I have developed as example.
Example is 2.6v version of reportman
Reportman's use is very easy.
They can unload it from:
http://reportman.sourceforge.net/
Install before run example.
I installed the program and downloaded the OCX. Works good - thanks for sharing your work.
Not sure that I am overly excited about having to distribute a 7.5 meg OCX with an application though. :)
Thanks, Maria.
QuoteNot sure that I am overly excited about having to distribute a 7.5 meg OCX with an application though.
Nowadays, I believe that the size of the application is not so important, against the possibility of giving to the client a powerful tool of design of reports and inclusive that could create his own reports.
I have used enough this tool with FireFly, but with the version 2.x I was obtaining a problem on having closed the application (memory error). Now with the version 3.x already no message of mistake goes out for me. It is because of it that I encourage to share with you of this nice tool.
My names is Marco Ruiz. Maria Beytia is the name of the wife of my chief and owner of the credit card with which we acquire FF3.x
Thanks.
It is always good when the financial adviser/accountant allows you to purchase new toys. I have cards in my own name and still have to beg.
QuoteIt is always good when the financial adviser/accountant allows you to purchase new toys. I have cards in my own name and still have to beg.
:-[
I am a dependent worker. FF3 it was bought for the company where I am employed. I, as your also I have my own cards of credit.
Marco, I appreciate that you want to share this code with us. Guess it is useful for some of us. Of course it is not useful for ALL of us but that doesn't matter. I encourage you to share code here.
Wilko
Ah, I misunderstood the "of my chief" portion when reading the first time and thought it was saying the card was your wife's and that is how you bought it. Hopefully more businesses see the benefit of it.
Thanks for providing this to the free software community!
Has anyone tried to run this on Windows 7 64-bit?
I've installed reportman 2.9 (designer only), downloaded reportman.ocx and placed it in the example project's release folder, and compiled. Compiles fine, and the main window shows. But when I click on "Print Preview Reportman", nothing happens.
Hi Dan,
You probably need to register the OCX. Go to the command prompt and type REGSVR32 REPORTMAN.OCX.
Ok -- I copied reportman.ocx into C:\Windows\System32, and ran "regsvr32 reportman.ocx". I got an error as follows:
"The module "reportman.ocx" may not compatible
with the version of Windows that you're running.
Check if the module is compatible with an x86 (32-bit)
or x64 (64-bit) version of regsvr32.exe."
Perhaps this isn't 64-bit compatible?
As far as I know, in a 64 bit operating system, System32 is for 64 bit DLLs. You must place the 32 bit OCX in the Syswow64 folder, and also register it using the RegSvr32 program located in that folder (the default one, located in System32, is for 64 bit applications).
Thanks Jose... got it working as you instructed! I haven't done any real development on a 64-bit OS yet, so I wasn't aware of these directory differences.
I initially got an error about "DllRegisterServer failed", but remembered that I wasn't Administrator while running that command. For anyone who needs to register this (or any DLL/OCX) on Vista/Windows 7, remember to do it with administrative privileges!
Will this report designer work with SQLitening/SQLite databases?
Yes. This report works with SQLite, SQLServer and more.
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.
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.
Have you tried creating an odbc datasource for the csv file and then use the DAO option in reportman?
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