Creating reports and dashboards | Stimulsoft community forum

Hi:
Thanks again for your time.

I really have a big design dude. At this moment I'm a third party app for create DAL tiers. The question is when defininig the report in Stimulsoft:

a) pass a parameter and let stimulsoft do the logic por data access and filter the information.

b) via DAL filter the information, some join operations and send a final dataset to stimulsoft. Here may be the datasource definition is smallest


May be for someone a) could be the best solution, and b) for others, but this post is just for get some feedback from support team.

Thanks.

A lot of things depend on what way your application work with data. StimulReport.Net can work with data in two modes:

1. Data which are passed in ready state through the RegData method and are stored in Data Store.

2. Data which report generator loads itself using sql queries or the direct xml load.

Using bands data can be filtered, sorted, grouped and it does not matter how they have been got.

In latest builds the ability to create special data sources which contain processed data from other data sources is entered.

The following factors are to be taken into consideration before you will make a decision:

1. If your application is already contains all necessary data you shouldn’t load them again in report engine.
It is better pass them to the report generator in ready state.

2. How will you work with relations. StimulReport.Net can work with relations in all modes but principle of work with sql data is slightly different.

3. You should remember about redundancy of data. In other words there is no need to load all data in your report and then filter them.
This may slow down rendering of your report.
To make you more elaborate recommendations we have to know more details about your project.