Forums

by Mike Hoorens >> Wed, 24 Feb 1999 6:32:40 GMT

Gidday.

I am curious as to the options available to a Jade developer to allow clients/users to write their own reports.

To date we have, through various projects, done all of these:
- write Jade report writer in Jade.
- use Crystal Reports to acces Jade through ODBC.
- use Jade to access and run Crystal reports (using DLL).
- write all reports in Jade.

What other ways have you dealt with this issue?
What other report writers were used?
Has anyone written a generic Query Generator?

Cheers, Mike.

Mike Hoorens

by Allistar Melville >> Thu, 25 Feb 1999 12:23:36 GMT

Gidday.

I am curious as to the options available to a Jade developer to allow clients/users to write their own reports.

To date we have, through various projects, done all of these:
- write Jade report writer in Jade.
- use Crystal Reports to acces Jade through ODBC.
- use Jade to access and run Crystal reports (using DLL).
- write all reports in Jade.

What other ways have you dealt with this issue?

We have written a report writer in Jade, which allows reports to be designed by the user and run in a task queue fashion, or directly. Features include:
-able to select attributes (straight of a class of from a reference path) from the database
-able to select methods on classes
-enhanced print preview lets you print ranges of pages
-save to file, or email a report directly
-can print a report in either graphics format or text (means
dot-matrix printers don't go painfully slow)
-can include shapes or bitmaps into a report
-full text style control (font, size, colour etc.)
-landscape/portrait
-can involve complex quieries and sorts
-can hide/show fields based on conditions
-can pass user parameters to a report which can then be used in queries/sorts etc.
-reports can have multiple "profiles" which means different sort
sort order or different queries. Save having to write multiple
reports.

What other report writers were used?

We considered using third party report writers but decided that it wouldn't be flexible enough.

Has anyone written a generic Query Generator?

The query used in the report writer also runs stand alone. I think
this is what you mean.

For any more info about this, feel free to send me an email.

Regards,
Allistar.

------------------------------------------------------------------
Allistar Melville (BSc) Home: allistar@ihug.co.nz \_
Software Developer Work: allistar@focussoft.co.nz </'
Auckland, NEW ZEALAND /)
Web: http://homepages.ihug.co.nz/~allistar/ (/`
`
"God is the adult's pacifier, offering solace to those
who find reality too much to bear." ------------------------------------------------------------------

by Craig Shearer >> Sun, 28 Feb 1999 18:33:41 GMT

I think that this post illustrates a definite weakness in JADE's feature set regarding adhoc querying and reporting - something that need addressing, hopefully by Cardinal!

Craig.