Writing Reports

[kiwidave]

Hi all,

Firstly my apologies if this has been answered elsewhere, but I couldn't find much in my forum or online searches...

I am writing an application using SQLite as the database (although I could use a different one if needed), and need to create a moderately complex report from this data - necessitating subreports and dynamic images either from a blob field or local folder.

I had originally thought of using Arctic reports, but there doesn't seem to be any detailed documentation available and I just haven't got the time to figure this out trial-and-error, and the fact that it is currently unsupported means I am hesitant to commit to this. However I cannot find any other viable alternative. Basically I just want the user to press a button and a report will either come up in a preview window (i.e. similar to what Crystal reports does), or prints directly.

Does anybody have suggestions on how I would best progress on this please.

...and just as a side note, I have tried running the demo reports from the Arctic reports site, but they don't seem to be working properly, currently it's crashing with an invalid memory access error....

Thanks very much everyone,

David

[srod]

Hi David,

yes there were some bugs in the version of Pyrex which the trial version was based on. I have uploaded a new trial version of Pyrex and, well, all the test reports seem to work fine here.

You're welcome to try again.

[Neil]

@kiwidave

Arctic reports (Pyrex) is definitely the way to go.

Does take a bit of learning, but well worth the effort. Couldn't imagine writing reports without it (and wouldn't even know where to start) !!

Part of the learning curve is due to the fact that it is very powerful and therefore complex - but it is always logical.

@srod

Does your post mean that we should update paid version of Pyrex ??

Thanks,

Neil

[srod]

Hi Neil,

the release version of Pyrex is fine; that was updated some time ago.

I think kiwidave's problem is that he is trying to use the 32-bit nxReport dll with PB x64. That is the only way I can repeat the crash anyhow.

[kiwidave]

Hi all,

Thank you very much for your suggestions, and especially srod for the fantastic additional support outside of this topic. My original problem was, as srod suggested, using the 32bit dll on PB64 bit. I deleted and reinstalled as PB32 and all worked ok.

David