ActiveReports

[Foz]

I'm just wondering: has anyone had any luck with using the COM ActiveReports suite with PureBasic?

I've done a search in the forums for ActiveReports, but nothing is listed.

Now, yes, I know that srod has a reporting tool, however, I require pdf & excel exports from a report, something that AR does nicely.

[srod]

Doesn't ActiveReports require .Net ?

[Foz]

The newer ones do, but it was originally a COM package for use with *blech* Visual Basic 5 and 6.

The COM package is still available (last update, 2008), and it does fit the bill with what I need it to do.

[Kiffi]

I'm just wondering: has anyone had any luck with using the COM ActiveReports suite with PureBasic?

no problem! Give me a license and i will write a sample-code for you.

Greetings ... Kiffi

[sphinx]

I used to use (Actually still using) ActiveReports with my VB6 LIS (Lab Information System) program, it is great but right now I am switching to PureBasic + Arctic Report.

I get tired of VB runtime and more importantly the future of VB6 if there is any!, as I heard it won't work with Windows 8 and it already gives me headache with Windows 7 and some of my clients complain about some strange behavior on Windows 7 (this makes me very worry and tension).

'Dot Not' aka .NET? I hear you say......NO THANK YOU!
Unless of course everything in the future will be .NET and Microsoft get rid of API which I doubt but who can trust Microsoft?! they already executed millions of VB5/6 developers.

Arctic reports is the main reason I wiped the dust over PureBasic and started using it, Reports are the main and most wanted feature of my LIS program although I am waiting Stephen to finish what will be the spark to fully port my VB6 to PB and I mean by that Bar Code support (39 or 128) and the Charting module so I am shouting and saying it very loud..... STEPHEN HURRY UP PLEASE

Sorry for Hi jacking your thread Foz, but I can't help it....I need some answers
Fred :
1- Any plans for Real Visual PB or at least close to perfect Visual Designer (Event Driven)?

Stephen :
1- When will you finish Bar Code and Charting support?
2- I know the nxResize source is available but why not you add the option to resize the gadget font too, I already have my own home made ActiveX control which has the same functionality as nxResize but adds more and font resizing is one of them.

Anyone :
What is your opinion about SQLitening for CLient/Server program?
I tried http://thecommon.net/8.html with VB6 and it is great and reliable even with 10 concurrent users (writing) and about 50-100 for reading/viewing but I have to say goodbye to VB!
PostgreSQL is great but I do not want big installation for my program and Admin/Config headache for my clients or what do you think?

[srod]

@sphinx : I'll reply via pm so as not to hijack this thread any further. This thread is about ActiveReports, not Arctic Reports.

[sphinx]

Thanks Stephen and all the best

[Foz]

I'm just wondering: has anyone had any luck with using the COM ActiveReports suite with PureBasic?

no problem! Give me a license and i will write a sample-code for you.

Greetings ... Kiffi

You can just download it and use it - it just adds an evaluation message to all the reports until it is licensed. That is another reason why I'm interested if anyone has gotten it to work - apparently the host exe has to be licensed for it to remove the message.

[Yogi Yang]

What is your opinion about SQLitening for CLient/Server program?
I tried http://thecommon.net/8.html with VB6 and it is great and reliable even with 10 concurrent users (writing) and about 50-100 for reading/viewing but I have to say goodbye to VB!
PostgreSQL is great but I do not want big installation for my program and Admin/Config headache for my clients or what do you think?

SQLitening is good but it is primarily targeted for Power Basic developers so PureBasic developers are its priority. Paul is a good developer is primarily focused on Power Basic only . I wish he would pay attention to PureBasic and release his fantastic IDE (Firefly) for PB...

As for dhRPCServer. We use it in two medium size project which are developer in VB6 and are running without any problems for a year now.

As you may be knowing that dhRPCServer is open source and is based on dhRichClient-Toolset so what you can do is recode the server part (using the toolset) in PureBasic. This is just my thought!

I know that dhRichClient-Toolset is developed in VB6 and I am waiting for the developer to release it as open source .

I get tired of VB runtime...

Probaly you are not aware of RegFree way of registering ActiveX Objects and using them without the need for the user to have Administrative privileges. Check out thecommon.net/10.html

I get tired of VB runtime and more importantly the future of VB6 if there is any!, as I heard it won't work with Windows 8

As for this I think you are dreaming.... MS can never remove OLE from Windows as it is its very back bone. If MS wishes to remove OLE it will have to rewrite the whole OS from scratch that is an impossible task event with all the fund that it has at its disposal. So rest assured that VB6 programs will run properly in future Windows OS be it 7 or 8.

What may be the problem is the 64bit Windows world... but I have heard that there are a few developers who are trying to develop a way to allow VB6 to consume x64 OLE/ActiveX components...

HTH

[sphinx]

Probaly you are not aware of RegFree way of registering ActiveX Objects and using them without the need for the user to have Administrative privileges. Check out thecommon.net/10.html

I am aware of it but that is not what I meant by runtime...I meant the hazy future of VB6 runtime support on future windows OS, please have a look here :
http://news.softpedia.com/news/Visual-B ... 5474.shtml

As for this I think you are dreaming.... MS can never remove OLE from Windows as it is its very back bone. If MS wishes to remove OLE it will have to rewrite the whole OS from scratch that is an impossible task event with all the fund that it has at its disposal. So rest assured that VB6 programs will run properly in future Windows OS be it 7 or 8.

I am afraid I am not, how do you explain that my LIS does not work correctly when it comes to the RightToLeft property, all my menu and texts are now displayed from LeftToRight which is a real pain in the ***
Although I got it fixed but this worries me a lot of any discovered flaws in the future, please have a look here http://blogs.msdn.com/b/michkap/archive ... 62894.aspx
Some strange behaviors is happening with my LIS running Windows 7 (e.g. Sometimes Combo boxes get populated and sometimes not, the combo box may be drop down fast and other time take a hell of time to drop down...etc
Well now this is happening with Windows 7! how about Windows 8?! I think MS will break a lot of VB6 and accordingly my LIS

As for dhRPCServer. We use it in two medium size project which are developer in VB6 and are running without any problems for a year now.

Just out of interest :
How many concurrent users are using your medium size projects?
How many records added at the end of the day to the database?
Any corruption/backup precaution?

Thanks Yogi

[Yogi Yang]

I am aware of it but that is not what I meant by runtime...I meant the hazy future of VB6 runtime support on future windows OS, please have a look here :
http://news.softpedia.com/news/Visual-B ... 5474.shtml

Thanks for this link. It is informative.

how do you explain that my LIS does not work correctly when it comes to the RightToLeft property, all my menu and texts are now displayed from LeftToRight which is a real pain in the ***
Although I got it fixed but this worries me a lot of any discovered flaws in the future, please have a look here http://blogs.msdn.com/b/michkap/archive ... 62894.aspx
Some strange behaviors is happening with my LIS running Windows 7 (e.g. Sometimes Combo boxes get populated and sometimes not, the combo box may be drop down fast and other time take a hell of time to drop down...etc
Well now this is happening with Windows 7! how about Windows 8?! I think MS will break a lot of VB6 and accordingly my LIS

That is truly strange behavior but I have never faced such strange behavior for any of our apps. To be frank with you we tend to use third party ActiveX controls a lot. Our favorite is ComponentOne Studio. So this may be the reason why we are not getting any problems in Win Vista as well as 7.

Till now we have had problem with only one app that is developed in VB6. This app does not work properly under 64Bit version of Windows. But this understandable as we are using Hooking mechanism which is 32bit.

As for dhRPCServer. We use it in two medium size project which are developer in VB6 and are running without any problems for a year now.

Just out of interest :
How many concurrent users are using your medium size projects?
How many records added at the end of the day to the database?
Any corruption/backup precaution?

In one software which is a semi ERP like system with full featured Accounting, there are 40 concurrent users at any point of time. The data file has also become huge, 700+ MB!

The other software is for Share Trading Market. This software processes a lot of data and then writes it to multiple tables. Approximately it writes around 40 rows/records to 3 different tables per second per client. This software is run from 3 terminals at any point of time. If there is spike in share market then it will process and write more data!

The serve is backed up by UPS so there is generally no data loss that we have faced except once when the HDD of server crashed. At this particular instance our client lost 20 days of work. Thank god they had backed up date from the server to a net work storage.

Hope this gives you some confidence on dhRPCServer.

HTH

[sphinx]

Thanks Yogi for the info...it is helpful
I PMed you.