Creating reports and dashboards | Stimulsoft community forum

Hi,

i'm missing the user documentation for the charting control.

I've tried to use the charting control and i'm wondering how to use something like a count of detail entries in a master detail relation.

For example: I have 1 table Locations and a table Employees and a foreig key relation from Employee to Locations. I modelled these in the dictionary and tried to display the count(EmployeeIDs) at a Location.

How do i have to do that. (by the way - i don't want to use the grouping and counting in the sql statement)

thanks

markus

markusw wrote:Hi,

i'm missing the user documentation for the charting control.

I've tried to use the charting control and i'm wondering how to use something like a count of detail entries in a master detail relation.

For example: I have 1 table Locations and a table Employees and a foreig key relation from Employee to Locations. I modelled these in the dictionary and tried to display the count(EmployeeIDs) at a Location.

How do i have to do that. (by the way - i don't want to use the grouping and counting in the sql statement)

thanks

markus

New version of StimulReport.Net represents new DataSources Data from other DataSource. These DataSources are based on the data from other datasources which are registered in the Report. Rows in that DataSource are result of grouping, sorting, filtering data from other datasources of Report. In other words these Datasources give you ability to join tables and to apply aggregate functions to the resulting sets of row.
In your case you have to do the following steps.
1. Create relation between Employees and Locations Datasources in Report.
2. Register new DataSource EmployeesByLocations of type Data from other DataSource based on Employees.
3. Add grouping by Locations to the EmployeesByLocations and add sorting for example by Employee LastName.
4. Build as usually a chart with data from EmployeesByLocations.
Please contact for the latest build (specify .Net version you are using).
Thank you.