Hi!
Thank you both for the reply. I would gladly go to the conference but I'm
over the 'big water' - Europe, so I will just keep reading from the URL you
mentioned, and maybe after your analysis you would like to share the results
with the rest of us. I would gladly get rid of the Crystal, but we are deep
into it, and unfortunately, have no time for testing and trying new things.
Maybe a stored procedure that will create a view on the fly with the
corresponding table would do the trick - but I would have to test it how
fast it will be. And the problem is that so far we didn't use any stored
procedures following the idea of the portability of the application to
another database - not Oracle. Has any one tested the speed of create or
replace SQL statement and the stored procedure with the same action - in
fact do I need the stored procedure or I can just execute the SQL statement?
Thank you all, for your time,
Lena Trajkovska
-----Original Message-----
From: Neil Giarratana [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 18:12
To: CF-Talk
Subject: RE: One Crystal report with variable name of the table
Are you locked into Crystal? We found that Crystal forced us to do things
the "Crystal" way as opposed to the flexibility of coding the reports
ourselves. We're now exploring dynamically generating PDF reports using XML
with FOP. This allows us to develop the reports from scratch in any layout
we want. Admittedly, this can be a complex solution; we're working on the
feasibility analysis now but if it holds up, it'll allow us to create a
report for web and pdf out of the same XML document using CF. Therefore,
the report would be nothing more than a CF template and you could determine
the table name using a variable posted from a previous page. For more info,
check out http://xml.apache.org/fop/index.html. I'll be presenting an
example of this at the CFSouth conference if you're anywhere near Orlando.
Regards,
Neil
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
