
Creating Dynamic Reports - Using Crystal Reports Engine
Kiran,
I'm afraid I can't answer your question about the Crystal Reports Engine.
But based on experience in building a dynamic reports generator, I would
wager that producing such a tool in Crystal (or any environment) is much
more complex than you might imagine.
My company has produced a software package, Reporting Studio, that may meet
your needs. Essentially Reporting Studio allows the end-user to point and
click to select, sort, group and filter on any field in your database -- to
produce a presentation quality report. For filtering, we include all key
values from your database in a hierarchal treeview which has multi-select
capabilities. We (or you) set up an automated procedure to convert your
production data to a denormalized (cube-like) structure for reporting so the
user doesn't need to have any knowledge of tables, joins, unions, etc. More
advanced features include the ability to combine multiple reports onto one
page (a FactSheet); combine multiple reports into a Report Book with a table
of contents and consecutive page numbering; drilldown capabilities;
wysiwyg export to Excel; and integrated graphics. We also have a looping
function so that you could, for example, create a Report Book and specify
to loop by account -- to create a book for each account.
Reporting Studio is written in Visual Basic and uses Access for its backend
data.
Check out our web site and let me know if you would like more info.
--
Allan Thompson
FieldScope LLC
Measurement and Reporting Systems
www.fieldscope.com
860.242.4184
Quote:
> Dear All,
> We are planning to develop simple reporting tool, which
> can build a report dynamically.
> For this, we are planning to use crystal reporting engine as the base.
> Using crystal report API, can we build the reports dynamically???
> Can you send me some tips or samples on this to proceed further.
> Thanks in advance...
> Regards,
> Kiran Nakhate