Skip to Content
0
Former Member
Oct 07, 2009 at 06:22 AM

Chosing data source

24 Views

Hi all,

I am leading the development of a new LOB system for SAP Business One platform. We have decided to use CrystalReports as our reporting engine, and we are now constructing the reporting development and maintenance method.

We have some processes that perform calculations and give us a collection of objects. As it turns out, we would not be working with .NET objects as report data source (support is limited). We have to pick one of the following options:

1. Construct report over a data set - pros: No DB access required; cons: Creating and maintaining data sets, More complex infrastructure work is required to let user edit RPT files

2. Write data back to DB and construct report over it - pros: Easy report authoring for users; cons: Creating and maintaining DB tables,

First, I would like to get any comment whatsoever about this situation.

Second - PERFORMANCE which one is expected to be more performat? Option 1 report generation would be slow as the report engine cannot use the DB power to group, sort, etc'. In option 2 we would have to write the data back to the database. Would either one be defenetly or probably better?

Asher