Delaying data load of business objects at rendering time
Posted: Mon Apr 24, 2017 11:58 am
Hello,
We are currently using the .Net reporting component by connecting directly to the database. However, this will no longer be possible anymore as the end user will not be able to connect directly. Therefore, I am exploring other ways to get data from the DB. I have tried working with the business objects which look like a great way of exposing business data while preventing the end user to write SQL.
I have made a sample that loads data from our DB and registers a BO thanks to the documentation ; however, it looks like I have to load the data from the DB at the same time as I register the object. This is not very practical, since I would like to load the data only when needed (e.g. when doing a preview of a report). As of today, I must load all data from all objects when registering them.
Is there anything I have missed ? Am I doing this the right way or is there an easier way to achieve my goal (i.e. exposing business data without direct access to the DB) ?
Thank you for your help !
We are currently using the .Net reporting component by connecting directly to the database. However, this will no longer be possible anymore as the end user will not be able to connect directly. Therefore, I am exploring other ways to get data from the DB. I have tried working with the business objects which look like a great way of exposing business data while preventing the end user to write SQL.
I have made a sample that loads data from our DB and registers a BO thanks to the documentation ; however, it looks like I have to load the data from the DB at the same time as I register the object. This is not very practical, since I would like to load the data only when needed (e.g. when doing a preview of a report). As of today, I must load all data from all objects when registering them.
Is there anything I have missed ? Am I doing this the right way or is there an easier way to achieve my goal (i.e. exposing business data without direct access to the DB) ?
Thank you for your help !