1 person found this helpful
Once you have the data in the underlying business objects, they can be used for a variety of purposes including reporting. We indeed used VBCS for some light weight reporting for one of our customers and this is what we were able to deliver:
- Top Level Reporting dashboard that has graphical as well as tabular data
- Build advanced sorting and filtering on reporting data
- Build drill-downs to look into detailed view
What we couldn't do very well was to mash data from different sources i.e. when part of the data is in business objects and if you have to query something else from external systems.
Additionally we were also able to create an ExportToExcel feature utilizing a custom component to export tabular reporting data.
I would just suggest that you use VBCS for some light weight reporting instead of a full fledged reporting too.
You are welcome.
I am not sure if you know but Oracle has released VBCS 2.0 which is advanced and a better version of VBCS. This also opens endless opportunities to implement a number of use cases in VBCS. For sophisticated reporting layouts you can import Oracle JET recipes into VBCS with ease.
What component did you guys use for ExporttoExcel feature?
I have a similar requirement for reporting, more like a statement for export.