Hi Michael,
"Done this" is overstating it a bit.
I have used A4D in the past to create reports from data and even
created a full fledged report editor in Active4D (it was a client
project so I cannot show it).
But first things first:
Why use SRP at all?
I need to replace Super Reports asap, as my clients want to use
unicode and i need a flexible reporting solution.
Fact is: SRP will not be available as a "real" V11 PlugIn and will not
support Unicode in the foreseeable future!
I have used A4D not only to create reports, but also to create
invoices, shipping lists, etc, all ith complex layout, page breaks,
printable, etc. Good knowledge of CSS and some browser specific
extensions is required, but none of it is rocket science.
In this light, using A4D for reporting is way more flexible than SRP
ever was, Only thing missimg is the graphical report editor.
I guess thoug, you can always use DreamWeaver or the likes to create
your layout before adding hte active code (btw, my favourite - and
only - tool for creating web pages is TextMate).
So all you would have to do is send the required values to the server
so the a4d page can execute, and get th rsulting html page back in a
blob, even better, just launch it into a web area, from where you then
"collect" the resulting file.
Using this aproach you would not need to actually transfer anything
from the server to the client.
If you do want to it in "silent" mode, yu could always use a HTTP call
(Methods available from the 4D code library).
Anyway, this is the aproach I will realise in my application.
Cheers
Alex
We have a rather large Mac 2004 client-server database for a client
that uses SuperReportPro and Footrunner for producing reports. They
have over 10 applications running in A4D for data collection and other
uses.
Without going into the sordid details, we are done with using SRP and
FR for producing complex reports. What we envision is utilizing A4D
as a general purpose scripting engine to produce the data we need and
then SRP (or other) as a layout template for delivering the reports on
the client.
So, since the a4d files live on the server, I was wondering if anyone
has done something similar and has had experience with executing the
files on the server and sending the resulting data back to the client.
While executing the needed a4d report file on the server is
straightforward, what I'm trying to figure out is the best way to send
back all the variables that I need once created in the a4d space. Do
I pack them all into a blob and send them to the client where they are
simply unpacked? Or use objecttools?
I was thinking there must be some tool(s) for doing this generically.
Does anyone have direction for me?
Thanks in advance,
Michael Check
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/