Alfresco is a highly scalable content management system where you can store millions of documents and perform many workflow tasks. Alfresco provides a basic dashboard to list and track the tasks. You can also configure Alfresco to provide full audit trail information.
However, Alfresco does not provide a strong "Reporting" framework out of the box. We integrated Crystal report with Alfresco CMS for one of our customers and here is the information -
Brief Introduction about Crystal Report:
Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. It is an intuitive reporting solution that helps you rapidly create flexible, feature-rich, high-fidelity reports and integrate them into your web applications.
Benefits
- Leverage professional reporting
- Empower end users to explore reports with on-report sorting and parameters
- Minimize IT and developer effort
- Develop powerful data mashups
- Embed professional-looking reports in Java applications
- Tailor your solution by adding report management and viewing tools
Following are the steps to execute report in alfresco.
Create Report
First you need to create a report using Report Designer. Crystal report provides a flexible way to design a report using tool called Report Designer. You can download crystal report 30- day evaluation copy from following link, Download Crystal Report
Environment setup
Copy Java Reporting Component (JRC) and necessary support jars
Copy dependent directory (which includes UI related stuff)
Put the CRconfig.xml into your classpath
Calling a Report
Write one web page which will execute the report using Crystal Reports rendering engine.
- By
Tejas Kanani
Consultant at CIGNEX, India Office
