This week's giveaway is in the OCPJP forum.
We're giving away four copies of Practice Tests for OCP Java 17 Certification Exam (1Z0-829) and have Paul Anilprem on-line!
See this thread for details.
Win a copy of Practice Tests for OCP Java 17 Certification Exam (1Z0-829) this week in the OCPJP forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

XML and Reporting

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can XML be utilized to write reports from a website using MySQL or equivalent databases? I am looking for an alternative to Crystal Reports.
 
Ranch Hand
Posts: 5040
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am not too familiar with Crystal Reports, but depends
on what you want to call a Report....
You could certainly take an XML file representing the data
and using a style sheet format it to any form of 'report'
you want.
Hope I am not missing your point.......
- m
 
Ranch Hand
Posts: 3178
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Rex Ashworth:
Can XML be utilized to write reports from a website using MySQL or equivalent databases? I am looking for an alternative to Crystal Reports.


I've ever about the Crystal Reports that it is a great tool for generating reports... Since it is totally dedicated to the report and related things, I think XML is not comparable to that Crystal Reports... I do believe that Crystal Reports possess better ability to handling report-related stuff... Even though XML can generate some kind of report, it won't be as good as Crystal Reports, which is pretty famous among report generating tools...
 
Madhav Lakkapragada
Ranch Hand
Posts: 5040
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think XML is not comparable to that Crystal Reports...
Well, if that is the ONE thing they do, then they better be
good at it, esp. in this age. That said, there are other
factors that drive strongly why a home-grown XML/XSLT tech.
is more useful.
Imagine your customers reaction when they need to purchase
third-party licenses to use your product. There are certainly
positives and negatives. Don't get me wrong, I am by no means
suggesting Crystal Reports is not useful, I have no clue what
it does.
XML may not be comparable, but when it comes to 'Purchase Orders'
and 'Licensing' $$$ counts. Hence, you can't take sides.
- m
 
Ko Ko Naing
Ranch Hand
Posts: 3178
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Madhav Lakkapragada:
XML may not be comparable, but when it comes to 'Purchase Orders'
and 'Licensing' $$$ counts. Hence, you can't take sides.


Yes, Madhav, you are right in this case... The $ is an important factor in deciding which one to choose... I hope that XML might be replacable to Crystal Reports in the original poster's situation... If so, he should better think of XML, rather than Crystal Reports, which will cost $ a lot...
 
author
Posts: 11962
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Rex Ashworth:
Can XML be utilized to write reports from a website using MySQL or equivalent databases? I am looking for an alternative to Crystal Reports.

XML can be utilized as a part of report generation, but it doesn't cover the whole report generation.
Here's an example scenario:
- Java code #1 reads the database and writes an XML file representing the contents
- Java code #2 applies an XSL stylesheet to the XML file to transform it into XSL-FO compliant form
- Java code #3 hands the XSL-FO document to an XSL-FO processor, which produces a PDF document
In this scenario, XML has an essential role. However, tools like Crystal Reports work on a higher level of abstraction, such as providing a GUI for describing a report (pulling information from a database and placing it somewhere on a page template) and "executing" the report to produce the actual PDF document, for example.
 
Ko Ko Naing
Ranch Hand
Posts: 3178
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Lasse Koskela:

Here's an example scenario:
- Java code #1 reads the database and writes an XML file representing the contents
- Java code #2 applies an XSL stylesheet to the XML file to transform it into XSL-FO compliant form
- Java code #3 hands the XSL-FO document to an XSL-FO processor, which produces a PDF document


Nice steps... It's worth to note down, Rex Ashworth, if you are thinking about XML to replace Crystal Reports...
 
reply
    Bookmark Topic Watch Topic
  • New Topic