Need for Report Designer - SOLVED

Everything else that doesn't fall into one of the other PB categories.
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Need for Report Designer - SOLVED

Post by thanos »

Update:
After a few weeks of serious work and with the first class help of srod on some questions, I am able to say that the Arctic Reports engine is an amazing reporting system.
I can do everything I need easily and quickly.
It is very flexible system, accepts countless parameters, can design on the fly etc.
I think that is no other tool with the same quality in this price.
srod must update it and continue to improve it!
It's amazing tool.
Regards.

Thanos




Hello.
I need a report designer for a small business application that I have design.
Although I am a licensed user of the Arctic Reports, I had not used before.
Now, i need to use it, but I saw that srod seems not to give too much attention on its development and because of his limited time he is not be able to solve some issues quickly.
Can anyone suggest something light (like the Arctic Reports), preferably free or low cost.
The report generator must not need administrator rights to install it or registration (via regsvr32).
It should read SQLite databases directly without having any odbc driver and certainly the print out could be called through the program code with several parameters.
Now implement the prints html code and use the webgadget to display, but because i have to schedule multiple reports, this solution is painful.
Any suggestion is welcome.
Thanks in advance.

Thanos.
Last edited by thanos on Fri Jun 26, 2015 12:03 pm, edited 3 times in total.
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
srod
PureBasic Expert
PureBasic Expert
Posts: 10589
Joined: Wed Oct 29, 2003 4:35 pm
Location: Beyond the pale...

Re: Need for Report Designer

Post by srod »

Hi,

the issue you reported is a strange one - my gut feeling is that you may be doing something wrong (though I could of course be wrong on that score). I certainly cannot reproduce the problem and I have tried with several versions of PB - including 5.31.

Send me the report file and, if possible, the SQLite database and I will take a look over the weekend.

Stephen.
I may look like a mule, but I'm not a complete ass.
User avatar
blueb
Addict
Addict
Posts: 1121
Joined: Sat Apr 26, 2003 2:15 pm
Location: Cuernavaca, Mexico

Re: Need for Report Designer

Post by blueb »

Though not a 'Visual Designer', you might give "ddoc Print and Preview" a try.
Well worth the $25 spent and DoubleDutch made it even a better deal.
(There is an evaluation version available)

see: http://www.purebasic.fr/english/viewtop ... 01#p301001

Current web page is still valid: http://www.greatwebdivide.com/software.htm

-blueb

PS - I'm using on Win 8.1 with no problems
- It was too lonely at the top.

System : PB 6.21(x64) and Win 11 Pro (x64)
Hardware: AMD Ryzen 9 5900X w/64 gigs Ram, AMD RX 6950 XT Graphics w/16gigs Mem
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer

Post by thanos »

srod wrote:Hi,

the issue you reported is a strange one - my gut feeling is that you may be doing something wrong (though I could of course be wrong on that score). I certainly cannot reproduce the problem and I have tried with several versions of PB - including 5.31.

Send me the report file and, if possible, the SQLite database and I will take a look over the weekend.

Stephen.
Thanks a lot for your reply Stephen.
I sent them to you.
Regards

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer

Post by thanos »

@blueb
Thanks you very much.
I did not know it. I will give it a try.
Regards.

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
srod
PureBasic Expert
PureBasic Expert
Posts: 10589
Joined: Wed Oct 29, 2003 4:35 pm
Location: Beyond the pale...

Re: Need for Report Designer

Post by srod »

thanos wrote: Thanks a lot for your reply Stephen.
I sent them to you.
Regards

Thanos
Received thanks.

I just ran it with PB 5.31x86 and it was absolutely fine. I cannot reproduce the problem at all.

Which version of Windows are you running?
I may look like a mule, but I'm not a complete ass.
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer

Post by thanos »

@srod
I tested it at Windows 7 and Windows 8 in both 32 and 64bits and i faced the same problem when i try to run report\InvalidateReport() statement.
Purebasic compilers 5.31x86 and 5.24x86 LTS
Regards

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
srod
PureBasic Expert
PureBasic Expert
Posts: 10589
Joined: Wed Oct 29, 2003 4:35 pm
Location: Beyond the pale...

Re: Need for Report Designer

Post by srod »

I have sent you the files I used to run your little program - including the nxReport dll. Worth ruling out a corrupted library file on your end.

If this fails then can you try running one of the demo programs. Use the "ChildSubreportsWithGroups" demo programs. You will of course need to add the nxReport header file and .lib and .dll files to the folder.

Run the "Demo_CreateSaveReport.pb" program first to create the report file. Then, if all is well, run the "Demo_LoadPreviewReport.pb" program. If all runs fine then stick a report\InvalidateReport() call in there. Let us see is this then crashes out?

If not then there is something peculiar to your report. Without experiencing the crash here though it is going to be difficult to figure out what is going on?
I may look like a mule, but I'm not a complete ass.
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer

Post by thanos »

@blueb
I looked at it.
From a cursory glance, it is fast but I think he has some issues with the appearance. Each time you run a report needs resize its window just to display the contents.
Interestingly, but compared to the Arctic Report it looks like ice age :D
Before many years I had written a similar ocx for use by Visual Basic 6 using its PictureBox control.
Regards.

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer

Post by thanos »

@srod
Everything is okay :D
Thank you very much.
Regards

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
srod
PureBasic Expert
PureBasic Expert
Posts: 10589
Joined: Wed Oct 29, 2003 4:35 pm
Location: Beyond the pale...

Re: Need for Report Designer

Post by srod »

thanos wrote:@srod
Everything is okay :D
Thank you very much.
Regards

Thanos
If it wasn't going to be a simple fix then it was going to be one horrendous problem to solve! :)

Any idea what the problem was?
I may look like a mule, but I'm not a complete ass.
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer

Post by thanos »

srod wrote: If it wasn't going to be a simple fix then it was going to be one horrendous problem to solve! :)
Any idea what the problem was?
I had 2 problems:
1. A corrupted dll
2. An older version of nxReport_HeaderFile.pbi
Now everything is running smoothly!
As i wrote to my email the Arctic Reports suite is really amazing. I checked some other solutions (in the same level), but they seem like ice age in comparison to Arctic Reports.
Thank you for your support.
My best regards.

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
thanos
Enthusiast
Enthusiast
Posts: 423
Joined: Sat Jan 12, 2008 3:25 pm
Location: Greece
Contact:

Re: Need for Report Designer - SOLVED

Post by thanos »

After a few weeks of serious work and with the first class help of srod on some questions, I am able to say that the Arctic Reports engine is an amazing reporting system.
I can do everything I need easily and quickly.
It is very flexible system, accepts countless parameters, can design on the fly etc.
I think that is no other tool with the same quality in this price.
srod must update it and continue to improve it!
It's amazing tool.
Regards.

Thanos
» myPersonal Banker :: Because you do not need to have a master degree in economics in order to organize your finances!
Post Reply