The information I learn here I will thankfully post in the AtomsFramework WIKI. In General what are good strategies for reporting and AtomsFramework. Can packages such as Crystal Reports (CR) be integrated with Atoms framework? Typically Crystal Reports directly accesses the SQL server. But I was wondering is there is any strategies for integrating CR with AtomsFramwork?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm not sure what you mean by direct integration of Crystal with the AtomsFramework so I'll explain how I've done things in my own projects.
Basically there are two options,
1. Direct database reporting.
This is obviously the easiest in terms of code, but if you want object based reporting it's a little tricky since the data is relational and in some cases you have to try to join things up in Crystal, etc.
2. Using Datasets supplied by your application to Crystal.
Crystal is still record by record based reporting and there is no easy way to make it otherwise (if only it were!). However to save the SQL hassles on the reporting side, you can actually do your object filtering, etc in your application and send crystal a data set that mimics the structure of your objects and then report on that.
See crystal for how to report on datasets (you need to create a schema before hand, etc).
I hope that gives you a pointer or two.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The information I learn here I will thankfully post in the AtomsFramework WIKI. In General what are good strategies for reporting and AtomsFramework. Can packages such as Crystal Reports (CR) be integrated with Atoms framework? Typically Crystal Reports directly accesses the SQL server. But I was wondering is there is any strategies for integrating CR with AtomsFramwork?
Hi Terrance,
I'm not sure what you mean by direct integration of Crystal with the AtomsFramework so I'll explain how I've done things in my own projects.
Basically there are two options,
1. Direct database reporting.
This is obviously the easiest in terms of code, but if you want object based reporting it's a little tricky since the data is relational and in some cases you have to try to join things up in Crystal, etc.
2. Using Datasets supplied by your application to Crystal.
Crystal is still record by record based reporting and there is no easy way to make it otherwise (if only it were!). However to save the SQL hassles on the reporting side, you can actually do your object filtering, etc in your application and send crystal a data set that mimics the structure of your objects and then report on that.
See crystal for how to report on datasets (you need to create a schema before hand, etc).
I hope that gives you a pointer or two.