This is not a java question, but I wanted to get some opinions. What are the pros and cons of formating text for reports in java verses a db procedure and reporting engine such as Crystal.
I am currently working on a project where we are formating text for a report in java and then inserting that text into a table for a report to read. I have also worked with Crystal and procedures where Crystal formats all the text. I like formatting it in java because its more flexible and faster, but I don't think this is considered the correct way.
What is the considered the correct way, pattern, of linking java to a reporting engine.